REST API: SQL Exported Keys

Obtain a list of exported keys associated with the data source. The SQL Exported Keys service implements the CA IDMS Server JDBC API method getExportedKeys within the class IdmsDatabaseMetaData.
HTTP Method and URI Path
The URI path has the following format:
GET
<base URL>
/sql/exportedKeys/
<datasource>
?
<query parameters>
Where:
  • <base URL>
    Specifies the base URL address for the CA IDMS REST API service
  • <datasource>
    (required) Identifies the CA IDMS system where the API request is to be sent and is defined in the datasources.yml file
  • <query parameters>
    • schema --
      Identifies the name of the Schema. If
      schema
      is not specified, the default Schema is used (if one exists). This parameter is case-sensitive and must match the Schema name exactly.
    • table --
      (required) Identifies the name of the table. This parameter is case-sensitive and must match the table name exactly.
Example: Returns the exported keys for the given Schema and table
https://zoshost.domain.com:10010/api/v1/sql/exportedKeys/SYSDEMO?schema=DEMOEMPL&table=EMPLOYEE
Response:
{ "exportedKeys": [ { "primaryKeyTableCatalog": null, "primaryKeyTableSchema": "DEMOEMPL", "primaryKeyTableName": "EMPLOYEE", "primaryKeyColumnName": "EMP_ID", "foreignKeyTableCatalog": null, "foreignKeyTableSchema": "DEMOEMPL", "foreignKeyTableName": "BENEFITS", "foreignKeyColumnName": "EMP_ID", "keySequence": 1, "updateRule": 3, "deleteRule": 3, "foreignKeyName": "EMP_BENEFITS", "primaryKeyName": "CALC", "deferrability": 7 }, { "primaryKeyTableCatalog": null, "primaryKeyTableSchema": "DEMOEMPL", "primaryKeyTableName": "EMPLOYEE", "primaryKeyColumnName": "EMP_ID", "foreignKeyTableCatalog": null, "foreignKeyTableSchema": "DEMOEMPL", "foreignKeyTableName": "COVERAGE", "foreignKeyColumnName": "EMP_ID", "keySequence": 1, "updateRule": 3, "deleteRule": 3, "foreignKeyName": "EMP_COVERAGE", "primaryKeyName": "CALC", "deferrability": 7 }, { "primaryKeyTableCatalog": null, "primaryKeyTableSchema": "DEMOEMPL", "primaryKeyTableName": "EMPLOYEE", "primaryKeyColumnName": "EMP_ID", "foreignKeyTableCatalog": null, "foreignKeyTableSchema": "DEMOEMPL", "foreignKeyTableName": "DEPARTMENT", "foreignKeyColumnName": "DEPT_HEAD_ID", "keySequence": 1, "updateRule": 3, "deleteRule": 3, "foreignKeyName": "EMP_DEPT_HEAD", "primaryKeyName": "CALC", "deferrability": 7 }, { "primaryKeyTableCatalog": null, "primaryKeyTableSchema": "DEMOEMPL", "primaryKeyTableName": "EMPLOYEE", "primaryKeyColumnName": "EMP_ID", "foreignKeyTableCatalog": null, "foreignKeyTableSchema": "DEMOEMPL", "foreignKeyTableName": "DIVISION", "foreignKeyColumnName": "DIV_HEAD_ID", "keySequence": 1, "updateRule": 3, "deleteRule": 3, "foreignKeyName": "EMP_DIV_HEAD", "primaryKeyName": "CALC", "deferrability": 7 }, { "primaryKeyTableCatalog": null, "primaryKeyTableSchema": "DEMOEMPL", "primaryKeyTableName": "EMPLOYEE", "primaryKeyColumnName": "EMP_ID", "foreignKeyTableCatalog": null, "foreignKeyTableSchema": "DEMOEMPL", "foreignKeyTableName": "EMPLOYEE", "foreignKeyColumnName": "MANAGER_ID", "keySequence": 1, "updateRule": 3, "deleteRule": 3, "foreignKeyName": "MANAGER_EMP", "primaryKeyName": "CALC", "deferrability": 7 }, { "primaryKeyTableCatalog": null, "primaryKeyTableSchema": "DEMOEMPL", "primaryKeyTableName": "EMPLOYEE", "primaryKeyColumnName": "EMP_ID", "foreignKeyTableCatalog": null, "foreignKeyTableSchema": "DEMOEMPL", "foreignKeyTableName": "POSITION", "foreignKeyColumnName": "EMP_ID", "keySequence": 1, "updateRule": 3, "deleteRule": 3, "foreignKeyName": "EMP_POSITION", "primaryKeyName": "CALC", "deferrability": 7 } ], "errors": [] }