j
No Results
Search Tips:
- Please consider misspellings
- Try different search keywords
Asynchronously update rows in a data extension if the primary key exists, or create rows if the primary key doesn't exist.
Operation ID: Upsert Data Extension Rowscurl "https://{subdomain}.rest.marketingcloudapis.com/data/v1/async/dataextensions/key:{externalKey}/rows" \
-X PUT \
-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.
For responses to create or update requests, this array contains no items.