Class BulkAPI

BulkAPI module contains APIs used to import bulk data into Zoho Analytics table and also offers APIs to export your tables, reports, dashboards in PDF, Excel, JSON, HTML, Image, and CSV formats.

Inheritance

System.Object

BulkAPI

Implements

IBulkAPI

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: ZohoAnalytics

Assembly: ZohoAnalytics.dll

Syntax

public class BulkAPI : IBulkAPI

Methods

ExportBulkData(Int64, String)

Export the mentioned job id.

Declaration

public void ExportBulkData(long jobId, string filePath)

Parameters

Type	Name	Description
System.Int64	jobId	Id of the job to be exported.
System.String	filePath	Path of the file where the data exported to be stored.

ExportData(Int64, String, String, Dictionary<String, Object>)

Export the mentioned table (or) view data.

Declaration

public void ExportData(long viewId, string responseFormat, string filePath, Dictionary<string, object> config)

Parameters

Type	Name	Description
System.Int64	viewId	Id of the view to be exported.
System.String	responseFormat	The format in which the data is to be exported.
System.String	filePath	Path of the file where the data exported to be stored.
Dictionary<System.String, System.Object>	config	Contains any additional control configurations. Can be null.

GetExportJobDetails(Int64)

Returns the details of the export job.

Declaration

public JsonElement GetExportJobDetails(long jobId)

Parameters

Type	Name	Description
System.Int64	jobId	Id of the export job.

Returns

Type	Description
System.Text.Json.JsonElement	Export job details.

GetImportJobDetails(Int64)

Returns the details of the import job.

Declaration

public JsonElement GetImportJobDetails(long jobId)

Parameters

Type	Name	Description
System.Int64	jobId	Id of the import job.

Returns

Type	Description
System.Text.Json.JsonElement	Import result.

ImportBulkData(Int64, String, String, Boolean, String, Dictionary<String, String>)

Asynchronously imports the data contained in the mentioned file into the specified table.

Declaration

public long ImportBulkData(long viewId, string importType, string fileType, bool autoIdentify, string filePath, Dictionary<string, string> config)

Parameters

Type	Name	Description
System.Int64	viewId	Id of the view where the data will be imported.
System.String	importType	The type of import to be performed.
System.String	fileType	Type of the file to be imported.
System.Boolean	autoIdentify	Specifies whether to automatically identify the CSV format (true/false).
System.String	filePath	Path of the file to be imported.
Dictionary<System.String, System.String>	config	Contains any additional control configurations. (Dictionary<string, string>)

Returns

Type	Description
System.Int64	The ID of the created job.

ImportBulkDataAsBatches(Int64, String, Boolean, String, Int32, Dictionary<String, Object>)

Import the data contained in the mentioned file into the table.

Declaration

public long ImportBulkDataAsBatches(long viewId, string importType, bool autoIdentify, string filePath, int batchSize, Dictionary<string, object> config)

Parameters

Type	Name	Description
System.Int64	viewId	Id of the view where the data to be imported.
System.String	importType	The import type.
System.Boolean	autoIdentify	Used to specify whether to auto identify the CSV format. Allowable values - true/false.
System.String	filePath	Path of the file to be imported.
System.Int32	batchSize	Number of lines per batch.
Dictionary<System.String, System.Object>	config	Contains any additional control configurations. Can be null.

Returns

Type	Description
System.Int64	The created job id.

ImportBulkDataInNewTable(String, String, Boolean, String, Dictionary<String, Object>)

Asynchronously create a new table and import the data contained in the mentioned file into the created table.

Declaration

public long ImportBulkDataInNewTable(string tableName, string fileType, bool autoIdentify, string filePath, Dictionary<string, object> config)

Parameters

Type	Name	Description
System.String	tableName	Name of the new table to be created.
System.String	fileType	Type of the file to be imported.
System.Boolean	autoIdentify	Used to specify whether to auto identify the CSV format. Allowable values - true/false.
System.String	filePath	Path of the file to be imported.
Dictionary<System.String, System.Object>	config	Contains any additional control configurations. Can be null.

Returns

Type	Description
System.Int64	The created job id.

ImportBulkDataInNewTableAsBatches(String, Boolean, String, Int32, Dictionary<String, Object>)

Asynchronously create a new table and import the data contained in the mentioned file into the created table.

Declaration

public long ImportBulkDataInNewTableAsBatches(string tableName, bool autoIdentify, string filePath, int batchSize, Dictionary<string, object> config)

Parameters

