Trigger relationship type metadata reconstruction

post/admin/relationships/{relationshipTypeId}/reconstruct

Synchronizes the relationship type's field metadata with the schema for the database table that contains the relationship type's records. This can be used to repair the relationship type's metadata if the table that backs the relationship type changes. Care should be taken when using this operation as it does not automatically update other services in SAS Visual Investigator to reflect the metadata changes. Users who do not understand how their metadata is used in SAS Visual Investigator or are not prepared to repair inconsistencies downstream from Data Hub are not advised to use this endpoint. The request body should be empty.

Request Samples

Response Samples


1{
2  "id": "string",
3  "createdBy": "string",
4  "createdAt": "2019-08-24T14:15:22Z",
5  "lastUpdatedBy": "string",
6  "lastUpdatedAt": "2019-08-24T14:15:22Z",
7  "label": "string",
8  "description": "string",
9  "localizedLabels": [
10    {
11      "version": 0,
12      "locale": "en-US",
13      "label": "string"
14    }
15  ],
16  "localizedDescriptions": [
17    {
18      "version": 0,
19      "locale": "en-US",
20      "description": "string"
21    }
22  ],
23  "name": "string",
24  "dataStoreName": "string",
25  "tableName": "string",
26  "systemReserved": true,
27  "historyEnabled": true,
28  "version": 0,
29  "validFromFieldName": "string",
30  "validToFieldName": "string",
31  "lastUpdatedAtTimeFieldName": "string",
32  "createdAtTimeFieldName": "string",
33  "displayTextFields": [
34    {
35      "name": "string",
36      "displayIndex": 0
37    }
38  ],
39  "dataStoreAssignedTimeZone": "string",
40  "reverseName": "string",
41  "reverseLabel": "string",
42  "fromObjectName": "string",
43  "fromObjectLabel": "string",
44  "toObjectName": "string",
45  "toObjectLabel": "string",
46  "required": true,
47  "cardinality": "ONE_TO_ONE",
48  "sortCriteria": {
49    "fieldName": "string",
50    "sortOrder": "asc"
51  },
52  "type": "DIRECT_CHILD",
53  "symmetric": true,
54  "managed": true,
55  "toObjectTypeFieldName": "string",
56  "toObjectTypeNames": [
57    "string"
58  ],
59  "joinKeyFieldName": "string",
60  "joinConditions": [
61    {
62      "type": "FieldRef"
63    }
64  ],
65  "fields": [
66    {
67      "name": "string",
68      "columnName": "string",
69      "dataType": "BOOLEAN",
70      "length": 0,
71      "precision": 0,
72      "scale": 0,
73      "required": true,
74      "primaryKeyField": true,
75      "unique": true,
76      "autoGenerated": true,
77      "systemReserved": true,
78      "displayIndex": 0,
79      "version": 0,
80      "constrainingListName": "string",
81      "userSelectionStrategy": "USERS",
82      "allowMultipleSelections": true,
83      "primaryKeySeqNo": 0,
84      "readOnly": true,
85      "indexedForSearch": true,
86      "logicalDataType": "USER_GROUP",
87      "ownerName": "string"
88    }
89  ],
90  "localizedReverseLabels": [
91    {
92      "version": 0,
93      "locale": "en-US",
94      "label": "string"
95    }
96  ],
97  "deleteTableName": "string",
98  "useCustomIndex": true,
99  "color": "string",
100  "width": -1.7976931348623157e+308,
101  "dashType": "solid",
102  "styles": [
103    {
104      "id": "string",
105      "conditionId": "string",
106      "evaluationOrder": 0,
107      "color": "string",
108      "width": 0,
109      "dashType": "solid"
110    }
111  ],
112  "reindexRequired": true
113}

Path Parameters

Name	Type	Required	Description
relationshipTypeId	string	true	The numerical ID of the relationship type object.

Request Body

Request body should be empty.

Not Available

Responses

Status	Meaning	Description
200	OK	The request succeeded.	Schema
400	Bad Request	The request was invalid.	Schema
404	Not Found	The request did not find a relationship type with a matching ID or the relationship type was found but the table backing it was not found.	Schema