AnsweredAssumed Answered

How to delete one item from a NetSuite sublist?

Question asked by britta on Jun 22, 2018
Latest reply on Jun 26, 2018 by britta

Dear Boomi/NetSuite experts,


I want to delete one item from a NetSuite sublist (Sales Order). I'm aware of the replaceAll feature, but replaceAll deletes and then inserts all items, but at a certain status it is not allowed to delete items any more, just to update. And since I want a solution that works in all use-cases, we, unfortunately, can't use replaceAll.


I know for updating I first have to query my desired data from NetSuite and compare with the data from my source system to update the respective lines.

New lines are added by leaving the "line" empty.

But how about deleting?


I could first update/insert all items that need to be updated/inserted and then do a replaceAll (if there are items that need to be replaced - which won't be the case once that certain status is reached). But I was wondering if there is an easier way?


Thank you,