Advanced Data Load
Overview
A single API request sent to the Advanced Data Load endpoint can be used to load data into multiple joined tables. All records are inserted into these tables simultaneously, rather than sequentially, which greatly improves performance. The schema for the joined tables is defined within the message payload itself, rather than through the use of an API Post or Data Map. The Advanced Data Load endpoint requires authentication using OAuth 2.0, and supports JSON and XML.
Endpoint (North America): https://aet.eccmp.com/services2/api/Data
Endpoint (Europe): https://api.eccmp.eu/services2/api/Data
Endpoint (Japan): https://api.marketingsuite.jp/services2/api/Data
For more details on the Advanced Data Load API, please see the Advanced Data Load API Technical Guide.
The following diagram depicts the process for loading data via the Advanced Data Load endpoint:
POST Method
The Advanced Data Load endpoint supports the following POST operation. This endpoint allows you to load data into multiple tables in your marketing database. The request message must include the following:
The Table Name to which data is to be loaded.
The data to be loaded, sent using Name / Value pairs. For the field names, be sure to use the system "Column Name," and not the "Display Name."
Optionally, the names of joins to other tables, and the data to be loaded into the joined tables.
The desired table- and field-level import settings to use when loading the data.
Click hereClick here to see a sample request message in JSON format.
{
"_data":{
"email_brand":[
{
"email":"john.doe@cheetahdigital.com",
"brand_cd":"UO",
"uo_us_pref":"100"
}
]
},
"_importOptions":[
{
"_table":"email_brand",
"_fieldOptions":[
{
"_applyToFields":[
"ems_orig_date",
"orig_data_src_id",
"orig_data_src_name"
],
"_preserveData":true
}
]
}
]
}
Back to API Category - Data Management