This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi <@U03HQ088UKY> - I have a sales order sync where I want to check that the sales order doesn't already exist.

I was planning to use a lookup into Netsuite and Additional Search Criteria.  However the JSON can cover multiple orders.  For the 'additional search criteria' is there a way I can see what resources are available or have an array index?

Alternatively, is there a more elegant way to do duplicate avoidance?

Many thanks,

image.png

But I'm confused by your statement that "However the JSON can cover multiple orders"

It's an extract from Shopify that will return an array of order objects

you should specify a path to records on your shopify export

so then each order is treated as a record