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 create multiple records in a specified worksheet in batch mode. It is useful when you need to insert many rows of data at once into a worksheet, improving efficiency by reducing the number of API calls compared to creating records one by one.
Typical use cases include:
- Importing bulk data from external sources into a HAP worksheet.
- Synchronizing large datasets periodically.
- Automating data entry workflows where multiple records are generated simultaneously.
For example, you might use this node to upload a list of customer orders or survey responses as multiple rows in a worksheet.
Properties
| Name | Meaning |
|---|---|
| Worksheet ID | The unique identifier of the worksheet where the records will be created. |
| Rows | An array of row objects to create. Each object contains fields with their IDs and values. |
| Trigger Workflow | Boolean flag indicating whether to trigger any associated workflow after the batch creation. |
Output
The node outputs JSON data representing the result of the batch creation operation. This typically includes details about the newly created records such as their IDs and any metadata returned by the HAP API.
If binary data were involved, it would be summarized here, but this operation deals only with JSON record data.
Dependencies
- Requires an API key credential for authenticating with the HAP API.
- The node expects network access to the HAP service endpoint.
- No additional environment variables are explicitly required beyond the API authentication.
Troubleshooting
- Invalid Worksheet ID: If the provided worksheet ID does not exist or is incorrect, the API will return an error. Verify the worksheet ID before running the node.
- Malformed Rows JSON: The "Rows" property must be a valid JSON array of objects with correct field IDs and values. Invalid JSON or missing fields can cause failures.
- API Authentication Errors: Ensure that the API key credential is correctly configured and has sufficient permissions.
- Trigger Workflow Flag: If set to true but no workflow is configured, the node may still succeed but no workflow will run; verify workflow setup if expected.
- Rate Limits or Quotas: Large batches might hit API rate limits; consider splitting into smaller batches if errors occur.
Links and References
- HAP (Hyper Application Platform) API Documentation (replace with actual URL)
- n8n Documentation on Creating Batch Records (generic link to custom nodes guide)