Retrieve all foreign keys for a data object
Returns all foreign keys definitions in the data object.
Request Method | Service URL |
---|---|
|
/api-metadata/{access-key}/metadata/tables/{tableId}/foreignkeys
|
Request Headers |
|
Request URL Example
http://{AccountURL}/api-metadata/e2a7a0df2410470d85ef69c8dad2bdb8/metadata/tables/{tableId}/foreignkeys
Response Body Example
[
{
"tenantId": 0,
"name": "mastercustomer",
"versionTS": 1541803248262,
"active": true,
"createdTS": 1541803248262,
"tableId": "mastercustomer",
"dedupeTargetId": "Customer_MasterCustomer",
"mainIdentifier": "masterid",
"foreignKeyIds": {
"customer_mastercustomer": [
"Customer.ID.CustomerID"
]
}
}
]
Foreign keys entity metadata
- tenantId
- name
- versionTS
- active (true/false)
- createdTS
- type
- sourceAttribute
- sourceColumn
- destinationColumn
- destinationTable
- sourceTableId
- foreignKeyId