We are designing an Integration leveraging Bulk API & Enterprise WSDL (The client code is handled by the source system). The target Force.com Object has few Lookup Fields. Wanted to understand how to automatically resolve the Foreign Key.
For instance we have a Master Object "Geo Area" with values like 'APAC', 'EALA' etc.... Another Force.com Object called "SAP OM" which is the actual Object into which the integration upserts data has a lookup Field called "Client Geo Area" which looks up to "Geo Area" Master Object. The source system will only push values like 'APAC' or 'EALA' etc via the integration which we need to store into the lookup Field. However the Lookup Field expects the Row Id of the Master Values and not the actual Values.
How do we resolve this?
In the Bulk API guide under "Relationship Fields for Custom Objects" section it is mentioned that relationship name could be used to resolve Foreign Keys. Has anyone used this?