Skip to main content

Bulk Update of Multiple Items

To update data in the same database in bulk, you can use the ExecuteBulkAction API.

This API executes actions in batches by specifying conditions. A single Action for a target datastore can be executed consecutively for multiple Items.

ExecuteBulkAction API​

  • ExecuteBulkAction：Specify conditions and execute actions in bulk
  • Method：POST
  • Request URL Format：/api/v0/applications/:app-id/datastores/:datastore-id/items/bulkaction/:action-id

Terms of use​

The default number of concurrent executions is 100. The max_items parameter can be used to specify up to 300.

If the continue_proc option is set to true, the target will be updated to the maximum number when the maximum number is exceeded. All items can be updated by executing this API multiple times until matched = processed in the result JSON.

The most recent rev_no is always used to update data when using this API (force_update option = true; no exclusivity control is used).

About transactions​

This API does not have a rollback function like transaction processing.You must have your own program to periodically check for inconsistent data and retry in case of failure.

To use the transaction function, please use ExecuteAction API.