Restrict the records passed to an Import step

Scenario: Shipment data are retrieved in the export step and passed to an import step to created item fulfillment in NetSuite. Among the Shipments retrieved there are Shipments which do not have related Sales Order in NetSuite. Hence when such Shipments are passed to Import step, it generates errors as the Sales Order is not founf in NetSuite.

Solution: Add a lookup step between the export and import. This lookup should check for the related Sales order in NetSuite of the Shipment. Then add an Input filter before the Import step with a criteria “lookupdetails.length is greater than 0”. Such that only shipments which has related sales orders in NetSuite will be passed to Import step. other records will be ignored.

Leave a comment

Your email address will not be published. Required fields are marked *