Zoho Analytics icon

Zoho Analytics

Consume the Zoho Analytics API

Actions6

Overview

The Import New Table operation of the Zoho Analytics n8n node allows you to create a new table in a specified workspace within your Zoho Analytics account and import data into it from a JSON payload. This is particularly useful for automating the setup of new datasets, migrating data from other systems, or initializing analytics projects with structured data.

Common scenarios:

  • Setting up a new analytics project by importing a fresh dataset as a new table.
  • Migrating data from another application or database into Zoho Analytics.
  • Automating periodic creation of tables for time-based data (e.g., monthly reports).

Practical example:
You have a JSON export from your CRM system and want to analyze this data in Zoho Analytics. Using this operation, you can create a new table named "CRM_Leads" and import all your lead data in one step.

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. (Not used in Import New Table operation)
Table Name Name of the new table you wish to create.
JSON Data JSON data to import into the new table. The structure should match the columns you want in the new table.

Output

The output will be a JSON array containing the response from Zoho Analytics about the newly created table and the imported data. Typical fields may include:

[
  {
    "tableName": "YourTableName",
    "status": "success",
    "importedRows": 100,
    // ...other metadata returned by Zoho Analytics API
  }
]
  • The exact structure depends on the Zoho Analytics API response, but you can expect information about the table name, status, and number of rows imported.

Dependencies

  • External Service: Requires access to Zoho Analytics.
  • Authentication: Needs OAuth2 credentials (zohoAnalyticsApiOAuth2Api) configured in n8n.
  • n8n Configuration: Ensure that the Zoho Analytics node is properly set up with valid credentials.

Troubleshooting

Common issues:

  • Invalid JSON Data: If the JSON Data property contains malformed JSON, the operation will fail. Ensure your JSON is valid and matches the intended table schema.
  • Missing Required Fields: If Table Name or JSON Data are empty, the node will throw an error.
  • Permission Errors: If the provided credentials do not have permission to create tables in the selected workspace, the operation will fail.
  • API Limitations: Zoho Analytics may impose limits on the size or structure of imported data.

Error messages and resolutions:

  • "Invalid JSON": Check and correct your JSON syntax.
  • "Unauthorized" or "Permission denied": Verify your OAuth2 credentials and permissions in Zoho Analytics.
  • "Table already exists": Use a unique table name or delete the existing table before retrying.

Links and References

Discussion