0

I have a custom object Relation__c which has two fields a__c and b__c both are lookups to the standard Account Object.

The Account object has an external Id field called z__c

If I have to use Bulk API for upsert, what should my csv column headers be ? I want to use the value of Account's z__c field to populate the fields a__c and b__c. Kindly help.

0

It was possible to upsert data using polymorphic relationships during bulk api.
In this case the Custom Object Relation__c had lookups to the Account object a__c and b__c and the account object had an external id z__c

So the csv column Headers used to upsert data in Relation__c as below:

Account:a__r.z__c
Account:b__r.z__c

This helped to upsert data to this custom object and associate the lookups to the accounts at the same time using external id fields on account, instead of using salesforce ids.

Similarly, If you have lookups on the Account Object referencing other objects, then the relationship will be simpler, you don't have to include the name of the lookup object.

Account_Field__r.LookupObject_External_ID__c

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.