AnsweredAssumed Answered

SFDC Lookup

Question asked by angelica.buffa299959 on Oct 18, 2018
Latest reply on Oct 18, 2018 by angelica.buffa299959



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?