Actions31
- Option Set Actions
- Public Query Actions
- Record Actions
- Role Actions
- Workflow Actions
- Worksheet Actions
Overview
This node interacts with the HAP (Hyper Application Platform) API to perform batch updates on multiple records within a specified worksheet. It allows users to update several rows at once by specifying their IDs and the fields to be updated, which is useful for bulk data modifications without needing to update each record individually.
Common scenarios include:
- Updating status or values across many records in a spreadsheet-like application.
- Applying changes to multiple entries after a data import or synchronization.
- Automating bulk edits triggered by external events or workflows.
For example, you might use this node to update the "status" field of 100 rows in a worksheet to "completed" after a batch process finishes.
Properties
| Name | Meaning |
|---|---|
| Worksheet ID | The unique identifier of the worksheet where the records reside. |
| Row IDs | An array of row IDs specifying which records to update. |
| Fields | An array of objects defining the fields to update; each object includes a field ID and new value. |
| Trigger Workflow | Boolean flag indicating whether to trigger subsequent workflows after the batch update operation. |
Output
The node outputs JSON data representing the result of the batch update operation. This typically includes confirmation of updated records or any relevant response from the HAP API about the success or failure of the update.
If binary data were involved, it would represent file attachments or similar content related to the records, but this operation focuses on JSON data updates only.
Dependencies
- Requires an API key credential for authenticating with the HAP API.
- Needs network access to the HAP service endpoint.
- Proper configuration of the node's credentials in n8n is necessary to authorize API requests.
Troubleshooting
- Invalid Worksheet ID: If the worksheet ID is incorrect or does not exist, the API will return an error. Verify the worksheet ID before running the node.
- Malformed Row IDs or Fields: Ensure that the row IDs and fields arrays are correctly formatted JSON arrays. Invalid JSON or missing required fields can cause failures.
- Permission Issues: Lack of proper permissions or invalid API credentials may lead to authorization errors. Confirm that the API key has sufficient rights.
- Trigger Workflow Flag: If set incorrectly, downstream workflows may not execute as expected after the update.
- API Rate Limits: Large batch updates might hit API rate limits; consider splitting updates into smaller batches if errors occur.
Links and References
- HAP (Hyper Application Platform) API Documentation (replace with actual URL)
- n8n documentation on Creating Custom Nodes
- JSON formatting guide for input properties: https://www.json.org/json-en.html