Overview
This n8n node allows you to delete rows from a specified Table or View in your Caspio account using the Caspio API. The "Row - Delete" operation is useful for automating data cleanup, removing outdated records, or managing data integrity within your Caspio applications directly from n8n workflows.
Common scenarios:
- Automatically deleting records that meet certain criteria (e.g., old entries, flagged items).
- Integrating Caspio data management with other systems (e.g., after processing or archiving data elsewhere).
- Bulk deletion of records based on dynamic workflow conditions.
Example:
You could use this node to remove all user accounts marked as "inactive" from a "Users" table by specifying an appropriate WHERE clause.
Properties
| Name | Type | Meaning |
|---|---|---|
| Table/View Name | String | Name of the Table or View from which rows will be deleted. |
| Is View | Boolean | If true, operates on a View instead of a Table. |
| Where | String | SQL-like WHERE clause to specify which rows should be deleted. |
Output
The output is a JSON object containing the result of the delete operation as returned by the Caspio API. The structure typically includes information about the success of the operation and may include metadata such as the number of affected rows.
Example output:
{
"AffectedRows": 3,
"Message": "Records deleted successfully"
}
If an error occurs and "Continue On Fail" is enabled, the output will contain an error field with the error message:
{
"error": "Detailed error message here"
}
Dependencies
- External Service: Requires access to the Caspio API.
- Credentials: You must configure Caspio credentials in n8n.
- Environment: No special environment variables are required beyond standard n8n credential setup.
Troubleshooting
Common issues:
- Invalid Table/View Name: Ensure the name matches exactly as defined in Caspio.
- Incorrect WHERE Clause: Syntax errors or referencing non-existent fields will cause failures.
- Insufficient Permissions: The Caspio API credentials must have permission to delete records in the specified Table/View.
Error messages:
"No binary data exists on item!": This should not occur for the Row/Delete operation, but if encountered, check your input configuration."No binary data property ... does not exist on item!": Not applicable for this operation.- Errors from Caspio API (e.g., authentication errors, invalid queries) will be passed through in the
errorfield if "Continue On Fail" is enabled.
How to resolve:
- Double-check Table/View names and WHERE clauses.
- Verify Caspio credentials and permissions.
- Review error messages for hints on misconfiguration.