Zoho Analytics

Consume the Zoho Analytics API

Actions6

Overview

The Zoho Analytics node's "Import Data" operation allows you to import JSON data into an existing table within a specified organisation, workspace, and view (table) in Zoho Analytics. This is useful for bulk uploading or synchronizing data from other sources into your analytics environment. Common scenarios include migrating data from another system, updating existing records in bulk, or appending new rows to a table.

Practical examples:

Importing sales data from an external CRM as JSON into a Zoho Analytics table.
Updating customer records in Zoho Analytics by matching on email or ID columns.
Appending new transaction logs to an analytics table for reporting.

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.
Import Type	Type of import to perform: - Append - Truncate Add - Update Add
JSON Data	JSON data to import into Table. Provide the data as a stringified JSON array/object.
Matching Columns	(Only for Import Type = Update Add) List of comma-separated column names. The values in these columns will be used to match existing rows in the table. Matching rows are updated; non-matching rows are appended as new.

Output

The output is a JSON array containing the result of the import operation.
Each item in the output corresponds to a response object from Zoho Analytics about the imported data.
Typical fields may include status, number of rows inserted/updated, and any error messages returned by the API.

Example output structure:

[
  {
    "status": "success",
    "rowsInserted": 10,
    "rowsUpdated": 5,
    "message": "Data imported successfully"
  }
]

Note: Actual field names and structure depend on Zoho Analytics API responses.

Dependencies

External Service: Requires access to Zoho Analytics.
Authentication: Needs valid Zoho Analytics OAuth2 credentials configured in n8n (zohoAnalyticsApiOAuth2Api).
n8n Configuration: Ensure the credentials are set up in the n8n instance.

Troubleshooting

Common Issues:

Invalid Credentials: If authentication fails, ensure that the Zoho Analytics OAuth2 credentials are correctly configured in n8n.
Incorrect IDs: Supplying invalid organisation, workspace, or view IDs will result in errors. Use the dropdowns or verify IDs via expressions.
Malformed JSON Data: If the JSON Data property contains invalid JSON, the import will fail. Always validate your JSON before importing.
Missing Matching Columns: For "Update Add" import type, if Matching Columns is not provided or does not match actual column names, updates may not work as expected.

Error Messages:

"Invalid JSON": Check the syntax of your JSON Data input.
"Organisation/Workspace/View not found": Verify the selected or entered IDs/names.
"Authentication failed": Re-authenticate or update your Zoho Analytics credentials in n8n.