Create Import Job for a new table

You can create an import job to import data into a new table.

REQUEST URI

https://<ZohoAnalytics_Server_URI>/restapi/v2/bulk/workspaces/<workspace-id>/data

Post

oauthscope: ZohoAnalytics.data.create

ACTION SPECIFIC PARAMETERS

Parameter Name	Description
FILE^*	*File* The file to be imported. Format should be multipart/form-data. (This is the default format used by html forms that contain file type fields used for uploading files) Maximum allowed file size is 100 MB.

QUERY PARAMETERS

Parameter Name	Description
CONFIG^*	*JSONObject* Config parameter specifications are available in the below section.

FIELDS FOR CONFIG JSON

Key	Description
tableName^*	*String* The name of the table.
fileType^*	*String* The format of the file to be imported. csv json
autoIdentify^*	*Boolean* To specify whether to auto identify the CSV format.
onError	*String* Controls the action to be taken incase there is an error during import. abort - Incase of any error, abort the whole import. skiprow - In case of any error, skip that specific row(s) which has the problem and continue importing the rest. setcolumnempty - In case of any error, set the value of the error column for the row to empty and continue importing.
selectedColumns	*JSONArray* Controls the columns that need to be imported. `Sample: ["column1","column2"]`
skipTop	*Integer* Number of rows that are to be skipped from the top in the CSV file being imported.
thousandSeparator	*Integer* Controls the action to be taken in case there is a thousand separator in the data. 0 - COMMA 1 - DOT 2 - SPACE 3 - SINGLE QUOTE
decimalSeparator	*Integer* Controls the action to be taken in case there is a decimal separator in the data. 0 - DOT 1 - COMMA
dateFormat	*String* Specify this in-case any date field is being imported and its format cannot be auto recognized by Zoho Analytics. `Sample: dd-MMM-YYYY` Refer this link for more details about how to construct a custom date format.
columnDateFormat	*JSONObject* Specify this in case multiple date fields are being imported having different format each. Column name as key and date format as value. `Sample: {"columnName1":"dd-MMM-YYYY","columnName2":"MM/dd/yyyy"}`
callbackUrl	*String* A valid URL, that should allow HTTP Post method. The Bulk Import Job's details is posted to this URL on successful completion of job or on failure of job.

CSV SPECIFIC ATTRIBUTES

Note : These attributes are mandatory if autoIdentify is set to false.

Key	Description
commentChar	*Char* If the character mentioned is found at the beginning of the row, the csv row will be skipped. `Sample: #`
delimiter	*Integer* The delimiter character used for separating the fields in a row in the CSV. 0 - COMMA 1 - TAB 2 - SEMICOLON 3 - SPACE
quoted	*Integer* The Text Qualifier. 0 - NONE 1 - SINGLE QUOTE 2 - DOUBLE QUOTE

JSON SPECIFIC ATTRIBUTES

Key	Description
retainColumnNames	*Boolean* Controls how the columns names are to be constructed from the JSON file. Default value - false. true - the final key attribute alone will be considered as column name. false - the column name will be constructed by appending all the parent attributes separated by dot (.). This will result in column names which captures the full JSON tree hierarchy eg., employee.Name, employee.Department

Key

Description

retainColumnNames

Boolean
Controls how the columns names are to be constructed from the JSON file.
Default value - false.

true - the final key attribute alone will be considered as column name.
false - the column name will be constructed by appending all the parent attributes separated by dot (.). This will result in column names which captures the full JSON tree hierarchy eg., employee.Name, employee.Department

POSSIBLE ERROR CODES

7103, 7111, 7232, 7248, 7249, 8046, 8119, 8504, 8506, 8513, 8516

Sample Request

Curl Csharp Go Java PHP Python Node JS Deluge

Copiedcurl https://analyticsapi.zoho.com/restapi/v2/bulk/workspaces/<workspace-id>/data?CONFIG=<encoded_json_value> 
-F 'FILE=@/home/local/import.csv' 
-X 'POST' 
-H 'ZANALYTICS-ORGID: <org-id>' 
-H 'Authorization: Zoho-oauthtoken <access_token>'

Copiedusing System;
using System.Collections.Generic;
using ZohoAnalytics;
using System.Text.Json;

