I have a process that updates values in a batch of records via the REST API, and I am looking to reduce the API calls required.
My understanding of the bulk update, is that it places the SAME value in multiple records via one call. Example:
If my question is: Is the item red?
And the answer varies per record, using bulk update I can only say all true or all false.
Correct me if I am wrong here…
And while I could do two calls here, one for true and one for false, the logic permutations become impossible if say I am updating 3-10+ fields per record with unique values per record.
If I could submit a JSON array of record objects (for example), each object referencing the objectId, then this could all be done in one API call.
Is that (or an alternative) possible and I have missed it in the docs somehow?
Right now, one batch update of 250 records is 250 calls, and to keep under rate limits, this means that iterating through 30k records takes a couple of hours.
I don’t need to update 30k records in one call, but even just 1 call for 250 records would reduce the overhead considerably and i could do that more frequently.