Overview
The Delete Data operation of the Zoho Analytics node allows you to remove rows from a specified table (view) within a workspace and organisation in your Zoho Analytics account. You can choose to delete all rows or only those matching specific criteria. This is useful for automating data cleanup, removing outdated records, or managing datasets as part of larger workflows.
Practical examples:
- Automatically deleting sales records older than a certain date.
- Removing test data after validation steps in a workflow.
- Cleaning up entries that meet specific business rules (e.g., low-value transactions).
Properties
| Name | Meaning |
|---|---|
| Organisation Name or ID | Organisations to get data from. Choose from the list, or specify an ID using an expression. |
| Workspace Name or ID | Workspace to get data from. Choose from the list, or specify an ID using an expression. |
| Views Name or ID | Views to get data from. Choose from the list, or specify an ID using an expression. |
| Modify All Rows | Whether or not to modify all rows in table. Options: true / false |
| Criteria | Criteria for modifying select rows, e.g.: (( "Region"='East' and "Sales"<1000) or ("Sales"."Region"='West' and "Sales"<2000)). Only rows matching this will be deleted if "Modify All Rows" is false. |
Output
- The output is a JSON array containing the result of the delete operation.
- Each item in the output corresponds to the response from Zoho Analytics for the deletion request.
- Typical fields may include status, number of rows deleted, and any relevant metadata returned by the API.
Example output structure:
[
{
"status": "success",
"message": "Rows deleted successfully",
"rows_deleted": 5
}
]
Note: Actual fields depend on Zoho Analytics API responses.
Dependencies
- External Service: Requires access to Zoho Analytics.
- Authentication: Needs OAuth2 credentials for Zoho Analytics (
zohoAnalyticsApiOAuth2Api). - n8n Configuration: Ensure the Zoho Analytics credential is set up in n8n.
Troubleshooting
Common issues:
- Invalid Organisation/Workspace/View: If the provided IDs or names are incorrect, the node will fail with an error indicating the resource was not found.
- Insufficient Permissions: The connected Zoho Analytics user must have permission to delete data in the specified view.
- Criteria Syntax Errors: Incorrectly formatted criteria strings may cause errors. Follow Zoho Analytics query syntax.
- No Rows Deleted: If no rows match the criteria, the operation will succeed but report zero deletions.
Error messages and resolutions:
"Resource not found": Check that Organisation, Workspace, and View values are correct."Invalid criteria": Review the Criteria property for syntax errors."Permission denied": Ensure the OAuth2 user has sufficient rights in Zoho Analytics.