Add rows to a data extension asynchronously.
Operation ID: Insert Data Extension Rowscurl "https://{subdomain}.rest.marketingcloudapis.com/data/v1/async/dataextensions/key:{externalKey}/rows" \
-X POST \
-H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
-H "content-type: application/json" \
-d '{
"items": [
{
"MemberId": "f284db27-e840-4e17-bcb6-537f7f1b54ad",
"FirstName": "Raul",
"Surname": "Nieto",
"RewardsPoints": 23456,
"RewardsTier": 3,
"Area": "Enfield"
},
{
"MemberId": "cc6298da-159a-4a3e-b841-3f1048b3fd3c",
"FirstName": "Foua",
"Surname": "Khang",
"RewardsPoints": 666777,
"RewardsTier": 4,
"Area": "West Ham"
},
{
"MemberId": "9dfc9341-d9d3-44f3-8624-f4c2dc87b4b3",
"FirstName": "Mary",
"Surname": "Evans",
"RewardsPoints": 7849,
"RewardsTier": 1,
"Area": "Islington"
},
{
"MemberId": "9dfc9341-d9d3-44f3-8624-f4c2dc87b4b3",
"FirstName": "Vijay",
"Surname": "Lahiri",
"RewardsPoints": 7742,
"RewardsTier": 1,
"Area": "Haringey"
}
]
}'
The unique API subdomain for your Marketing Cloud Engagement tenant. You can find this value in the Installed Packages section of Marketing Cloud Engagement Setup.
The external ID, also known as the customer key, for the data extension to insert or upsert data into.
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.
Bearer YOUR_ACCESS_TOKEN
{
"items": [
{
"MemberId": "f284db27-e840-4e17-bcb6-537f7f1b54ad",
"FirstName": "Raul",
"Surname": "Nieto",
"RewardsPoints": 23456,
"RewardsTier": 3,
"Area": "Enfield"
},
{
"MemberId": "cc6298da-159a-4a3e-b841-3f1048b3fd3c",
"FirstName": "Foua",
"Surname": "Khang",
"RewardsPoints": 666777,
"RewardsTier": 4,
"Area": "West Ham"
},
{
"MemberId": "9dfc9341-d9d3-44f3-8624-f4c2dc87b4b3",
"FirstName": "Mary",
"Surname": "Evans",
"RewardsPoints": 7849,
"RewardsTier": 1,
"Area": "Islington"
},
{
"MemberId": "9dfc9341-d9d3-44f3-8624-f4c2dc87b4b3",
"FirstName": "Vijay",
"Surname": "Lahiri",
"RewardsPoints": 7742,
"RewardsTier": 1,
"Area": "Haringey"
}
]
}
An array that contains the data to insert into the data extension. Each object in the array contains the data to insert into a single row in the data extension.
This response indicates that the API accepted the request to add data to a data extension asynchronously.
{
"requestId": "399d1e33-9beb-4192-b915-3925b0e1a00c",
"resultMessages": []
}
The request ID for the request. Use this ID to retrieve the status and results of the request.