The Teradata Mapp DMP supports using external data to enrich your reports. With this API you can forward the data directly without any human interaction.
...
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
...
The following parameters can be used:
| Parameters | Description |
|---|---|
| id | Required.Custom data source ID. |
| payload | Required. Set of mutations (see below) |
Payload contents
JSON:
| Code Block |
|---|
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:
| Code Block |
|---|
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> |