Why the deleting from the Target always runs for me?


Question.

How can I avoid delete from the Target, it seems to always run for me. What am I doing wrong?

Below is my export file:

{
     "query":"Select Name from TestObject1__c",
     "operation": "Insert",
     "deleteOldData": "false",// This is false, so shouldn't delete anything!
     "externalId" : "Name"
}

Answer.

You should always pay attention to use correct type of property values.  

Try this:

{
     "query":"Select Name from TestObject1__c",
     "operation": "Insert",
     "deleteOldData": false,// This is property of BOOLEAN type, not of STRING!
     "externalId" : "Name"
}

This is a boolean parameter and must be used without quotation.

For the guide how to delete records see the Full Export.json Format article

Last updated on 29th Jan 2023