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.
5 successful records
2 failed records
- 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
(Per SF Documentation for AccountContactRelationship we need AccountId, ContactId, RecordOwner. )