Data Extension Rows (Asynchronous)

GET Retrieve the results of a request to asynchronously insert rows into a data extension.

GET /data/v1/async/{requestId}/results

Operation ID: getRequestResults.

For information about the limits that apply to this API, see Salesforce Help: Limits and Guidelines.

Parameters

• Authorization (header, string, required) A unique, time-limited token that you can use to issue requests to the Marketing Cloud Engagement API. Replace YOUR_ACCESS_TOKEN with your authentication token.

  Example

  Bearer YOUR_ACCESS_TOKEN

• requestId (path, string (uuid), required) A unique ID for an asynchronous request. Use this ID to retrieve the status and results of the request.

Responses

• 200 This response includes the results of a request to asynchronously insert or update data in a data extension. The API also returns this response if it's unable to find the specified requestId. If the API fails to retrieve the specified requestId, the status object is omitted in the response, and the resultMessages array contains details of the issue. This example shows a successful request.

  Media type: application/json. Schema: insertUpdateResultsGetResponseBody.

  Example

  {
    "page": 1,
    "pageSize": 2,
    "count": 2,
    "items": [
      {
        "message": "Created DataExtensionObject",
        "status": "OK"
      },
      {
        "errorCode": 71003,
        "message": "Cannot insert the value NULL into column 'RewardsPoints', table 'ExactTarget.C67709.MembershipRewardsProgramme2'; column does not allow nulls. INSERT fails.\r\nThe statement has been terminated.",
        "status": "Error"
      }
    ],
    "requestId": "5a67f73d-801d-4b5f-bee7-8b6acf34743a",
    "resultMessages": []
  }

• 401 Indicates that the API wasn’t able to authorize your request. When you receive a 401 response, verify that you obtained an authorization token and that the token is still valid.

  Media type: application/json. Schema: httpErrorResponseBody.

  Example

  {
    "documentation": "https://developer.salesforce.com/docs/atlas.en-us.mc-apis.meta/mc-apis/error-handling.htm",
    "errorcode": 0,
    "message": "Not Authorized"
  }

• 403 This response indicates that the API accepted your request but couldn’t authorize it. When you receive a 403 response, make sure you have the necessary permission scope for the operation. You can modify permission scopes on the Installed Apps page in Marketing Cloud Engagement Setup.

  Media type: application/json. Schema: mceErrorResponseBody.

  Example

  {
    "documentation": "",
    "errorcode": 20002,
    "message": "Insufficient privileges to complete this action."
  }

• 500 Indicates that the API encountered an error when processing the request. When you receive a 500 response, verify that the request uses the correct syntax.

  Media type: application/json. Schema: httpErrorResponseBody.

  Example

  {
    "documentation": "https://developer.salesforce.com/docs/atlas.en-us.mc-apis.meta/mc-apis/error-handling.htm",
    "errorcode": 0,
    "message": "Internal Server Error"
  }