Question on Celigo integrator.io and if it has the capability to do this: We have roughly 40,000 sales transactions from last month in NS, and I need to insert an Amazon settlement ID # onto each line of those transactions. Typically our scripting &/or middleware takes care of this, but due to some system issues we had those processes failed and we need to get them in there manually. The issue is, each sale may have a different number of line-items. Sure I could run a SQL query to pull the transaction_line_id's for all 40,000 transactions, but that would quickly become >100k lines to update. Is there a way in Celigo that I can provide it a list of the 40,000 transactions to update, along with the Settlement ID#, and say "apply this to all rows" on the order without specifying the individual line_id?

Unfortunately there is not. NetSuite requires the line id to update existing lines.

Not in Celigo but easily in a Map/Reduce script.

One way to accomplish this in Celigo is to create a temporary body-level custom field to hold the settlement id. Use data loader to populate this field. Then create a saved search in NetSuite to expose the internal id, settlement id and line ids for each line. Create a flow that uses that search as the import, and updates each line.

@michoel brilliant! that might just do the trick