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 deletion of multiple records within a specified worksheet. It is useful when you need to delete several rows at once, either softly (recoverable) or permanently (irreversible). Typical use cases include cleaning up outdated data, removing test entries, or bulk-managing records in a spreadsheet-like environment.
For example, if you have a worksheet containing customer data and want to remove multiple customers who no longer meet certain criteria, this node can delete all their records in one operation.
Properties
| Name | Meaning |
|---|---|
| Worksheet ID | The unique identifier of the worksheet from which records will be deleted. |
| Row IDs | An array of row record IDs specifying which records to delete. |
| Permanent | Whether to permanently delete the records (true) or perform a soft delete (false). Permanent deletes cannot be undone. |
| Trigger Workflow | Whether to trigger a workflow after the batch delete operation completes (true or false). |
Output
The node outputs JSON data representing the result of the batch delete operation. This typically includes confirmation of which records were deleted and any relevant status messages returned by the HAP API. There is no indication that binary data is output by this operation.
Dependencies
- Requires an API key credential for authenticating with the HAP API.
- The node expects proper configuration of this credential within n8n.
- Network access to the HAP API endpoint is necessary.
Troubleshooting
- Common issues:
- Invalid or missing worksheet ID or row IDs may cause the operation to fail.
- Attempting permanent deletion without proper permissions could result in authorization errors.
- Providing an empty array for row IDs will likely result in no action or an error.
- Error messages:
- Errors related to authentication usually indicate misconfigured or expired API credentials.
- API errors about invalid IDs suggest checking the worksheet and row IDs for correctness.
- If the workflow trigger option is enabled but the workflow fails to start, verify workflow configurations and permissions.
Links and References
- HAP (Hyper Application Platform) API Documentation (replace with actual URL if available)
- n8n documentation on Creating Custom Nodes