Response Mapping Array with Lookup

Oblong Industries

• October 22, 2021 16:41

I have a lookup in Netsuite that will return me an array of results. In the response mapping I am selecting "Data" and mapping it to a new property called "EstimateLineItems".

In the next step in the import I see the options for the values from the lookup appearing like this "EstimateLineItems[*].Quantity"

If I need to do another lookup in Salesforce based on these array values, how would I write that token in the Salesforce SOQL, could I do something like this :
select ID
FROM Product2
WHERE Product2.Netsuite_Id__c= '{{EstimateLineItems[*].InternalId}}'

Thanks

0

• 

  David Gollom Strategic Partner

  • October 22, 2021 16:52

  

  

  

  

  

  Sounds like in the subsequent lookup you'd want to take advantage of the One to Many option. Your one to many target would be EstimateLineItems and then the lookup would run for each of those array elements.  Your query would on use the InternalID since you'd be only dealing with one line item.  Hope this helps. 

  1
• 

  Oblong Industries

  • October 22, 2021 17:25

  Perfect. Right in front of me!

  Appreciate the help.

  1

Please sign in to leave a comment.