Actions16
- App Actions
- Data Actions
- Entry Actions
- File Actions
- Workflow Actions
Overview
This node integrates with the Jiandaoyun API to manage data records within an app entry. Specifically, the "Update Many Data Records" operation allows users to update multiple data records in bulk by specifying their IDs and the new data values. This is useful for scenarios where you need to apply the same update or changes to many records at once, such as correcting a field across multiple entries, updating statuses, or applying batch modifications efficiently.
Practical examples:
- Updating the status field of 50 customer records after a campaign.
- Changing a common attribute (e.g., category or tag) on multiple inventory items.
- Bulk editing form submissions to correct or add missing information.
Properties
| Name | Meaning |
|---|---|
| App ID | The identifier of the app containing the data records to update. |
| Entry ID | The identifier of the entry (form or dataset) within the app where the data records reside. |
| Data Record ID List (JSON) | A JSON array listing the IDs of the data records that should be updated. Example: ["id1", "id2", "id3"]. |
| Using JSON | Boolean flag indicating whether the data record content is provided in JSON format. For this operation, it must be true. |
| Data Record (JSON) | The JSON object representing the data fields and their new values to apply to each specified record. This follows the Jiandaoyun API format for data updates. |
| Additional Fields | Optional additional parameters. Currently supports: - Transaction ID: Used to bind a batch of uploaded files if the data includes attachments or images. Must match the transaction ID used when obtaining upload credentials. |
Output
The output is a JSON array where each element corresponds to the response from the Jiandaoyun API for the update operation. Each item contains the result of updating the respective data records. The exact structure depends on the API response but generally includes success confirmation or error details per record.
No binary data output is produced by this operation.
Dependencies
- Requires an active Jiandaoyun API credential configured in n8n to authenticate requests.
- The node communicates with the Jiandaoyun server endpoint specified in the credentials.
- The user must provide valid App ID, Entry ID, and data record IDs.
- If attachments or images are involved, a matching transaction ID must be used to link file uploads.
Troubleshooting
Error:
dataRecordIdsJson must be an array
Occurs if the "Data Record ID List (JSON)" input is not a valid JSON array. Ensure the input is a properly formatted JSON array of strings.Error related to invalid JSON in "Data Record (JSON)"
The data record JSON must be valid JSON syntax. Use a JSON validator to check correctness before input.Authentication errors
Verify that the Jiandaoyun API credentials are correctly set up and have sufficient permissions.Transaction ID mismatch
When updating records with attachments, ensure the transaction ID matches the one used during file upload; otherwise, attachments may not link correctly.API limits
The API restricts batch updates to a maximum of 100 records at a time. Exceeding this will cause errors.