With the help of responses to my previous posts I was finally successful in Upserting Contacts in Salesforce via Jitterbit using External Id. However two records failed. I am thinking these failed because there are two entries with same value in Ext_Contact_ID.

I have enabled Contact to Multiple Accounts.

The Upsert operation is on Contact. I tested with a small data set of 7 records.

enter image description here Output

5 successful records

2 failed records

enter image description here


  • Do I need a 2nd query on AccountContactRelationship object to be able to upsert Contact's that are associated to multiple Accounts? If so, how can i UPSERT into AccountCOntactRelationShip using an external Id?
    (Per SF Documentation for AccountContactRelationship we need AccountId, ContactId, RecordOwner. )
  • 1
    Is that real PII (personally identifiable information) in your screenshot? – David Reed May 8 '20 at 22:35
  • I've removed the two screenshots because they appeared to contain actual persons' information. If that's not the case, you're welcome to edit them back in, or show us examples with fake data. – David Reed May 9 '20 at 16:20
  • Thanks @DavidReed for being diligent. That's fake made up data. – GroundToCloud May 11 '20 at 18:23
  • Thank you for confirming! I've rolled your question back to your original version. – David Reed May 11 '20 at 18:25
  • Thanks @DavidReed – GroundToCloud May 11 '20 at 18:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.