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    },
101    {
102      "id": 103534,
103      "createdBy": "videmo",
104      "createdAt": "2023-06-30T15:38:17.249Z",
105      "lastUpdatedBy": "videmo",
106      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
107      "label": "Customer Id Number",
108      "localizedLabels": [
109        {
110          "id": 103620,
111          "createdBy": "videmo",
112          "createdAt": "2023-06-30T15:38:17.249Z",
113          "lastUpdatedBy": "videmo",
114          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
115          "label": "Customer Id Number",
116          "version": 0,
117          "localeCd": "en-US"
118        }
119      ],
120      "name": "customer_id_number",
121      "columnName": "customer_id_number",
122      "dataType": "NUMERIC",
123      "precision": 32,
124      "scale": 0,
125      "required": false,
126      "primaryKeyField": false,
127      "unique": false,
128      "autoGenerated": false,
129      "systemReserved": false,
130      "displayIndex": 1,
131      "version": 0,
132      "readOnly": true,
133      "indexedForSearch": true,
134      "showTimeZone": false,
135      "ownerName": "business_transactions",
136      "masked": false
137    },
138    {
139      "id": 103535,
140      "createdBy": "videmo",
141      "createdAt": "2023-06-30T15:38:17.249Z",
142      "lastUpdatedBy": "videmo",
143      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
144      "label": "Primary Account Number",
145      "localizedLabels": [
146        {
147          "id": 103621,
148          "createdBy": "videmo",
149          "createdAt": "2023-06-30T15:38:17.249Z",
150          "lastUpdatedBy": "videmo",
151          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
152          "label": "Primary Account Number",
153          "version": 0,
154          "localeCd": "en-US"
155        }
156      ],
157      "name": "primary_account_number",
158      "columnName": "primary_account_number",
159      "dataType": "NUMERIC",
160      "precision": 32,
161      "scale": 0,
162      "required": false,
163      "primaryKeyField": false,
164      "unique": false,
165      "autoGenerated": false,
166      "systemReserved": false,
167      "displayIndex": 2,
168      "version": 0,
169      "readOnly": true,
170      "indexedForSearch": true,
171      "showTimeZone": false,
172      "ownerName": "business_transactions",
173      "masked": false
174    },
175    {
176      "id": 103536,
177      "createdBy": "videmo",
178      "createdAt": "2023-06-30T15:38:17.249Z",
179      "lastUpdatedBy": "videmo",
180      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
181      "label": "Transaction Date",
182      "localizedLabels": [
183        {
184          "id": 103622,
185          "createdBy": "videmo",
186          "createdAt": "2023-06-30T15:38:17.249Z",
187          "lastUpdatedBy": "videmo",
188          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
189          "label": "Transaction Date",
190          "version": 0,
191          "localeCd": "en-US"
192        }
193      ],
194      "name": "transaction_date",
195      "columnName": "transaction_date",
196      "dataType": "TIMESTAMP_WITH_TIME_ZONE",
197      "required": false,
198      "primaryKeyField": false,
199      "unique": false,
200      "autoGenerated": false,
201      "systemReserved": false,
202      "displayIndex": 3,
203      "version": 0,
204      "readOnly": true,
205      "indexedForSearch": true,
206      "showTimeZone": false,
207      "ownerName": "business_transactions",
208      "masked": false
209    },
210    {
211      "id": 103537,
212      "createdBy": "videmo",
213      "createdAt": "2023-06-30T15:38:17.249Z",
214      "lastUpdatedBy": "videmo",
215      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
216      "label": "Id",
217      "localizedLabels": [
218        {
219          "id": 103623,
220          "createdBy": "videmo",
221          "createdAt": "2023-06-30T15:38:17.249Z",
222          "lastUpdatedBy": "videmo",
223          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
224          "label": "Id",
225          "version": 0,
226          "localeCd": "en-US"
227        }
228      ],
229      "name": "id",
230      "columnName": "id",
231      "dataType": "STRING",
232      "length": 2,
233      "required": false,
234      "primaryKeyField": false,
235      "unique": false,
236      "autoGenerated": false,
237      "systemReserved": false,
238      "displayIndex": 4,
239      "version": 0,
240      "readOnly": true,
241      "indexedForSearch": true,
242      "showTimeZone": false,
243      "ownerName": "business_transactions",
244      "masked": false
245    },
246    {
247      "id": 103538,
248      "createdBy": "videmo",
249      "createdAt": "2023-06-30T15:38:17.249Z",
250      "lastUpdatedBy": "videmo",
251      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
252      "label": "Tran Desc",
253      "localizedLabels": [
254        {
255          "id": 103624,
256          "createdBy": "videmo",
257          "createdAt": "2023-06-30T15:38:17.249Z",
258          "lastUpdatedBy": "videmo",
259          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
260          "label": "Tran Desc",
261          "version": 0,
262          "localeCd": "en-US"
263        }
264      ],
265      "name": "tran_desc",
266      "columnName": "tran_desc",
267      "dataType": "STRING",
268      "length": 24,
269      "required": false,
270      "primaryKeyField": false,
271      "unique": false,
272      "autoGenerated": false,
273      "systemReserved": false,
274      "displayIndex": 5,
275      "version": 0,
276      "readOnly": true,
277      "indexedForSearch": true,
278      "showTimeZone": false,
279      "ownerName": "business_transactions",
280      "masked": false
281    },
282    {
283      "id": 103539,
284      "createdBy": "videmo",
285      "createdAt": "2023-06-30T15:38:17.249Z",
286      "lastUpdatedBy": "videmo",
287      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
288      "label": "Orig Tran Amt Cash",
289      "localizedLabels": [
290        {
291          "id": 103625,
292          "createdBy": "videmo",
293          "createdAt": "2023-06-30T15:38:17.249Z",
294          "lastUpdatedBy": "videmo",
295          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
296          "label": "Orig Tran Amt Cash",
297          "version": 0,
298          "localeCd": "en-US"
299        }
300      ],
301      "name": "orig_tran_amt_cash",
302      "columnName": "orig_tran_amt_cash",
303      "dataType": "NUMERIC",
304      "precision": 15,
305      "scale": 2,
306      "required": false,
307      "primaryKeyField": false,
308      "unique": false,
309      "autoGenerated": false,
310      "systemReserved": false,
311      "displayIndex": 6,
312      "version": 0,
313      "readOnly": true,
314      "indexedForSearch": true,
315      "showTimeZone": false,
316      "ownerName": "business_transactions",
317      "masked": false
318    },
319    {
320      "id": 103540,
321      "createdBy": "videmo",
322      "createdAt": "2023-06-30T15:38:17.249Z",
323      "lastUpdatedBy": "videmo",
324      "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
325      "label": "Tran Unique Id",
326      "localizedLabels": [
327        {
328          "id": 103626,
329          "createdBy": "videmo",
330          "createdAt": "2023-06-30T15:38:17.249Z",
331          "lastUpdatedBy": "videmo",
332          "lastUpdatedAt": "2023-06-30T15:38:17.249Z",
333          "label": "Tran Unique Id",
334          "version": 0,
335          "localeCd": "en-US"
336        }
337      ],
338      "name": "tran_unique_id",
339      "columnName": "tran_unique_id",
340      "dataType": "STRING",
341      "length": 25,
342      "required": false,
343      "primaryKeyField": false,
344      "unique": false,
345      "autoGenerated": false,
346      "systemReserved": false,
347      "displayIndex": 7,
348      "version": 0,
349      "readOnly": true,
350      "indexedForSearch": true,
351      "showTimeZone": false,
352      "ownerName": "business_transactions",
353      "masked": false
354    }
355  ],
356  "readOnly": true,
357  "transactionDateFieldName": "transaction_date"
358}

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.

No schema defined

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