Create/Update OR Delete transformed data overrides for a specific export in a database. A primary key must be set for the database.

Authentication

AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

Path parameters

db_idintegerRequired
ID of the database to get transformed data from
export_idintegerRequired

ID of the export to add transformed data to (0 if all)

Headers

x-api-keystringRequired

Request

Create/Update or Delete transformed data overrides (TDOs)

data_row_idstringRequired
The id of the TDO
join_valuestringRequired

The value of the primary-key-column in the target data row

override_fieldstringRequired
The target column to override
override_valuestringRequired
The value that column will be set to
deletebooleanOptional

Set to ‘true’ to specify deletion of given TDO. Note: deletes and creates/updates must be done in separate requests.

Response

Success
row_addeddouble

The count of TDOs successfully created and/or updated

tdos_ignoreddouble

The count of TDOs ignored in this request due to the override_field being empty or not matching an export field

Errors

400
Bad Request Error