The Teradata DMP supports using external data to enrich your reports. With this API you can forward the data directly without any human interaction.
| Contents on this page |
|---|
GET /api/manual-datasource
Description
List one / multiple data sources
Endpoint
/api/manual-datasource
Method
GET
The following query parameters can be used:
| Parameters | Description |
|---|---|
| id | Optional. Place a custom data source ID here to get a single result. |
| columns | Optional, only available if "id" supplied. Add the columns to the result. |
| data | Optional, only available if "id" supplied. Add the data to the result. Options: 0, 1 |
| limit | Optional, only available if "data" = '1'. Is used to determine amount of rows per request (default=100, max=100). |
| page | Optional, only available if "data" = '1'. Is used to step through the list of data. First page starts at 1. |
| column_filter | Optional, only available if "data" = '1'. Allows to only return a subset of columns. Comma separated. |
PUT /api/manual-datasource
Description
Update a data source
Endpoint
/api/manual-datasource
Method
PUT
The following parameters can be used:
| Parameters | Description |
|---|---|
| id | Required.Custom data source ID. |
| payload | Required. Set of mutations (see below) |
Payload contents
JSON:
payload_mode: 'json',
payload: {
"data": [{
"column_key1": "value1",
"column_key2": "value2"
}]
}
Legacy:
The payload is a typical data parameter, supporting deletions, modifications and additions to the already existing data set. Please refer to the example below which removes 1 row, changes 1 column in another row, and adds 2 entirely new rows:
payload['deleted'][]=<row_id>&payload['changed'][<row_id>][<column_name_A>]=<value_A>&payload['added'][0][<column_name_A>]=<value_A>&payload['added'][0][<column_name_B>]=<value_B>&payload['added'][1][<column_name_A>]=<value_A>&payload['added'][1][<column_name_B>]=<value_B>