UpsertData-Async-V2
There are two versions of UpsertData API calls, synchronous and asynchronous. This particular version is the asynchronous version (V2) where no more than 1000 records rows are subject to be inserted/updated on a data table at in a single call.
The method is used to insert bulk new records or update existing ones on a data table except master_contact table.
If the target data table has primary key values, UpsertData call has to include these primary key values in input data rows as well as the rest of the to-be-updated column values.
If the target data table has no primary key values, UpsertData appends input data rows to the data table.
Input data row has to include all the column values of the target data table, otherwise an error will be returned.
If the operation is successful, the async upsert request will be sent to the system. This request returns a job id (transactionId) assigned to this async upsert job. This job id can be used to check the status of the job via this endpoint:
GET https://api.dengage.com/rest/dataspace/async/upsert_v2/{jobId}
Important Note
If there is multiple data affecting the same row, the data in the last request will be upserted.
Important Note
You can form the request body in two different ways by using either of the following input parameters
OPTION 1: Using tableId which is the uuid of the data table
OPTION 2: Using tableName which is the name of the data table
DateTime Format:
- yyyy-MM-dd
- yyyy-MM-dd HH:mm
- yyyy-MM-ddTHH:mm
- yyyy-MM-dd HH:mm:ss
- yyyy-MM-ddTHH:mm:ss
- yyyy-MM-dd HH:mm:ss.f
- yyyy-MM-dd HH:mm:ss.ff
- yyyy-MM-dd HH:mm:ss.fff
- yyyy-MM-ddTHH:mm:ss.f
- yyyy-MM-ddTHH:mm:ss.ff
- yyyy-MM-ddTHH:mm:ss.fff
- yyyy-MM-ddTHH:mm:ssZ
- yyyy-MM-ddTHH:mm:ss.fffZ