Multiple Records Update API - Jodoo

Multiple Records Update APIAPI Explorer

Introduction

API Introduction

The API is used to update multiple records in batches.

Note:
1. You cannot call the API in a subform.
2. A maximum of 100 records can be updated.
3. When you update attachment and image fields, the previous files in the fields will be cleared out.
4. Updating multiple records refers to changing the field values of multiple records to a fixed value.

API Calling

The API is used to update multiple records in batches.

Request URL: https://api.jodoo.com/api/v5/app/entry/data/batch_update

Request frequency: ten times per second

Request Method: POST

Request Parameters:

Parameter	Type	Required	Description
app_id	String	Yes	App ID
entry_id	String	Yes	Form ID
data_ids	Array	Yes	Array of IDs for the data to be updated
data	JSON	Yes	The updated data format of the API is the same as that of the Create one record API. You cannot call the two APIs in a subform.
transaction_id	String	No	Transaction ID. Transaction_id is used to bind a batch of uploaded files. If the data contains attachments or image controls, the transaction_id must be the same as the transaction_id parameter in the Get file upload confirmation and URL API.

Sample Request:

{
  "app_id": "59264073a2a60c0c08e20bfb",
  "entry_id": "59264073a2a60c0c08e20bfd",
  "transaction_id": "87cd7d71-c6df-4281-9927-469094395677",   //Transaction ID
    "data_ids": [
        "200001181fe09728936510eb",
        "200001181fe09728936510ec",
        "200001181fe09728936510ed"
    ],
    "data": {
        "_widget_1432728651402": { // Single Line
            "value": "Jodoo 1"
        },
        "_widget_1432728651403": { // Number
            "value": 100
        }
    }
}

Responses:

Parameter	Type	Description
status	String	Return request results
success_count	Number	The number of successfully updated records

Sample Response:

{
    "status": "success",
    "success_count": 3
}