Help get this topic noticed by sharing it on Twitter, Facebook, or email.

UPSERT question regarding ID field

We need to download a Salesforce table (i.e. Contact), make edits then update existing or inserting new records back into Sales Force. If an update the original Id field needs to be preserved since this is used in other PK/FK relationships.

What are the steps to accomplish this?

I initially assumed we'd first SF_Replicate the SF remote table, perform the edits locally then use SF_BulkOps to UPSERT the modified local table to SF remote. After reading the documentation, it looks as if the Id column is ignored. If so, wouldn't that break the existing PK/FK Salesforce relationships?

1 person has
this question