1

I'm having trouble updating a row in data extension. Code I use:

int businessUnitID; //Unit ID
string dataExtensionCustomerKey; //Data Extension Customer Key
DataExtensionObject row; //Data Extension row I want to update, retrieved with previous call and with Properties changed
APIProperty[] PrimaryKeys; //Data Extension Primary Keys

row.Keys = PrimaryKeys;
row.CustomerKey = dataExtensionCustomerKey;

UpdateOptions uo = new UpdateOptions();
SaveOption so = new SaveOption();
so.PropertyName = "*";
so.SaveAction = SaveAction.UpdateOnly;

uo.SaveOptions = new SaveOption[] { so };

ClientID client = new ClientID();
client.ID = businessUnitID;
client.IDSpecified = true;
client.ClientID1 = businessUnitID;
client.ClientID1Specified = true;

uo.Client = client;

UpdateResult[] uResults;
String uStatus;
String uRequestID;

uResults = ETSoapClient.Update(uo, new APIObject[] { row }, out uRequestID, out uStatus);

return uResults;

Error Message I get: Exception occurred during [Update:ProcessUpdateBatch] ErrorID: xxx

1
  • Where are you setting dataExtensionCustomerKey and PrimaryKeys? Seems like that would be important. Jun 18, 2016 at 13:14

1 Answer 1

1
  1. DataExtensionObject represents DataExtension Object not a record row. The Keys attribute requires you to pass Key Name and Value for that record
  2. To update an row, you need to use DataExtensionObject.Properties and pass a collection of APIProperty with column Name and Value.

For example you want to update David's firstname and lastname, with "Email" field as unique key:

DataExtensionObject deo = new DataExtensionObject();
deo.CustomerKey = data_extension_customerkey;
deo.Keys = new APIProperty[1];
deo.Keys[0] = new APIProperty();
//Primary Key column
deo.Keys[0].Name = "Email";
deo.Keys[0].Value = "[email protected]";


deo.Properties = new APIProperty[2]; //Two columns to update

deo.Properties[0] = new APIProperty();
deo.Properties[0].Name = "Firstname";
deo.Properties[0].Value = "David";

deo.Properties[1] = new APIProperty();
deo.Properties[1].Name = "Lastname";
deo.Properties[1].Value = "Hughes";

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .