I’m stuck with trouble how to delete multimultiple Rows in BT. It’s terrible to do it one by one with huge quantity of updates
Are there workarounds maybe?
My use case is storing bar-codes to a row, having ~500 rows a day. I need it for a couple weeks for history and reporting. Then i need to rollout this set into one row per day to pack \ compress rows for decreasing quantity of rows. Because do not need such detail history after a couple weeks. But both kind of rows (detailed and packed) i need for reporting & diagrams.
Use the API. You can delete rows in batches of up to 500 with a single API call.
@Darren_Murphy Thank you
Could you explain please or give a link to - how to do it with batches of row just by single API call?
Would it cost 500 updates if the batch is 500 rows?
The documentation shows you how to do it. Just create a separate mutation for each row to be deleted, and send them all in a single call as a collection.
Each row deleted is one update, the same as it would be if you used a delete row action.
Thank you very much, Darren!
Am going to do.
Regret about huge quantity of updates in this solution
instead of just one update in case of Delete row by Multi-Relation…
Deleting rows through a multi-relation still counts one update for each deleted row - so it’s the same either way.
Oh, i did’nt know that, thank you
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.