16.10 - GET (Specified Table) - Teradata Ecosystem Manager

Teradata Ecosystem Manager API Reference

prodname
Teradata Ecosystem Manager
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-3204-067K

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.)
Servers JSON Parameters
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
}