Skip to content

Instantly share code, notes, and snippets.

@angrycider
Last active March 23, 2021 07:14
Show Gist options
  • Save angrycider/02e858fd013144e1bab3b422f7dad72e to your computer and use it in GitHub Desktop.
Save angrycider/02e858fd013144e1bab3b422f7dad72e to your computer and use it in GitHub Desktop.
5. Upsert row to a Data Extension
//UPSERT DE
var co = {
"CustomerKey": "7254CCBC-E5F8-49B6-991E-855825DAEADD",
"Keys":[
{"Key":{"Name":"subscriberkey","Value":"test@fakeemail.com"}}],
"Properties":[
{"Property":{"Name":"color","Value":"purple"}}
]
};
var uo = {
SaveOptions: [{"SaveOption":{PropertyName:"DataExtensionObject",SaveAction:"UpdateAdd"}}]
};
SoapClient.update('DataExtensionObject',co,uo, function(err, response){
if(err){
console.log(err);
}
else{
console.log(response.body.Results);
}
});
@SunMartekVentures
Copy link

SunMartekVentures commented Mar 23, 2021

How can we upsert rows without primary key-value data extension?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment