Skip to main content

Can someone please help me that in Bulk API CSV can we insert lookup values using external Id?

 

For example if I am inserting Contact and my Account has ExtenalId something like "Acc_ExternId__c" field for example.

 

How can I insert these records in Contact ?

"LastName", "Account.Acc_ExternId__c"

"Vyas", "EXT1234566"

"Kumar","EXT1355467"

 

I found somewhere to use something like "Account:Acc_ExternId__c"

but that also did not work.

 

Can someone help?

3 respostas
  1. 12 de mai. de 2024, 05:34

    @Kalpesh Vyas,

    1. Can you double check The API name (Acc_ExternId__c) as it is case-sensitive.
    2. Also ensure that the Acc_ExternId__c field in the Account object is marked as an external ID field and is unique across records.

    If it helps please mark as best answer :) 

0/9000