Type	Name	Description
System.String	tableName	Name of the new table to be created.
System.Boolean	autoIdentify	Used to specify whether to auto identify the CSV format. Allowable values - true/false.
System.String	filePath	Path of the file to be imported.
System.Int32	batchSize	Number of lines per batch.
Dictionary<System.String, System.Object>	config	Contains any additional control configurations. Can be null.

Returns

Type	Description
System.Int64	The created job id.

ImportData(Int64, String, String, Boolean, String, Dictionary<String, Object>)

Import the data contained in the mentioned file into the table.

Declaration

public JsonElement ImportData(long viewId, string importType, string fileType, bool autoIdentify, string filePath, Dictionary<string, object> config)

Parameters

Type	Name	Description
System.Int64	viewId	Id of the view where the data to be imported.
System.String	importType	The import type.
System.String	fileType	Type of the file to be imported.
System.Boolean	autoIdentify	Used to specify whether to auto identify the CSV format. Allowable values - true/false.
System.String	filePath	Path of the file to be imported.
Dictionary<System.String, System.Object>	config	Contains any additional control configurations. Can be null.

Returns

Type	Description
System.Text.Json.JsonElement	Import result.

ImportDataInNewTable(String, String, Boolean, String, Dictionary<String, Object>)

Create a new table and import the data contained in the mentioned file into the created table.

Declaration

public JsonElement ImportDataInNewTable(string tableName, string fileType, bool autoIdentify, string filePath, Dictionary<string, object> config)

Parameters

Type	Name	Description
System.String	tableName	Name of the new table to be created.
System.String	fileType	Type of the file to be imported.
System.Boolean	autoIdentify	Used to specify whether to auto identify the CSV format. Allowable values - true/false.
System.String	filePath	Path of the file to be imported.
Dictionary<System.String, System.Object>	config	Contains any additional control configurations. Can be null.

Returns

Type	Description
System.Text.Json.JsonElement	Import result.

ImportRawData(Int64, String, String, Boolean, String, Dictionary<String, Object>)

Import the raw data provided into the table.

Declaration

public JsonElement ImportRawData(long viewId, string importType, string fileType, bool autoIdentify, string rawData, Dictionary<string, object> config)

Parameters

Type	Name	Description
System.Int64	viewId	Id of the view where the data to be imported.
System.String	importType	The import type.
System.String	fileType	Type of the file to be imported.
System.Boolean	autoIdentify	Used to specify whether to auto identify the CSV format. Allowable values - true/false.
System.String	rawData	Raw data to be imported.
Dictionary<System.String, System.Object>	config	Contains any additional control configurations. Can be null.

Returns

Type	Description
System.Text.Json.JsonElement	Import result.

ImportRawDataInNewTable(String, String, Boolean, String, Dictionary<String, Object>)

Create a new table and import the raw data provided into the created table.

Declaration

public JsonElement ImportRawDataInNewTable(string tableName, string fileType, bool autoIdentify, string rawData, Dictionary<string, object> config)

Parameters

Type	Name	Description
System.String	tableName	Name of the new table to be created.
System.String	fileType	Type of the file to be imported.
System.Boolean	autoIdentify	Used to specify whether to auto identify the CSV format. Allowable values - true/false.
System.String	rawData	Raw data to be imported.
Dictionary<System.String, System.Object>	config	Contains any additional control configurations. Can be null.

Returns

Type	Description
System.Text.Json.JsonElement	Import result.

InitiateBulkExport(Int64, String, Dictionary<String, Object>)

Initiate asynchronous export for the mentioned table (or) view data.

Declaration

public long InitiateBulkExport(long viewId, string responseFormat, Dictionary<string, object> config)

Parameters

Type	Name	Description
System.Int64	viewId	Id of the view to be exported.
System.String	responseFormat	The format in which the data is to be exported.
Dictionary<System.String, System.Object>	config	Contains any additional control configurations. Can be null.

Returns

Type	Description
System.Int64	Export job id.

InitiateBulkExportUsingSQL(String, String, Dictionary<String, Object>)

Initiate asynchronous export with the given SQL Query.

Declaration

public long InitiateBulkExportUsingSQL(string sqlQuery, string responseFormat, Dictionary<string, object> config)

Parameters

Type	Name	Description
System.String	sqlQuery	The SQL Query whose output is exported.
System.String	responseFormat	The format in which the data is to be exported.
Dictionary<System.String, System.Object>	config	Contains any additional control configurations. Can be null.

Returns

Type	Description
System.Int64	Export job id.

Implements

IBulkAPI