function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
vishesh91vishesh91 

Data loader with lookup relationship

Hi all

I want to know how to use apex data loader to insert data for the objects which have lookup relationship with other objects.I mean what data I put for these fields in csv file.

Best Answer chosen by Admin (Salesforce Developers) 
Navatar_DbSupNavatar_DbSup

Hi,

 

For creating the relationship via lookup field when inserting the data from data loader. Put a column of name as api name of lookup field in your csv file and put the ids of lookup object from which you want to associate the Childs records.

 

For example:

suppose you want to associate a contact con1 with account acc1 then create a column as accountid and put the id of acc1 in this column and associate the contact con1.

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.