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.


1 Answer 1


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.


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .