Response Mapping Array with Lookup

Integrator.io
, , , ,
1

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

2

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.

3

Perfect. Right in front of me!

Appreciate the help.