Zoho Analytics

Zoho Analytics Data APIs API

Data APIs are used to perform addition, update, deletion actions on Zoho Analytics tables.

GitHub OpenAPI

Documentation

📖
Documentation
https://www.zoho.com/analytics/api/v2/
📖
Authentication
https://www.zoho.com/analytics/api/v2/api-specification.html

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/zoho-analytics/refs/heads/main/openapi/zoho-analytics-data-apis-api-openapi.yml

Other Resources

🔗
GraphQL
https://raw.githubusercontent.com/api-evangelist/zoho-analytics/refs/heads/main/graphql/zoho-analytics-graphql.md

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/zoho-analytics-data-apis-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no email required.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

zoho-analytics-data-apis-api-openapi.yml Raw ↑ 
openapi: 3.1.0
info:
  title: Zoho Analytics Bulk Bulk Export - Asynchronous Data APIs API
  version: v2
  description: API for Zoho Analytics Bulk Operations, including data import and export.
servers:
- url: https://analyticsapi.zoho.com
security:
- iam-oauth2-schema:
  - ZohoAnalytics.data.read
  - ZohoAnalytics.data.create
  - ZohoAnalytics.data.update
  - ZohoAnalytics.data.delete
  - ZohoAnalytics.data.all
tags:
- name: Data APIs
  description: Data APIs are used to perform addition, update, deletion actions on Zoho Analytics tables.
paths:
  /restapi/v2/workspaces/{workspace-id}/views/{view-id}/rows:
    post:
      tags:
      - Data APIs
      summary: Add Row
      description: Adds a single row to the specified table.
      operationId: addRow
      parameters:
      - name: ZANALYTICS-ORGID
        in: header
        required: true
        schema:
          type: string
        description: Organization ID (can be obtained using Get Organizations API).
      - $ref: '#/components/parameters/workspace-id'
      - $ref: '#/components/parameters/view-id'
      requestBody:
        required: true
        content:
          application/x-www-form-urlencoded:
            schema:
              type: object
              properties:
                CONFIG:
                  $ref: '#/components/schemas/AddRowConfig'
              required:
              - CONFIG
            encoding:
              CONFIG:
                contentType: application/json
      security:
      - iam-oauth2-schema:
        - ZohoAnalytics.data.create
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
                properties:
                  status:
                    type: string
                  summary:
                    type: string
                  data:
                    type: object
                    properties:
                      addedColumns:
                        type: object
                      invalidColumns:
                        type: object
              examples:
                Default:
                  value:
                    status: success
                    summary: Add row
                    data:
                      addedColumns:
                        region: East
                        Sales: '1000'
                      invalidColumns: {}
        default:
          $ref: https://raw.githubusercontent.com/zoho/analytics-oas/refs/heads/main/v2.0/zoho-analytics-api-common.json#/components/responses/CommonErrorResponse
    put:
      tags:
      - Data APIs
      summary: Update Rows
      description: Updates rows in the specified table.
      operationId: updateRows
      parameters:
      - name: ZANALYTICS-ORGID
        in: header
        required: true
        schema:
          type: string
        description: Organization ID (can be obtained using Get Organizations API).
      - $ref: '#/components/parameters/workspace-id'
      - $ref: '#/components/parameters/view-id'
      requestBody:
        required: true
        content:
          application/x-www-form-urlencoded:
            schema:
              type: object
              properties:
                CONFIG:
                  $ref: '#/components/schemas/UpdateRowsConfig'
              required:
              - CONFIG
            encoding:
              CONFIG:
                contentType: application/json
      security:
      - iam-oauth2-schema:
        - ZohoAnalytics.data.update
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
                properties:
                  status:
                    type: string
                  summary:
                    type: string
                  data:
                    type: object
                    properties:
                      updatedColumns:
                        type: object
                      updatedRows:
                        type: integer
                      invalidColumns:
                        type: object
              examples:
                Default:
                  value:
                    status: success
                    summary: Update row
                    data:
                      updatedColumns:
                        Region: East
                        Sales: '1000'
                      updatedRows: 27
                      invalidColumns: {}
        default:
          $ref: https://raw.githubusercontent.com/zoho/analytics-oas/refs/heads/main/v2.0/zoho-analytics-api-common.json#/components/responses/CommonErrorResponse
    delete:
      tags:
      - Data APIs
      summary: Delete Row
      operationId: deleteRows
      description: 'Deletes rows from the specified table. Note: While OpenAPI generally discourages request bodies for DELETE operations, this API supports it for detailed filtering.'
      parameters:
      - name: ZANALYTICS-ORGID
        in: header
        required: true
        schema:
          type: string
        description: Organization ID (can be obtained using Get Organizations API).
      - $ref: '#/components/parameters/workspace-id'
      - $ref: '#/components/parameters/view-id'
      requestBody:
        required: true
        content:
          application/x-www-form-urlencoded:
            schema:
              type: object
              properties:
                CONFIG:
                  $ref: '#/components/schemas/DeleteRowsConfig'
              required:
              - CONFIG
            encoding:
              CONFIG:
                contentType: application/json
      security:
      - iam-oauth2-schema:
        - ZohoAnalytics.data.delete
      responses:
        '200':
          description: Successful response
          content:
            application/json:
              schema:
                type: object
                properties:
                  status:
                    type: string
                  summary:
                    type: string
                  data:
                    type: object
                    properties:
                      deletedRows:
                        type: integer
              examples:
                Default:
                  value:
                    status: success
                    summary: Delete row
                    data:
                      deletedRows: 27
        default:
          $ref: https://raw.githubusercontent.com/zoho/analytics-oas/refs/heads/main/v2.0/zoho-analytics-api-common.json#/components/responses/CommonErrorResponse
