Response Mapping Array with Lookup

Avatar
Oblong Industries

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

Comments

2 comments
Date Votes
  • Avatar
    David Gollom
    Strategic Partner
    Top Contributor
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    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
  • Avatar
    Oblong Industries

    Perfect. Right in front of me!

    Appreciate the help.

    1

Please sign in to leave a comment.

 

Didn't find what you were looking for?

New post