I need to run a daily process that updates every record in on of our tables via the data API. There are currently about 1500 records, and it is growing.
Currently I do it by doing a PATCH request on each record.
In the docs at https://bubble.io/reference#API it says there is a “bulk api” but it is for creating new things. You can bulk update by importing a CSV, but it doesn’t really work for my use case.
Is there a way to use this API for bulk updating existing records?
Would something like bulk operations work? This applies an API workflow for selected items in your database to modify and can run over an extended period of time.
How reliable is a bulk operation on a large number of entries? I tried to run a fairly simple one on a 750-item list and it seems to randomly skip around 10% of items. Is it better to schedule a workflow recursively?
I’m looking for a straightforward way to update a 50 columns Google Sheet without too much mapping work, at least not for every upload.
I’ll have a look at Parabola.