AnsweredAssumed Answered

What format does the XML profile need to be in to update fields to NULL values in the Salesforce.com connector?

Question asked by JohnStelling4121 on Oct 8, 2013
Latest reply on Oct 3, 2014 by YechielKaplan8651
I am using the Salesforce.com Connector and wish to set records to NULL in an update operation.  What format does the XML profile need to be in to do this?

Currently, in the process I have built, the shape source data looks like the below going into the connector call.  However, the connection data coming out of the connector returns a status of success, but no update actually occurs! 

<?xml version='1.0' encoding='UTF-8'?>
<Account>
  <Id>001A00000069qIfIAI</Id>
  <fieldsToNull>field1</fieldsToNull>
  <fieldsToNull>field2</fieldsToNull>
  <fieldsToNull>field3</fieldsToNull>
  <fieldsToNull>field4</fieldsToNull>
  <fieldsToNull>field5</fieldsToNull>
  <fieldsToNull>field6</fieldsToNull>
  <fieldsToNull>field7</fieldsToNull>
</Account>

Outcomes