POST /data/v1/async/dataextensions/{id}/rows

Asynchronously insert data into an identified data extension by id or key. The id is the unique identifier of the data extension and key is the external key (customer key) of the data extension.

NameTypeDescription
idguidRequiredUnique identifier of the data extension. Required if not using a key.
keystringRequiredExternal customer key of the data extension. Required if not using an ID. Prepend the parameter with key:. For example, /dataextensions/key:{key}/rows.
NameTypeDescription
itemsarrayRequiredAn array of objects, where each object represents a row of data in the target data extension. Each object is expected to contain name-value pairs matching the column name and value of the target.
StatusNameTypeDescription
202  Accepted
 requestIdguidThe unique identifier of a successfully queued request. Use this ID in subsequent operations to retrieve the status or the results of the operation.

The request body consists of items, which is an array of json objects. Each object is expected to be a name-value pair that corresponds to the columns of the destination data extension. In this example, this data extension must have the fields FirstName, LastName, and ZipCode. Partial payloads are valid if they include all required fields.

A successfully queued request returns the RequestId. Use this RequestId in subsequent operations to determine the status of the asynchronous call and overall results of the persist operation.

This error response shows when the custom object can't be found before the request gets queued. Any errors that occur during the processing of the request by the business service are recorded with the results and are retrievable using the /data/v1/async/{requestId}/results?includeDetail=true resource.