Zoho Analytics Bulk Import - Synchronous API
Synchronous operations for importing data.
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.
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/zoho-analytics-bulk-import-synchronous-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 form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.
OpenAPI Specification
openapi: 3.2.0
info:
title: Zoho Analytics Bulk Bulk Import - Synchronous 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: Bulk Import - Synchronous
description: Synchronous operations for importing data.
paths:
/restapi/v2/workspaces/{workspace-id}/data:
post:
tags:
- Bulk Import - Synchronous
security:
- iam-oauth2-schema:
- ZohoAnalytics.data.create
summary: Import Data into a New Table (Synchronous)
description: Use the Bulk APIs to create a new table and import data into it synchronously.
operationId: importDataNewTable
parameters:
- $ref: '#/components/parameters/org-id'
- $ref: '#/components/parameters/workspace-id'
- in: query
name: CONFIG
required: true
schema:
type: string
examples:
jsonConfig:
summary: JSON
value: '{"tableName":"Sales","fileType":"json","autoIdentify":true}'
csvConfig:
summary: CSV
value: '{"tableName":"Sales","fileType":"csv","autoIdentify":true}'
description: JSONObject with configuration to create a new table and import data on the same. (Refer `ImportConfigNewTable` schema). Value must be stringified and URL-encoded.
requestBody:
description: Provide either FILE (as a binary file) or DATA (as raw text). Only one should be sent.
required: true
content:
multipart/form-data:
schema:
type: object
properties:
FILE:
type: string
format: binary
description: The file to be imported. Only one of FILE or DATA should be provided.
DATA:
type: string
description: Raw data (CSV or JSON) to be imported. Only one of FILE or DATA should be provided.
examples:
- '[{"Region":"East"},{"Region":"West"}]'
text/plain:
schema:
type: string
description: The raw data to be imported (plain text body).
responses:
'200':
description: Successful import data response
content:
application/json:
schema:
$ref: '#/components/schemas/ImportSuccessResponse'
examples:
Default:
value:
status: success
summary: Import data
data:
viewId: '1767024000003153002'
importSummary:
importType: APPEND
totalColumnCount: 7
selectedColumnCount: 7
totalRowCount: 101
successRowCount: 101
warnings: 0
importOperation: created
columnDetails:
Date: Date
Region: Plain Text
Product Category: Plain Text
Product: Plain Text
Customer Name: Plain Text
Sales: Currency
Cost: Currency
importErrors: ''
default:
$ref: https://raw.githubusercontent.com/zoho/analytics-oas/refs/heads/main/v2.0/zoho-analytics-api-common.json#/components/responses/CommonErrorResponse
/restapi/v2/workspaces/{workspace-id}/views/{view-id}/data:
post:
tags:
- Bulk Import - Synchronous
security:
- iam-oauth2-schema:
- ZohoAnalytics.data.create
summary: Import Data into an Existing Table (Synchronous)
description: Use Bulk APIs to import data into an existing specified table synchronously.
operationId: importDataExistingTable
parameters:
- $ref: '#/components/parameters/org-id'
- $ref: '#/components/parameters/workspace-id'
- $ref: '#/components/parameters/view-id'
- in: query
name: CONFIG
required: true
schema:
type: string
examples:
JSON:
summary: JSON
value:
importType: append
fileType: json
autoIdentify: 'true'
CSV:
summary: CSV
value:
importType: append
fileType: csv
autoIdentify: 'true'
description: JSONObject with configuration to create a new table and import data on the same. (Refer `ImportConfigExistingTable` schema). Value must be stringified and URL-encoded.
requestBody:
description: Provide either FILE (as a binary file) or DATA (as raw text). Only one should be sent.
required: true
content:
multipart/form-data:
schema:
type: object
properties:
FILE:
type: string
format: binary
description: The file to be imported. Only one of FILE or DATA should be provided.
DATA:
type: string
description: Raw data (CSV or JSON) to be imported. Only one of FILE or DATA should be provided.
examples:
- '[{"Region":"East"},{"Region":"West"}]'
text/plain:
schema:
type: string
description: The raw data to be imported (plain text body).
responses:
'200':
description: Successful import data response
content:
application/json:
schema:
$ref: '#/components/schemas/ExistImportSuccessResponse'
examples:
Default:
value:
status: success
summary: Import data
data:
viewId: '1767024000003153002'
importSummary:
importType: APPEND
totalColumnCount: 7
selectedColumnCount: 7
totalRowCount: 101
successRowCount: 101
warnings: 0
importOperation: updated
columnDetails:
Date: Date
Region: Plain Text
Product Category: Plain Text
Product: Plain Text
Customer Name: Plain Text
Sales: Currency
Cost: Currency
importErrors: ''
default:
$ref: https://raw.githubusercontent.com/zoho/analytics-oas/refs/heads/main/v2.0/zoho-analytics-api-common.json#/components/responses/CommonErrorResponse
components:
parameters:
org-id:
name: ZANALYTICS-ORGID
in: header
required: true
schema:
type: string
description: Organization ID (can be obtained using Get Organizations API).
workspace-id:
name: workspace-id
in: path
required: true
schema:
type: string
description: ID of the workspace.
view-id:
name: view-id
in: path
required: true
schema:
type: string
description: ID of the view.
schemas:
ImportSuccessResponse:
type: object
properties:
status:
type: string
enum:
- success
summary:
type: string
data:
type: object
properties:
viewId:
type: string
importSummary:
type: object
properties:
importType:
type: string
totalColumnCount:
type: integer
selectedColumnCount:
type: integer
totalRowCount:
type: integer
successRowCount:
type: integer
warnings:
type: integer
importOperation:
type: string
columnDetails:
type: object
additionalProperties:
type: string
importErrors:
type: string
ExistImportSuccessResponse:
type: object
properties:
status:
type: string
enum:
- success
summary:
type: string
data:
type: object
properties:
importSummary:
type: object
properties:
importType:
type: string
totalColumnCount:
type: integer
selectedColumnCount:
type: integer
totalRowCount:
type: integer
successRowCount:
type: integer
warnings:
type: integer
importOperation:
type: string
columnDetails:
type: object
additionalProperties:
type: string
importErrors:
type: string
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.