I just did what no admin or dev ever wants to do - I deleted the wrong NetSuite transactions in a production account.
I was using IO to delete several thousand invoices that were invalid and needed to be re-created. I created a simple flow to export the transactions to delete, then an import to delete them. On the import record filtering criteria I used:
["internalidnumber","is","{{{id}}}"]Well, that's the incorrect operator, it should have been equalto and instead of getting an error or no results, IO seems to have picked the oldest Invoice in the database and deleted it. I verified this with the Audit Trail report.
Once I updated the criteria filter to
["internalidnumber","equalto","{{{id}}}"]It behaved correctly. I'm posting this to;
- Warn users about this easy-to-make mistake, and
- Inform Celigo about the problem
I should have verified the configuration by doing an update to the memo field or something benign first, I realize that.