POST /hub/v1/dataevents/key:{key}/rowset
Use this API to upsert multiple data extension rows. An upsert operation updates rows when the specified key already exists and inserts new rows when the specified key doesn't exist.
The maximum payload size is 5 MB. As a best practice, update or insert a maximum of 50 columns and 50 records at a time.
| Name | Type | Description | |
|---|---|---|---|
| key | string | Required | The data extension external key, included in URL as key:{keyValue}. If you don’t provide an ID, you must provide an external key. |
| id | string | Required | The data extension ID, included in the URL. If you don’t provide an external key, you must provide an ID. |
| keys | object | Required | The key-value pair of the primary key for each row. |
| values | object | The column name and value for the row that you want to insert into the data extension. |
Example Request
Or
Example Response
If your request is invalid, the API returns a 400 response. This response includes additional details about the error.