GET (Specified Table Alerts) - Teradata Ecosystem Manager

Teradata Ecosystem Manager API Reference

Product
Teradata Ecosystem Manager
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
qvc1470238851347.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-3204
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Get table alerts.

URL

/emrest/datadiscovery/database/{database-name}/tables/{table-name}/alerts

HTTP Method

GET

Request Parameters

Path variable:database-name

Response

A array of the following JSON.

Name Description Data Type
alert_code Alert code Integer
database_name Name of the database String
effective_ts Effective timestamp in UTC String
severity_level Alert severity level String
uow_id Unit of work ID String
job_name Name of job String
message Alert message if any String
database_name Name of database String
table_name Name of the table String
server_name Name of the server 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: Get Table Alerts

[
    {
        "alert_code": 1009,
        "table_name": "emresttesttbl2",
        "database_name": "emresttestdb",
        "message": "Failure message",
        "effective_ts": "2015-12-27T18:47:28.000Z",
        "job_name": "job_rd",
        "uow_id": "uowid_1",
        "server_name": "wario",
        "severity_level": "Warning"
    },
    {
        "alert_code": 1009,
        "table_name": "emresttesttbl2",
        "database_name": "emresttestdb",
        "effective_ts": "2015-12-27T18:49:31.000Z",
        "job_name": "job_au",
        "uow_id": "uowid_2",
        "server_name": "falco",
        "severity_level": "Warning"
    }
]