Zoho Analytics Bulk Import - Batch API
Operations for importing large data files in batches.
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-batch-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 - Batch 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 - Batch
description: Operations for importing large data files in batches.
paths:
/restapi/v2/bulk/workspaces/{workspace-id}/data/batch:
post:
tags:
- Bulk Import - Batch
security:
- iam-oauth2-schema:
- ZohoAnalytics.data.create
summary: Batch Import Data into New Table
description: 'Initiate an import job to create a new table and import data in batches into the created table.
The Batch Import API allows you to upload large amounts of data in batches. A large data file is split into small batches, each batch not exceeding 100 MB, and imported using batch import. Alternatively, you can also use Zoho Analytics SDKs to simplify the batching process.
To import large amounts of data using Batch Import, follow the steps below:
- Split the large CSV file into batches (each batch not exceeding 100MB) and upload the first batch using the Batch Import API''s {"batchKey":"start"} attribute.
- The server will generate a unique job ID and batch key for the import job and send them to the user in the response.
- Use the received batch key to submit the subsequent batches to the Batch Import API.
- Mark the end of the upload by adding {"isLastBatch":true} to the final batch.
You can check the import job status using the ''Get Import Job Details'' API with the jobId received in the response.
Notes:
- After the first batch is imported, scheduled import of the remaining batches begins automatically.
- For ''Append'' and ''UpdateAdd'' import types, each batch is committed individually.
- For ''TruncateAdd'', data is committed only after the final batch is uploaded.
- Batch order is preserved throughout.
- An import summary is stored upon job completion or failure.'
operationId: batchImportNewTable
parameters:
- $ref: '#/components/parameters/org-id'
- $ref: '#/components/parameters/workspace-id'
- in: query
name: CONFIG
required: true
schema:
type: string
examples:
first:
summary: First Call
value: '{"tableName":"SalesTable","autoIdentify":"true","onError":"setcolumnempty","batchKey":"start","isLastBatch":"false"}'
followup:
summary: Follow Up Call
value: '{"tableName":"SalesTable","autoIdentify":"true","onError":"setcolumnempty","batchKey":"1694703482470_1767024000008426012_SalesTable","isLastBatch":"false"}'
last:
summary: Last Call
value: '{"tableName":"SalesTable","autoIdentify":"true","onError":"setcolumnempty","batchKey":"1694703482470_1767024000008426012_SalesTable","isLastBatch":"true"}'
description: JSONObject with configuration to initiate a batch import job. (Refer `BatchImportConfigNewTable` schema). Value must be stringified and URL-encoded.
requestBody:
description: 'The data file for the batch import. Max allowed file size is 100 MB. '
required: true
content:
multipart/form-data:
schema:
type: object
properties:
FILE:
type: string
format: binary
description: The file to be imported as a batch.
required:
- FILE
responses:
'200':
description: Successful batch import response
content:
application/json:
schema:
$ref: '#/components/schemas/BatchImportSuccessResponse'
examples:
Default:
value:
status: success
summary: Create bulk import job
data:
batchKey: 1694703482470_1767024000008426012_SalesTable
jobId: '1767024000008787011'
default:
$ref: https://raw.githubusercontent.com/zoho/analytics-oas/refs/heads/main/v2.0/zoho-analytics-api-common.json#/components/responses/CommonErrorResponse
/restapi/v2/bulk/workspaces/{workspace-id}/views/{view-id}/data/batch:
post:
tags:
- Bulk Import - Batch
security:
- iam-oauth2-schema:
- ZohoAnalytics.data.create
summary: Batch Import Data into Existing Table
description: 'Initiate an import job to import data present in multiple batch files into the specified existing table.
The Batch Import API allows you to upload large amounts of data in batches. A large data file is split into small batches, each batch not exceeding 100 MB, and imported using batch import. Alternatively, you can also use Zoho Analytics SDKs to simplify the batching process.
To import large amounts of data using Batch Import, follow the steps below:
- Split the large CSV file into batches (each batch not exceeding 100MB) and upload the first batch using the Batch Import API''s {"batchKey":"start"} attribute.
- The server will generate a unique job ID and batch key for the import job and send them to the user in the response.
- Use the received batch key to submit the subsequent batches to the Batch Import API.
- Mark the end of the upload by adding {"isLastBatch":true} to the final batch.
You can check the import job status using the ''Get Import Job Details'' API with the jobId received in the response.
Notes:
- After the first batch is imported, scheduled import of the remaining batches begins automatically.
- For ''Append'' and ''UpdateAdd'' import types, each batch is committed individually.
- For ''TruncateAdd'', data is committed only after the final batch is uploaded.
- Batch order is preserved throughout.
- An import summary is stored upon job completion or failure.'
operationId: batchImportExistingTable
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:
first:
summary: First Call
value: '{"importType":"append","autoIdentify":"true","onError":"setcolumnempty","batchKey":"start","isLastBatch":"false"}'
followup:
summary: Follow Up Call
value: '{"importType":"append","autoIdentify":"true","onError":"setcolumnempty","batchKey":"1694703482470_1767024000008426012_SalesTable","isLastBatch":"false"}'
last:
summary: Last Call
value: '{"importType":"append","autoIdentify":"true","onError":"setcolumnempty","batchKey":"1694703482470_1767024000008426012","isLastBatch":"true"}'
description: JSONObject with configuration to initiate a batch import job. (Refer `BatchImportConfigExistingTable` schema). Value must be stringified and URL-encoded.
requestBody:
description: 'The data file for the batch import. Max allowed file size is 100 MB. '
required: true
content:
multipart/form-data:
schema:
type: object
properties:
FILE:
type: string
format: binary
description: The file to be imported as a batch.
required:
- FILE
responses:
'200':
description: Successful batch import response
content:
application/json:
schema:
$ref: '#/components/schemas/BatchImportSuccessResponse'
examples:
Default:
value:
status: success
summary: Create bulk import job
data:
batchKey: '1694703618038_1767024000008742002'
jobId: '1767024000008787011'
default:
$ref: https://raw.githubusercontent.com/zoho/analytics-oas/refs/heads/main/v2.0/zoho-analytics-api-common.json#/components/responses/CommonErrorResponse
components:
schemas:
BatchImportSuccessResponse:
type: object
properties:
status:
type: string
enum:
- success
summary:
type: string
data:
type: object
properties:
jobId:
type: string
description: The unique identifier of the batch import job.
batchKey:
type: string
description: The key to identify the next batch.
parameters:
org-id:
name: ZANALYTICS-ORGID
in: header
required: true
schema:
type: string
description: Organization ID (can be obtained using Get Organizations API).
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.
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.