namespace ZohoAnalyticsTest
{
    class Program
    {
        long orgId = 55522777;
        long workspaceId = 35130000001055707;

        public void ImportBulkDataInNewTable(IAnalyticsClient ac)
        {
            string tableName = "C#_NewTable";
            string fileType = "csv";
            bool autoIdentify = true;
            string filePath = "C:\\Users\\Administrator\\Downloads\\SalesTable_Export_nov_23.csv";
            IBulkAPI data = ac.GetBulkInstance(orgId, workspaceId);
            long jobId = data.ImportBulkDataInNewTable(tableName, fileType, autoIdentify, filePath, null);
            Console.WriteLine(jobId);
        }

        static void Main(string[] args)
        {
            string clientId = "1000.xxxxxxx";
            string clientSecret = "xxxxxxx";
            string refreshToken = "1000.xxxxxxx.xxxxxxx";

            try
            {
                IAnalyticsClient ac = new AnalyticsClient(clientId, clientSecret, refreshToken);
                Program obj = new Program();
                obj.ImportBulkDataInNewTable(ac);
            }
            catch (ServerException ex)
            {
                Console.WriteLine("Server exception - " + ex.GetErrorMessage());
            }
            catch (Exception ex)
            {
                Console.WriteLine("Other exception - " + ex.Message);
            }
        }
    }
}

Copiedpackage main

import (
    "fmt"
    ZAnalytics "zoho/pkg/analyticsclient"
)

var(
    clientId = "1000.xxxxxxx"
    clientSecret = "xxxxxxx"
    refreshToken = "1000.xxxxxxx.xxxxxxx"

    orgId = "55522777"
    workspaceId = "35130000001055707"
)

func ImportBulkDataInNewTable(ac ZAnalytics.Client) {
    config := map[string]interface{}{}
    tablename := "go lang bulk import"
    filetype := "csv"
    autoidentify := "true"
    filepath := "/home/local/admin/Files/Sales.csv"
    bulk := ZAnalytics.GetBulkInstance(&ac, orgId, workspaceId)
    result, err := bulk.ImportBulkDataInNewTable(tablename, filetype, autoidentify, filepath, config)

    if(err != nil){
        fmt.Println("Error - " + err.ErrorMessage)
    }else{
        fmt.Println(result)
    }
}

func main() {

    ac := ZAnalytics.GetAnalyticsClient(clientId, clientSecret, refreshToken)
    ImportBulkDataInNewTable(ac)

}

Copiedimport com.zoho.analytics.client.*;
import org.json.*;

public class Test {

    private long orgId = 55522777l;
    private long workspaceId = 35130000001055707l;

    public static void main(String args[]){

        String clientId = "1000.xxxxxxx";
        String clientSecret = "xxxxxxx";
        String refreshToken = "1000.xxxxxxx.xxxxxxx";

        Test tObj = new Test();
        AnalyticsClient ac = new AnalyticsClient(clientId, clientSecret, refreshToken);

        try {
            tObj.importBulkDataInNewTable(ac);
        }
        catch (ServerException ex) {
            System.out.println("Server exception - ErrorCode : " + ex.getErrorCode() + ", ErrorMessage : "  + ex.getErrorMessage());
        }
        catch (ParseException ex) {
            System.out.println("Parser exception - ErrorMessage : "  + ex.getResponseMessage());
        }
        catch (Exception ex) {
            System.out.println("Other exception - ");
            ex.printStackTrace();
        }
    }

    public void importBulkDataInNewTable(AnalyticsClient ac) throws Exception {
        String tableName = "JAVA Bulk Table";
        String fileType = "csv";
        boolean autoIdentify = true;
        String filePath = "/home/local/admin/Files/Sales.csv";
        JSONObject config = new JSONObject();
        BulkAPI data = ac.getBulkInstance(orgId, workspaceId);
        long jobId = data.importBulkDataInNewTable(tableName, fileType, autoIdentify, filePath, config);
        System.out.println(jobId);
    }
}

