Sequential Data Load

Overview

The Sequential Data Load endpoint allows you to send a single request message containing data to be loaded into one or more tables. For example, you could send a single message that contains one record to be loaded into a ‘Recipient’ table, two records to be loaded to an ‘Order’ table, and five records to be loaded to an ‘Order Item’ table. The system will load or update data, one table at a time. Each of these tables must be ordered in the exact sequence in which they should be loaded or updated. Please note that if you're loading data into multiple tables, you can send only ONE record at the parent level (you can optionally write multiple records into the joined tables).

This endpoint requires authentication using OAuth 2.0, and supports XML only (not JSON).

The Sequential Event Trigger endpoint requires the use of an API Post for each table being loaded. Continuing the above example, if you're loading data into the 'Recipient,' 'Order,' and 'Order Item' tables, you'd need three API Posts -- one for each table. The API Post includes a Data Map, which provides data handling instructions, such as where to store the inbound data contained within the API request, and whether this data should be used to update existing records and / or create new records.

  • Endpoint (North America): https://ats.eccmp.com/ats/XmlPost/PostSecureAuth2

  • Endpoint (Europe): https://ats.ccmp.eu/ats/XmlPost/PostSecureAuth2

  • Endpoint (Japan): https://ats.marketingsuite.jp/ats/XmlPost/PostSecureAuth2

Optionally, you can use this same endpoint to load data, then trigger the deployment of an Event-triggered Campaign. When used in this fashion, this endpoint is referred to as the Sequential Event Trigger. For more details, please see Sequential Event Trigger.

For more details on how to set up an Sequential Data Load API request, please see the Sequential Data Load API Technical Guide.

The following diagram depicts the process for loading data via the Sequential Data Load endpoint:

Pre-requisites

The Sequential Data Load endpoint requires the following:

  • Data Map -- The Data Map provides data handling instructions, such as where to store the inbound data contained within the API request message, and whether this data should be used to update existing records and / or create new records. You must define a separate Data Map for each table into which you're loading or updating data.

  • API Post -- The API Post must contain all expected fields in the request message. In addition, the "REST API Only" check box and the "Trigger" check box should both be unchecked. You must also publish the API Post to make it available. You must define a separate API Post for each table into which you're loading or updating data.

POST Method

The Sequential Data Load endpoint supports a POST operation.

  • Your Customer ID.

  • The Form ID of the API Post (or optionally, multiple API Posts).

  • All of the data to be loaded. For the field names, be sure to use the system "Column Name," and not the user-friendly "Display Name."

Click here to see a sample request message in XML format.