Purpose
Get specified table details.
URL
/emrest/datadiscovery/databases/{database-name}/tables/{table-name}
HTTP Method
GET
Request Parameters
Path variable:database-name, table-name
Response
Response body in JSON with the following parameters.
Name | Description | Data Type |
---|---|---|
database_name | Name of the database | String |
table_name | Name of the table | String |
sync_condition | Sync condition of the table | String |
sync_job_status | Sync job status of table | String |
validation_configured | Boolean indicating whether the table has validation configured | Boolean |
sync_job_configured | Boolean indicating whether the sync job is configured for the table | Boolean |
servers | Server details for the database | Any array of JSON (Shown in Servers JSON Description table.) |
Name | Description | Data Type |
---|---|---|
server_name | Name of the server | String |
unity_managed | Boolean indicating whether it is a Unity Managed table | Boolean |
state | State of the table | String |
Status
A status code of 200 is returned on a successful completion. A non-200 status code is returned if an error occurs.
Example: Getting Table Details using the API
{ "table_name": "MSMEcosystem", "database_name": "EMViews", "servers": [ { "server_name": "banjo", "state": "Active", "unity_managed": false }, { "server_name": "falco", "state": "Active", "unity_managed": false } ], "sync_condition": "Normal", "sync_job_configured": false, "validation_configured": true }