I'm trying to push records from a database to Salesforce that have a lookup relationship to another object. The lookup field must be populated when importing the records in Salesforce. I do not have the Salesforce ID in the database, but the foreign key is an External Salesforce ID.
I have a few questions about that scenario:
- Is there any way to set up the lookup relationship based on an external ID when pushing records from a database to Salesforce? It is doable in Apex, but couldn't find a way to do the same in Boomi.
- Can I use a dynamic document property to store the result of a query that returns multiple rows and lookup the Salesforce ID?
- Is there a way to dynamically load cross reference tables?
- Is there any other ways to achieve this?