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