We have two objects here. One is Master and other is child of that master. we have an external field on the master Object. I am trying to perform the Upsert Operation on the Child object with the help of external Field of master object.

I am providing the externalIdfield attribute in config file. But, dataloader is not identifying the field and throwing an error. entry key="sfdc.externalIdField" value="Master__r.External_id__c"

Please suggest . Thanks.


It looks as though there is a little confusion regarding the configuration.

In the config file

entry key="sfdc.externalIdField" value="Master__r.External_id__c" 

tells the dataloader what externalid to use to differentiate the child objects when creating them.

To upsert a relationship in the dataloader you need to specify the mapping in the SDL file for example:


Please note these relationship mappings are only available for upserts, not for inserts or updates as far as I am aware. You may find this link helpful too.


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.