components:
  parameters:
    view-id:
      name: view-id
      in: path
      required: true
      schema:
        type: string
      description: ID of the view.
    workspace-id:
      name: workspace-id
      in: path
      required: true
      schema:
        type: string
      description: ID of the workspace.
  schemas:
    UpdateRowsConfig:
      type: object
      description: JSONObject with configuration for updating rows.
      properties:
        columns:
          type: object
          description: JSONObject with column name as key and data as value.
          examples:
          - columnName1: value1
            columnName2: value2
        criteria:
          type: string
          description: If criteria is sent, then the rows matching the criteria alone are updated.
          examples:
          - '"Sales Table"."Region"=''East'''
        updateAllRows:
          type: boolean
          description: To update all the rows in the table.
          examples:
          - true
        addIfNotExist:
          type: boolean
          description: It controls whether to add a new row with the provided details if the provided criteria doesn't matches with the existing data.
          default: false
          examples:
          - false
        dateFormat:
          type: string
          description: Specify this in-case any date field is being added and its format cannot be auto recognized.
          examples:
          - dd-MMM-YYYY
        columnDateFormat:
          type: object
          description: Specify this in case multiple date fields are being imported having different format each. Column name as key and date format as value.
          examples:
          - columnName1: dd-MMM-YYYY
            column2: MM/dd/yyyy
      required:
      - columns
      examples:
      - columns:
          columnName1: value1
          columnName2: value2
        criteria: '"Sales Table"."Region"=''East'''
    DeleteRowsConfig:
      type: object
      description: 'JSONObject with configuration for deleting rows. Must contain exactly one of the following properties: `criteria` (for selective deletion based on a string expression) or `deleteAllRows` (a boolean to indicate deletion of all rows).'
      properties:
        criteria:
          type: string
          description: If criteria is sent, then the rows matching the criteria alone are deleted.
          examples:
          - '"Sales Table"."Region"=''West'''
        deleteAllRows:
          type: boolean
          description: To delete all the rows in the table.
          examples:
          - true
      examples:
      - criteria: '"Sales Table"."Region"=''West'''
    AddRowConfig:
      type: object
      description: JSONObject with configuration for adding a row.
      properties:
        columns:
          type: object
          description: JSONObject with column name as key and data as value.
          examples:
          - columnName1: value1
            columnName2: value2
        dateFormat:
          type: string
          description: Specify this in-case any date field is being added and its format cannot be auto recognized.
          examples:
          - dd-MMM-YYYY
        columnDateFormat:
          type: object
          description: Specify this in case multiple date fields are being imported having different format each. Column name as key and date format as value.
          examples:
          - columnName1: dd-MMM-YYYY
            columnName2: MM/dd/yyyy
      required:
      - columns
      examples:
      - columns:
          Region: East
          Sales: '1000'
        dateFormat: dd-MMM-YYYY
  securitySchemes:
    iam-oauth2-schema:
      type: oauth2
      flows:
        authorizationCode:
          authorizationUrl: https://accounts.zoho.com/oauth/v2/auth
          tokenUrl: https://accounts.zoho.com/oauth/v2/token
          refreshUrl: https://accounts.zoho.com/oauth/v2/token
          scopes:
            ZohoAnalytics.data.read: Read data from Zoho Analytics.
            ZohoAnalytics.data.delete: Delete data from Zoho Analytics.
            ZohoAnalytics.data.update: Update data in Zoho Analytics.
            ZohoAnalytics.data.create: Create data in Zoho Analytics.
            ZohoAnalytics.data.all: Full access to data in Zoho Analytics.
            ZohoAnalytics.fullaccess.all: Full access to all Zoho Analytics features.