Bulk API: CSV Column Names for lookup relationship

Question

I am having a tough time understanding the naming convention of the columns for a CSV file for Bulk API. The struggle is with Lookup Relationships

Account:

Account.AccountId

Account.REID - custom field

Order:

Order.AccountId

Order.REID - custom field with External look up flag.

So .. I want to set Order.AccountId with the results of the lookup from Order.REID = Account.REID

I have the REID and want to know what to call the column so that the lookup will bring back the correct AccountId from the Account object.

Many thanks

Rupert Barrow · Answer

You need to declare Account.REID__c an external ID.

In your Order file, let's suppose you have a column with "REID" as a title .

In your mapping, you need to map REID and Order.REID__c.

When you run the Data Loader, choose REID as the external ID for Account lookup.

That should make it work.

Ruo

Data Management