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
}