I need to go through hundreds of records in data-store and modify them (flipping a binary to mark them as inactive)
I’m storing a chat history as part of a chatbot. Each row is currently a single message. When a user decides to /reset their account, I clear out the previous messages by marking them all as inactive, but this costs me hundreds of operations.
How experienced are you with manually hitting APIs? Make has an API for Data Stores, you can pull the records in 1 go (or for a lot of records, in chunks for 1-200 per operation) using the Make > Make an API call module and this endpoint: Make Public API
As for bulk updating, you could arrange your edited data into an array and use Make Public API I think (please backup your data store first).
Alternatively, you could try an iterator into an array and then update via the usual Data store, but that gets fiddly.