Trigger transaction type metadata reconstruction

post/admin/transactions/{transactionTypeId}/reconstruct

Internal-Use Only

Synchronizes the transaction type's field metadata with the schema for the database table that contains the transaction type's records. This can be used to repair the transaction type's metadata if the table that backs the transaction 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

application/json
1

Response Samples

200
application/json
1{
2  "id": 103401,
3  "createdBy": "videmo",
4  "createdAt": "2023-06-30T15:38:17.241Z",
5  "lastUpdatedBy": "videmo",
6  "lastUpdatedAt": "2023-06-30T15:38:17.241Z",
7  "label": "Business Transactions",
8  "localizedLabels": [
9    {
10      "id": 103618,
11      "createdBy": "videmo",
12      "createdAt": "2023-06-30T15:38:17.246Z",
13      "lastUpdatedBy": "videmo",
14      "lastUpdatedAt": "2023-06-30T15:38:17.246Z",
15      "label": "Business Transactions",
16      "version": 0,
17      "localeCd": "en-US"
18    }
19  ],
20  "name": "business_transactions",
21  "dataStoreName": "FINANCE_STORE",
22  "dataStoreDefaultSchemaName": "finance",
23  "tableName": "business_transactions",
24  "systemReserved": false,
25  "version": 0,
26  "dataStoreAssignedTimeZone": "Etc/UTC",
27  "solutionName": "sas_visual_investigator_default",
28  "solutionLabel": "SAS Visual Investigator",
29  "fromObjectName": "business_account",
30  "toObjectName": "business_customers",
31  "fromObjJoinCondition": {
32    "type": "Conditional",
33    "leftOperand": {
34      "type": "FieldRef",
35      "objectName": "business_account",
36      "fieldName": "primary_account_number"
37    },
38    "rightOperands": [
39      {
40        "type": "FieldRef",
41        "objectName": "^RELATION^",
42        "fieldName": "primary_account_number"
43      }
44    ],
45    "operator": "EQ"
46  },
47  "toObjJoinCondition": {
48    "type": "Conditional",
49    "leftOperand": {
50      "type": "FieldRef",
51      "objectName": "^RELATION^",
52      "fieldName": "customer_id_number"
53    },
54    "rightOperands": [
55      {
56        "type": "FieldRef",
57        "objectName": "business_customers",
58        "fieldName": "customer_id_number"
59      }
60    ],
61    "operator": "EQ"
62  },
63  "fields": [
64    {
65      "id": 103533,
66      "createdBy": "videmo",
67      "createdAt": "2023-06-30T15:38:17.248Z",
68      "lastUpdatedBy": "videmo",
69      "lastUpdatedAt": "2023-06-30T15:38:17.248Z",
70      "label": "Transaction Id",
71      "localizedLabels": [
72        {
73          "id": 103619,
74          "createdBy": "videmo",
75          "createdAt": "2023-06-30T15:38:17.248Z",
76          "lastUpdatedBy": "videmo",
77          "lastUpdatedAt": "2023-06-30T15:38:17.248Z",
78          "label": "Transaction Id",
79          "version": 0,
80          "localeCd": "en-US"
81        }
82      ],
83      "name": "transaction_id",
84      "columnName": "transaction_id",
85      "dataType": "STRING",
86      "length": 14,
87      "required": true,
88      "primaryKeyField": true,
89      "unique": false,
90      "autoGenerated": false,
91      "systemReserved": false,
92      "displayIndex": 0,
93      "version": 0,
94      "primaryKeySeqNo": 1,
95      "readOnly": true,
96      "indexedForSearch": true,
97      "showTimeZone": false,
98      "ownerName": "business_transactions",
99      "masked": false,
100      "primaryKeyUserSelected": false
101    },
102    {
103      "id": 103534,
104      "createdBy": "videmo",
105      "createdAt": "2023-06-30T15:38:17.249Z",
106      "lastUpdatedBy": "videmo",
107      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
108      "label": "Customer Id Number",
109      "localizedLabels": [
110        {
111          "id": 103620,
112          "createdBy": "videmo",
113          "createdAt": "2023-06-30T15:38:17.249Z",
114          "lastUpdatedBy": "videmo",
115          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
116          "label": "Customer Id Number",
117          "version": 0,
118          "localeCd": "en-US"
119        }
120      ],
121      "name": "customer_id_number",
122      "columnName": "customer_id_number",
123      "dataType": "NUMERIC",
124      "precision": 32,
125      "scale": 0,
126      "required": false,
127      "primaryKeyField": false,
128      "unique": false,
129      "autoGenerated": false,
130      "systemReserved": false,
131      "displayIndex": 1,
132      "version": 0,
133      "readOnly": true,
134      "indexedForSearch": true,
135      "showTimeZone": false,
136      "ownerName": "business_transactions",
137      "masked": false,
138      "primaryKeyUserSelected": false
139    },
140    {
141      "id": 103535,
142      "createdBy": "videmo",
143      "createdAt": "2023-06-30T15:38:17.249Z",
144      "lastUpdatedBy": "videmo",
145      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
146      "label": "Primary Account Number",
147      "localizedLabels": [
148        {
149          "id": 103621,
150          "createdBy": "videmo",
151          "createdAt": "2023-06-30T15:38:17.249Z",
152          "lastUpdatedBy": "videmo",
153          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
154          "label": "Primary Account Number",
155          "version": 0,
156          "localeCd": "en-US"
157        }
158      ],
159      "name": "primary_account_number",
160      "columnName": "primary_account_number",
161      "dataType": "NUMERIC",
162      "precision": 32,
163      "scale": 0,
164      "required": false,
165      "primaryKeyField": false,
166      "unique": false,
167      "autoGenerated": false,
168      "systemReserved": false,
169      "displayIndex": 2,
170      "version": 0,
171      "readOnly": true,
172      "indexedForSearch": true,
173      "showTimeZone": false,
174      "ownerName": "business_transactions",
175      "masked": false,
176      "primaryKeyUserSelected": false
177    },
178    {
179      "id": 103536,
180      "createdBy": "videmo",
181      "createdAt": "2023-06-30T15:38:17.249Z",
182      "lastUpdatedBy": "videmo",
183      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
184      "label": "Transaction Date",
185      "localizedLabels": [
186        {
187          "id": 103622,
188          "createdBy": "videmo",
189          "createdAt": "2023-06-30T15:38:17.249Z",
190          "lastUpdatedBy": "videmo",
191          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
192          "label": "Transaction Date",
193          "version": 0,
194          "localeCd": "en-US"
195        }
196      ],
197      "name": "transaction_date",
198      "columnName": "transaction_date",
199      "dataType": "TIMESTAMP_WITH_TIME_ZONE",
200      "required": false,
201      "primaryKeyField": false,
202      "unique": false,
203      "autoGenerated": false,
204      "systemReserved": false,
205      "displayIndex": 3,
206      "version": 0,
207      "readOnly": true,
208      "indexedForSearch": true,
209      "showTimeZone": false,
210      "ownerName": "business_transactions",
211      "masked": false,
212      "primaryKeyUserSelected": false
213    },
214    {
215      "id": 103537,
216      "createdBy": "videmo",
217      "createdAt": "2023-06-30T15:38:17.249Z",
218      "lastUpdatedBy": "videmo",
219      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
220      "label": "Id",
221      "localizedLabels": [
222        {
223          "id": 103623,
224          "createdBy": "videmo",
225          "createdAt": "2023-06-30T15:38:17.249Z",
226          "lastUpdatedBy": "videmo",
227          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
228          "label": "Id",
229          "version": 0,
230          "localeCd": "en-US"
231        }
232      ],
233      "name": "id",
234      "columnName": "id",
235      "dataType": "STRING",
236      "length": 2,
237      "required": false,
238      "primaryKeyField": false,
239      "unique": false,
240      "autoGenerated": false,
241      "systemReserved": false,
242      "displayIndex": 4,
243      "version": 0,
244      "readOnly": true,
245      "indexedForSearch": true,
246      "showTimeZone": false,
247      "ownerName": "business_transactions",
248      "masked": false,
249      "primaryKeyUserSelected": false
250    },
251    {
252      "id": 103538,
253      "createdBy": "videmo",
254      "createdAt": "2023-06-30T15:38:17.249Z",
255      "lastUpdatedBy": "videmo",
256      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
257      "label": "Tran Desc",
258      "localizedLabels": [
259        {
260          "id": 103624,
261          "createdBy": "videmo",
262          "createdAt": "2023-06-30T15:38:17.249Z",
263          "lastUpdatedBy": "videmo",
264          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
265          "label": "Tran Desc",
266          "version": 0,
267          "localeCd": "en-US"
268        }
269      ],
270      "name": "tran_desc",
271      "columnName": "tran_desc",
272      "dataType": "STRING",
273      "length": 24,
274      "required": false,
275      "primaryKeyField": false,
276      "unique": false,
277      "autoGenerated": false,
278      "systemReserved": false,
279      "displayIndex": 5,
280      "version": 0,
281      "readOnly": true,
282      "indexedForSearch": true,
283      "showTimeZone": false,
284      "ownerName": "business_transactions",
285      "masked": false,
286      "primaryKeyUserSelected": false
287    },
288    {
289      "id": 103539,
290      "createdBy": "videmo",
291      "createdAt": "2023-06-30T15:38:17.249Z",
292      "lastUpdatedBy": "videmo",
293      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
294      "label": "Orig Tran Amt Cash",
295      "localizedLabels": [
296        {
297          "id": 103625,
298          "createdBy": "videmo",
299          "createdAt": "2023-06-30T15:38:17.249Z",
300          "lastUpdatedBy": "videmo",
301          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
302          "label": "Orig Tran Amt Cash",
303          "version": 0,
304          "localeCd": "en-US"
305        }
306      ],
307      "name": "orig_tran_amt_cash",
308      "columnName": "orig_tran_amt_cash",
309      "dataType": "NUMERIC",
310      "precision": 15,
311      "scale": 2,
312      "required": false,
313      "primaryKeyField": false,
314      "unique": false,
315      "autoGenerated": false,
316      "systemReserved": false,
317      "displayIndex": 6,
318      "version": 0,
319      "readOnly": true,
320      "indexedForSearch": true,
321      "showTimeZone": false,
322      "ownerName": "business_transactions",
323      "masked": false,
324      "primaryKeyUserSelected": false
325    },
326    {
327      "id": 103540,
328      "createdBy": "videmo",
329      "createdAt": "2023-06-30T15:38:17.249Z",
330      "lastUpdatedBy": "videmo",
331      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
332      "label": "Tran Unique Id",
333      "localizedLabels": [
334        {
335          "id": 103626,
336          "createdBy": "videmo",
337          "createdAt": "2023-06-30T15:38:17.249Z",
338          "lastUpdatedBy": "videmo",
339          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
340          "label": "Tran Unique Id",
341          "version": 0,
342          "localeCd": "en-US"
343        }
344      ],
345      "name": "tran_unique_id",
346      "columnName": "tran_unique_id",
347      "dataType": "STRING",
348      "length": 25,
349      "required": false,
350      "primaryKeyField": false,
351      "unique": false,
352      "autoGenerated": false,
353      "systemReserved": false,
354      "displayIndex": 7,
355      "version": 0,
356      "readOnly": true,
357      "indexedForSearch": true,
358      "showTimeZone": false,
359      "ownerName": "business_transactions",
360      "masked": false,
361      "primaryKeyUserSelected": false
362    }
363  ],
364  "readOnly": true,
365  "transactionDateFieldName": "transaction_date"
366}

Path Parameters

Name	Type	Required	Description
transactionTypeId	string	true	The numerical ID of the transaction type object.

Request Body

The request body should be empty.

APIDoc.noSchema.msg

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 transaction type with a matching ID or the transaction type was found but the table backing it was not found.	Schema