Copied<?php

    require 'AnalyticsClient.php';

    class Test
    {
        public $ac = NULL;
        public $client_id = "1000.xxxxxxx";
        public $client_secret = "xxxxxxx";
        public $refresh_token = "1000.xxxxxxx.xxxxxxx";

        public $org_id = "55522777";
        public $workspace_id = "35130000001055707";

        function __construct() {
            $this->ac =  new AnalyticsClient($this->client_id, $this->client_secret, $this->refresh_token);
        }

        function importBulkDataInNewTable() {
            $table_name = "json1";
            $file_type = "json";
            $auto_identify = "true";
            $file_path = "/home/local/admin/Files/Sales.json";
            $bulk = $this->ac->getBulkInstance($this->org_id, $this->workspace_id);
            $response = $bulk->importBulkDataInNewTable($table_name, $file_type, $auto_identify, $file_path);
            print_r($response);
        }
    }

    $test_obj = new Test();

    try {
        $test_obj->importBulkDataInNewTable();
    }
    catch(ServerException $se) {
        echo "Server exception : " . $se->getErrorMessage() . "\n";
    }
    catch(IOException $ioe) {
        echo "IO exception : " . $ioe->getErrorMessage() . "\n";
    }
    catch(ParseException $pe) {
        echo "Parser exception : " . $pe->getErrorMessage() . "\n";
    }
    catch(Exception $e) {
        echo "Exception : " . $e->getErrorMessage() . "\n";
    }
?>

Copiedfrom __future__ import with_statement
from AnalyticsClient import AnalyticsClient
import sys
import json

class Config:

    CLIENTID = "1000.xxxxxxx";
    CLIENTSECRET = "xxxxxxx";
    REFRESHTOKEN = "1000.xxxxxxx.xxxxxxx";

    ORGID = "55522777";
    WORKSPACEID = "35130000001055707";

class sample:

    ac = AnalyticsClient(Config.CLIENTID, Config.CLIENTSECRET, Config.REFRESHTOKEN)

    def import_bulk_data_in_new_table(self, ac):
        table_name = "Bulk Table"
        file_type = "csv"
        auto_identify = "true"
        file_path = "/home/local/admin/Files/Sales.csv"
        bulk = ac.get_bulk_instance(Config.ORGID, Config.WORKSPACEID)
        result = bulk.import_bulk_data_in_new_table(table_name, file_type, auto_identify, file_path)
        print(result)

try:
    obj = sample()
    obj.import_bulk_data_in_new_table(obj.ac);

except Exception as e:
    print(str(e))

Copiedvar analyticsClient = require('./AnalyticsClient');

var clientId = '1000.xxxxxxx';
var clientSecret = 'xxxxxxx';
var refreshtoken = '1000.xxxxxxx.xxxxxxx';
var orgId = '55522777';
var workspaceId = '35130000001055707';

var ac = new analyticsClient(clientId, clientSecret, refreshtoken);

var tableName = 'W1';
var fileType = 'csv';
var autoIdentify = true;
var filePath = '/home/local/admin/Files/Sales.csv';
var bulk = ac.getBulkInstance(orgId, workspaceId);
bulk.importBulkDataInNewTable(tableName, fileType, autoIdentify, filePath).then((response) => {
    console.log(response);

}).catch((error) => {
    console.log('errorCode : '+error.errorCode);
    console.log('errorMessage : '+error.errorMessage);
});

CopiedorgId = "55522777";
workspaceId = "35130000001055707";

headersMap = Map();
headersMap.put("ZANALYTICS-ORGID",orgId);
fileResponse = invokeurl
[
  url :""
  type :GET
];
file = fileResponse.toFile("Sample.csv");
file.setParamName("FILE");
config = Map();
config.put("tableName","New Table");
config.put("fileType","csv");
config.put("autoIdentify","true");
parameters = "CONFIG=" + zoho.encryption.urlEncode(config.toString());
response = invokeurl
[
  url :"https://analyticsapi.zoho.com/restapi/v2/bulk/workspaces/" + workspaceId + "/data" + "?" + parameters
  type :POST
  headers:headersMap
  files:file
  connection:"analytics_oauth_connection"
];
info response;

Sample value for CONFIG parameter:

Copied{
"tableName":"<table-name>",
"fileType":"csv",
"autoIdentify":"true"
}

Sample Response

CopiedHTTP/1.1 200 OK
Content-Type:application/json;charset=UTF-8

{
    "status": "success",
    "summary": "Create bulk import job",
    "data": {
        "jobId": "1767024000003153087"
    }
}