First we create a brand new contact record in salesforce using Load Data Raptor. if you dont know how to create record using Load Data Raptor, Please see our Load DataRaptor blog.
Input JSON for creating contact record. {“FName”:”Demo FName”,”LName”:”Test LName”,”Phone”:”6778″}
Hit Execute
To upsert a record
In Fields — choose Upsert Key= true
In Option
Mark Overwrite target for All Null Inputs =true (For Null Input) in OPTIONS tab.
In PREVIEW Tab we pass the below json data
{“Id”:”0035i0000AHhNbVAQV”, (This is the ID of the record that needs to be updated.)
“FName”:” “, (Pass Null Data )
“LName”:”Test LName”,
“Phone”:”6778″}
Hit execute and open contact record
