Overview
The Zoho Analytics node's "Update Data" operation allows you to update existing rows in a specified table (view) within a Zoho Analytics workspace. You can target specific rows using criteria or update all rows at once, and set new values for one or more columns. This is useful for bulk data corrections, mass updates after business rule changes, or synchronizing external data sources with your analytics tables.
Practical examples:
- Update the "Status" column to "Closed" for all sales records where "Amount" is less than 1000.
- Change the "Region" value from "East" to "West" for selected entries based on custom criteria.
- Apply a correction to a specific field across all rows in a table.
Properties
| Name | Meaning |
|---|---|
| Organisation Name or ID | Select the Zoho Analytics organisation to operate on. Choose from a list or specify an ID using an expression. |
| Workspace Name or ID | Select the workspace within the organisation. Choose from a list or specify an ID using an expression. |
| Views Name or ID | Select the table (view) to update. Choose from a list or specify an ID using an expression. |
| Modify All Rows | Whether to update all rows in the table (true) or only those matching the specified criteria (false). |
| Criteria | Specify a filter expression to select which rows to update (e.g., ("Region"='East' and "Sales"<1000)). Only used if "Modify All Rows" is false. |
| Column Data | Define which columns to update and their new values. For each column: - Column Name or ID: The column to update. - Data Type: Type of data (currently only "String" supported). - Column Value: New value to set. |
Output
The output is a JSON array containing the results of the update operation as returned by the Zoho Analytics API. Each item typically includes information about the updated rows, such as row IDs and status messages.
Example output structure:
[
{
"rowId": "12345",
"status": "success"
},
{
"rowId": "12346",
"status": "success"
}
]
Note: The exact fields may vary depending on the Zoho Analytics API response.
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 to locate the resource.
- Criteria Syntax Errors: Incorrectly formatted criteria expressions may cause errors or no rows to be updated.
- Missing Column Data: If no columns are specified for updating, the operation will not have any effect.
- Insufficient Permissions: The connected Zoho account must have permission to update data in the specified table.
Error messages and resolutions:
"No rows match the given criteria": Check your criteria syntax and ensure it matches existing data."Invalid column name": Verify that the column names exist in the selected view."Authentication failed": Recheck your Zoho Analytics OAuth2 credentials in n8n.