Mass Update API

The mass update feature allows you to update the values of specific fields for multiple records in territories or custom views in a module. This API is useful when you want to update the same field for all records in a module, territory, or a custom view.

In this API, the input contains the API names of the fields whose values you want to update, and the record ids, cvids(custom view IDs), or territory_id.

You can update up to 50,000 (fifty thousand) records using this API.

Mass update of records happens in two ways:

  • Scheduler type: When you specify custom view ID and territory ID, a job is scheduled in the background and the system returns a "job_id". Use this job_id in the GET request to get the result.

  • Non-scheduler type: When you specify the record IDs, system updates the records instantly. You can update a maximum of 500 records in a single API call in this type of mass update.

Mass Update Records

Purpose

To schedule mass update.

Request Details

Request URL

https://www.zohoapis.com/crm/v2/{module_api_name}/actions/mass_update

Supported modules

Leads, Accounts, Contacts, Deals, Campaigns, Activities, Solutions, Products, Vendors, Price Books, Quotes, Sales Orders, Purchase Orders, Invoices, and Custom

Header

Authorization: Zoho-oauthtoken d92d4xxxxxxxxxxxxx15f52

Scope

scope=ZohoCRM.mass_update.UPDATE 
(or) 
scope=ZohoCRM.mass_update.{module_name}.UPDATE 

Possible module names

leads, accounts, contacts, deals, campaigns, activities, solutions, products, vendors, pricebooks, quotes, salesorders, purchaseorders, invoices, and custom

Possible operation types

UPDATE - To schedule mass update

Sample Request

Copiedcurl "https://www.zohoapis.com/crm/v2/Accounts/actions/mass_update"
-H "Authorization: Zoho-oauthtoken 1000.8cb99dxxxxxxxxxxxxx9be93.9b8xxxxxxxxxxxxxxxf"
-d "@input.json"
-X POST
3.0.08.0
Copied//API Name of the module to massUpdateRecords
String moduleAPIName = "Leads";

//Get instance of RecordOperations Class
RecordOperations recordOperations = new RecordOperations();

//Get instance of MassUpdateBodyWrapper Class that will contain the request body
MassUpdateBodyWrapper request = new MassUpdateBodyWrapper();

//List of Record instances
List < com.zoho.crm.api.record.Record > records = new ArrayList < com.zoho.crm.api.record.Record > ();

//Get instance of Record Class
com.zoho.crm.api.record.Record record1 = new com.zoho.crm.api.record.Record();

/*
 * Call addKeyValue method that takes two arguments
 * 1 -> A string that is the Field's API Name
 * 2 -> Value
 */
record1.addKeyValue("City", "Value");

//Add Record instance to the list
records.add(record1);

//Set the list to Records in BodyWrapper instance
request.setData(records);

request.setCvid("3477061000000087501");

List < Long > ids = new ArrayList < Long > (Arrays.asList(3477061000005922192 L));

request.setIds(ids);

//		Territory territory = new Territory();
//		
//		territory.setId("");
//		
//		territory.setIncludeChild(true);
//		
//		request.setTerritory(territory);

request.setOverWrite(true);

//Call massUpdateRecords method that takes ModuleAPIName and  BodyWrapper instance as parameter.
APIResponse < MassUpdateActionHandler > response = recordOperations.massUpdateRecords(moduleAPIName, request);
Copiedimport javax.net.ssl.SSLContext;
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.methods.HttpEntityEnclosingRequestBase;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.client.methods.HttpUriRequest;
import org.apache.http.client.utils.URIBuilder;
import org.apache.http.conn.ssl.NoopHostnameVerifier;
import org.apache.http.conn.ssl.SSLConnectionSocketFactory;
import org.apache.http.entity.StringEntity;
import org.apache.http.impl.client.CloseableHttpClient;
import org.apache.http.impl.client.HttpClientBuilder;
import org.apache.http.protocol.HTTP;
import org.apache.http.util.EntityUtils;
import org.json.JSONArray;
import org.json.JSONObject;
public class MassUpdateAPI 
{
	@SuppressWarnings("deprecation")
	public static void main(String[] args) 
	{
		try
		{
			HttpClientBuilder httpClientBuilder = HttpClientBuilder.create();
			SSLContext sslContext = SSLContext.getDefault();
			SSLConnectionSocketFactory sslConnectionSocketFactory = new SSLConnectionSocketFactory(sslContext, NoopHostnameVerifier.INSTANCE);
			CloseableHttpClient httpclient = httpClientBuilder.setSSLSocketFactory(sslConnectionSocketFactory).build();
			URIBuilder uriBuilder = new URIBuilder("https://www.zohoapis.com/crm/v2/Leads/actions/mass_update");
			HttpUriRequest requestObj = new HttpPost(uriBuilder.build());
			HttpEntityEnclosingRequestBase requestBase = (HttpEntityEnclosingRequestBase) requestObj;
			JSONObject requestBody = new JSONObject();
			JSONArray recordArray = new JSONArray();
			JSONObject recordObject = new JSONObject();
			recordObject.put("Company", "Zoho");
			recordArray.put(recordObject);
			requestBody.put("data", recordArray);
			requestBody.put("cvid", "34770610087501");
			JSONArray ids = new JSONArray();
			ids.put("34770615922192");
			requestBody.put("ids", ids);
			requestBase.setEntity(new StringEntity(requestBody.toString(), HTTP.UTF_8));
			requestObj.addHeader("Authorization", "Zoho-oauthtoken 1000.xxxxxxx.xxxxxxx");
			HttpResponse response = httpclient.execute(requestObj);
			HttpEntity responseEntity = response.getEntity();
			System.out.println("HTTP Status Code : " + response.getStatusLine().getStatusCode());
			if(responseEntity != null)
			{
				Object responseObject = EntityUtils.toString(responseEntity);
				String responseString = responseObject.toString();
				System.out.println(responseString);
			}
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
	}
}
3.0.07.x
Copied//Get instance of RecordOperations Class
$recordOperations = new RecordOperations();
//Get instance of MassUpdateBodyWrapper Class that will contain the request body
$request = new MassUpdateBodyWrapper();
//List of Record instances
$records = array();
$recordClass = 'com\zoho\crm\api\record\Record';
//Get instance of Record Class
$record1 = new $recordClass();
/*
* Call addKeyValue method that takes two arguments
* 1 -> A string that is the Field's API Name
* 2 -> Value
*/
$record1->addKeyValue("City", "Value");
//Add Record instance to the list
array_push($records, $record1);
//Set the list to Records in BodyWrapper instance
$request->setData($records);
$request->setCvid("3477061000000087501");
$request->setOverWrite(true);
//Call massUpdateRecords method that takes BodyWrapper instance, ModuleAPIName as parameter.
$response = $recordOperations->massUpdateRecords($moduleAPIName, $request);
Copied<?php
class MassUpdate{
    
    public function execute(){
        $curl_pointer = curl_init();
        
        $curl_options = array();
        $curl_options[CURLOPT_URL] = "https://www.zohoapis.com/crm/v2/Leads/actions/mass_update";
        $curl_options[CURLOPT_RETURNTRANSFER] = true;
        $curl_options[CURLOPT_HEADER] = 1;
        $curl_options[CURLOPT_CUSTOMREQUEST] = "POST";
        $requestBody = array();
        $recordArray = array();
        $recordObject = array();
        $recordObject["Company"] = "Zoho";
        $requestBody["cvid"]="35240330087501";
        $requestBody["ids"]=["35240335811001"];
        $recordArray[] = $recordObject;
        $requestBody["data"] =$recordArray;
        
        $curl_options[CURLOPT_POSTFIELDS]= json_encode($requestBody);
        
        $headersArray = array();
        
        $headersArray[] = "Authorization". ":" . "Zoho-oauthtoken " . "1000.8cb99dxxxxxxxxxxxxx9be93.9b8xxxxxxxxxxxxxxxf";
        
        $curl_options[CURLOPT_HTTPHEADER]=$headersArray;
        
        curl_setopt_array($curl_pointer, $curl_options);
        
        $result = curl_exec($curl_pointer);
        $responseInfo = curl_getinfo($curl_pointer);
        curl_close($curl_pointer);
        list ($headers, $content) = explode("\r\n\r\n", $result, 2);
        if(strpos($headers," 100 Continue")!==false){
            list( $headers, $content) = explode( "\r\n\r\n", $content , 2);
        }
        $headerArray = (explode("\r\n", $headers, 50));
        $headerMap = array();
        foreach ($headerArray as $key) {
            if (strpos($key, ":") != false) {
                $firstHalf = substr($key, 0, strpos($key, ":"));
                $secondHalf = substr($key, strpos($key, ":") + 1);
                $headerMap[$firstHalf] = trim($secondHalf);
            }
        }
        $jsonResponse = json_decode($content, true);
        if ($jsonResponse == null && $responseInfo['http_code'] != 204) {
            list ($headers, $content) = explode("\r\n\r\n", $content, 2);
            $jsonResponse = json_decode($content, true);
        }
        var_dump($headerMap);
        var_dump($jsonResponse);
        var_dump($responseInfo['http_code']);      
    } 
}
(new MassUpdate())->execute();
3.0.08.x
Copied//Get instance of RecordOperations Class
RecordOperations recordOperations = new RecordOperations();
//Get instance of MassUpdateBodyWrapper Class that will contain the request body
MassUpdateBodyWrapper request = new MassUpdateBodyWrapper();
//List of Record instances
List<Com.Zoho.Crm.API.Record.Record> records = new List<Com.Zoho.Crm.API.Record.Record>();
//Get instance of Record Class
Com.Zoho.Crm.API.Record.Record record1 = new Com.Zoho.Crm.API.Record.Record();
/*
* Call addKeyValue method that takes two arguments
* 1 -> A string that is the Field's API Name
* 2 -> Value
*/
//record1.AddKeyValue("City", "Value");
//Add Record instance to the list
records.Add(record1);
//Set the list to Records in BodyWrapper instance
request.Data = records;
request.Cvid = "3477061000000087501";
List<long?> ids = new List<long?>() { 3477061000005922192 };
request.Ids = ids;
    //Territory territory = new Territory();
    //
    //territory.Id = 3477061000005922192;
    //
    //territory.IncludeChild = true;
    //
    //request.Territory = territory;
request.OverWrite = true;
//Call MassUpdateRecords method that takes ModuleAPIName and BodyWrapper instance as parameter.
APIResponse<MassUpdateActionHandler> response = recordOperations.MassUpdateRecords(moduleAPIName, request);
Copiedusing System;
using System.IO;
using System.Net;
using System.Text;
using Newtonsoft.Json.Linq;
namespace Com.Zoho.Crm.API.Sample.RestAPI.MassUpdate
{
    public class MassUpdateAPI
    {
        public static void MassUpdateRecords()
        {
            HttpWebRequest request = (HttpWebRequest)WebRequest.Create("https://www.zohoapis.com/crm/v2/Leads/actions/mass_update");
            request.Method = "POST";
            request.Headers["Authorization"] = "Zoho-oauthtoken 1000.abfeXXXXXXXXXXX2asw.XXXXXXXXXXXXXXXXXXsdc2";
            JObject requestBody = new JObject();
            JArray recordArray = new JArray();
            JObject recordObject = new JObject();
            recordObject.Add("Company", "Zoho");
            recordArray.Add(recordObject);
            requestBody.Add("data", recordArray);
            requestBody.Add("cvid", "347706187501");
            JArray ids = new JArray();
            ids.Add("3477061922192");
            requestBody.Add("ids", ids);
            string dataString = requestBody.ToString();
            var data = Encoding.UTF8.GetBytes(dataString);
            int dataLength = data.Length;
            request.ContentLength = dataLength;
            using (var writer = request.GetRequestStream())
            {
                writer.Write(data, 0, dataLength);
            }
            request.KeepAlive = true;
            HttpWebResponse response;
            try
            {
                response = (HttpWebResponse)request.GetResponse();
            }
            catch (WebException e)
            {
                if (e.Response == null) { throw; }
                response = (HttpWebResponse)e.Response;
            }
            HttpWebResponse responseEntity = response;
            Console.WriteLine("HTTP Status Code : " + (int)response.StatusCode);
            string responsestring = new StreamReader(responseEntity.GetResponseStream()).ReadToEnd();
            responseEntity.Close();
            Console.WriteLine(responsestring);
        }
    }
}
3.0.03.x.x
Copied# Get instance of RecordOperations Class
record_operations = RecordOperations()
# Get instance of MassUpdateBodyWrapper Class that will contain the request body
request = MassUpdateBodyWrapper()
# List to hold Record instances
records_list = []
# Get instance of Record Class
record = Record()
record.add_field_value(Field.Leads.city(), 'HOO')
# Add the record instance to list
records_list.append(record)
# Set the array to data in MassUpdateBodyWrapper instance
request.set_data(records_list)
# Set the cvid to MassUpdateBodyWrapper instance
request.set_cvid('3409643000000087537')
ids = [3409643000002049003, 3409643000002043003, 3409643000001881002]
# Set the array of IDs to MassUpdateBodyWrapper instance
request.set_ids(ids)
# Set the value to over write
request.set_over_write(True)
# Get instance of Territory Class
territory = Territory()
# Set ID to Territory
territory.set_id(3409643000000505351)
territory.set_include_child(True)
request.set_territory(territory)
# Call mass_update_records method that takes MassUpdateBodyWrapper instance, module_api_name as parameter.
response = record_operations.mass_update_records(module_api_name, request)
Copieddef mass_update_records():
    import requests
    import json

    url = 'https://www.zohoapis.com/crm/v2/Leads/actions/mass_update'

    headers = {
        'Authorization': "Zoho-oauthtoken 1000.04be928e4a96XXXXXXXXXXXXX68.0b9eXXXXXXXXXXXX60396e268"
    }

    request_body = dict()
    record_list = list()

    record_object = {
        'Company': 'Zoho'
    }

    record_list.append(record_object)

    request_body['data'] = record_list
    request_body['cvid'] = '3409643000002804006'

    ids = ['3409643000002804010', '3409643000002804109']
    request_body['ids'] = ids

    response = requests.post(url=url, headers=headers, data=json.dumps(request_body).encode('utf-8'))

    if response is not None:
        print("HTTP Status Code : " + str(response.status_code))

        print(response.json())

mass_update_records()
1.0.010.x
Copied//Get instance of RecordOperations Class
let recordOperations = new RecordOperations();
//Get instance of MassUpdateBodyWrapper Class that will contain the request body
let request = new MassUpdateBodyWrapper();
//Array to hold Record instances
let recordsArray = [];
//Get instance of Record Class
let record = new Record();
record.addFieldValue(RecordField.Leads.CITY, "Chennai");
//Add the record instance to array
recordsArray.push(record);
//Set the array to data in MassUpdateBodyWrapper instance
request.setData(recordsArray);
//Set the cvid to MassUpdateBodyWrapper instance
// request.setCvid("3409643000000087501");
let ids = ["3477061000006916059"];
//Set the array of IDs to MassUpdateBodyWrapper instance
request.setIds(ids);
//Set the value to over write
request.setOverWrite(true);
//Get instance of Territory Class
let territory = new Territory();
//Set ID to Territory
territory.setId(3409643000000505351n);
territory.setIncludeChild(true);
// request.setTerritory(territory);
//Call massUpdateRecords method that takes MassUpdateBodyWrapper instance, ModuleAPIName as parameter.
let response = await recordOperations.massUpdateRecords(moduleAPIName, request);
Copiedasync function massUpdateRecords() {
    const got = require('got');

    let url = 'https://www.zohoapis.com/crm/v2/Leads/actions/mass_update'

    let headers = {
        Authorization : "Zoho-oauthtoken 1000.8cb99dxxxxxxxxxxxxx9be93.9b8xxxxxxxxxxxxxxxf"
    }

    let requestBody = {}
    let recordArray = []

    let recordObject = {
        'Company' : 'Zoho'
    }

    recordArray.push(recordObject)

    requestBody['data'] = recordArray
    requestBody['cvid'] = '3409643000002804006'

    let ids = ['3409643000002804010','3409643000002804109']
    requestBody['ids'] = ids

    let requestDetails = {
        method : "POST",
        headers : headers,
        body : JSON.stringify(requestBody),
        encoding: "utf8",
        throwHttpErrors : false
    };
    
    let response = await got(url, requestDetails)
    
    if(response != null) {
        console.log(response.statusCode);
        console.log(response.body);
    }
}
massUpdateRecords()
2.02.x.x
Copied# """
# example
# module_api_name = "Contacts"
# """
cvid = '3524033000000087501'
# List to hold Record instances
records = []
record_ids = [3_524_033_000_005_925_034]
(0..0).each do |i|
  record = Record::Record.new
  record.add_field_value(Record::Field::Leads.Company, 'asdad')
  records.push(record)
end
mass_update_body_wrapper = Record::MassUpdateBodyWrapper.new
# Set the array to data in MassUpdateBodyWrapper instance
mass_update_body_wrapper.data = records
# Set the array of IDs to MassUpdateBodyWrapper instance
mass_update_body_wrapper.ids = record_ids
# Set the cvid to MassUpdateBodyWrapper instance
mass_update_body_wrapper.cvid = cvid
# Get instance of RecordOperations Class
rr = Record::RecordOperations.new
# Call massUpdateRecords method that takes MassUpdateBodyWrapper instance, module_api_name as parameter.
response = rr.mass_update_records(module_api_name,mass_update_body_wrapper) 
Copiedclass MassUpdate
    def execute
       
        url ="https://www.zohoapis.com/crm/v2/Leads/actions/mass_update"
        url = URI(url)
        req = Net::HTTP::Post.new(url.request_uri)
        http = Net::HTTP.new(url.host, url.port)
        http.use_ssl = true
        headers={}
        headers["Authorization"]="Zoho-oauthtoken 1000.50XXXXXXXXX&77e3a.44XXXXXXXXX8353"
        headers&.each { |key, value| req.add_field(key, value) }
       
        request_body = {};
        record_array = [];
        record_object = {};
        record_object["Company"] = "Zoho";
        request_body["cvid"]="3524033000000087501";
        request_body["ids"]=["3524033000005811001"];


           
        record_array = [record_object];
        request_body["data"] =record_array; 
        request_json = request_body.to_json
        req.body = request_json.to_s
        response=http.request(req)
        status_code = response.code.to_i
        headers = response.each_header.to_h
        print status_code
        print headers
        unless response.body.nil?
            print  response.body
        end
    end
end

MassUpdate.new.execute
1.0.0ES6
Copied//Get instance of RecordOperations Class
let recordOperations = new ZCRM.Record.Operations();
//Get instance of MassUpdateBodyWrapper Class that will contain the request body
let request = new ZCRM.Record.Model.MassUpdateBodyWrapper();
//Array to hold Record instances
let recordsArray = [];
//Get instance of Record Class
let record = new ZCRM.Record.Model.Record();
record.addFieldValue(ZCRM.Record.Model.Field.Leads.CITY, "Chennai");
//Add the record instance to array
recordsArray.push(record);
//Set the array to data in MassUpdateBodyWrapper instance
request.setData(recordsArray);
//Set the cvid to MassUpdateBodyWrapper instance
// request.setCvid("340964387501");
let ids = ["34770616916059"];
//Set the array of IDs to MassUpdateBodyWrapper instance
request.setIds(ids);
//Set the value to over write
request.setOverWrite(true);
//Get instance of Territory Class
let territory = new ZCRM.Record.Model.Territory();
//Set ID to Territory
territory.setId(3409643505351n);
territory.setIncludeChild(true);
// request.setTerritory(territory);
//Call massUpdateRecords method that takes MassUpdateBodyWrapper instance, ModuleAPIName as parameter.
let response = await recordOperations.massUpdateRecords(moduleAPIName, request);
Copiedvar listener = 0;
class MassUpdateAPI {

	async massUpdateRecords()	{
		var url = "https://www.zohoapis.com/crm/v2/Leads/actions/mass_update"
        var parameters = new Map()
        var headers = new Map()
        var token = {
            clientId:"1000.NPY9M1V0XXXXXXXXXXXXXXXXXXXF7H",
            redirectUrl:"http://127.0.0.1:5501/redirect.html",
            scope:"ZohoCRM.mass_update.Leads.UPDATE,ZohoCRM.mass_update.Leads.READ,ZohoCRM.users.ALL,ZohoCRM.bulk.read,ZohoCRM.modules.ALL,ZohoCRM.settings.ALL,Aaaserver.profile.Read,ZohoCRM.org.ALL,profile.userphoto.READ,ZohoFiles.files.ALL,ZohoCRM.bulk.ALL,ZohoCRM.settings.variable_groups.ALL"
        }
        var accesstoken = await new MassUpdateAPI().getToken(token)
        headers.set("Authorization", "Zoho-oauthtoken " + accesstoken)
        var requestMethod = "POST"
        var reqBody = {
            "data": [
                {
                    "Company": "Zoho"
                }
            ],
            "ids": [
                "34770618863043"
            ]
        }
        var params = "";
        parameters.forEach(function(value, key) {
            if (parameters.has(key)) {
                if (params) {
                    params = params + key + '=' + value + '&';
                }
                else {
                    params = key + '=' + value + '&';
                }
            }
        });
        var apiHeaders = {};
        if(headers) {
            headers.forEach(function(value, key) {
                apiHeaders[key] = value;
            });
        }
        if (params.length > 0){
            url = url + '?' + params.substring(0, params.length - 1);
        }
        var requestObj = {
            uri : url,
            method : requestMethod,
            headers : apiHeaders,
            body : JSON.stringify(reqBody),
            encoding: "utf8",
            allowGetBody : true,
			throwHttpErrors : false
        };
        var result = await new MassUpdateAPI().makeAPICall(requestObj);
        console.log(result.status)
        console.log(result.response)
	}

    async getToken(token) {

        if(listener == 0) {

            window.addEventListener("storage", function(reponse) {
                if(reponse.key === "access_token" && (reponse.oldValue != reponse.newValue || reponse.oldValue == null)){
                    location.reload();
                }
                if(reponse.key === "access_token"){

                    sessionStorage.removeItem("__auth_process");
                }
            }, false);
            listener = 1;
            if(sessionStorage.getItem("__auth_process")) {
                sessionStorage.removeItem("__auth_process");
            }
        }
        ["granted_for_session", "access_token","expires_in","expires_in_sec","location","api_domain","state","__token_init","__auth_process"].forEach(function (k) {
            var isKeyExists = localStorage.hasOwnProperty(k);
            if(isKeyExists) {
                sessionStorage.setItem(k, localStorage[k]);
            }
            localStorage.removeItem(k);
        });
        var valueInStore = sessionStorage.getItem("access_token");
        var tokenInit = sessionStorage.getItem("__token_init");
        if(tokenInit != null && valueInStore != null && Date.now() >= parseInt(tokenInit) + 59 * 60 * 1000){ // check after 59th minute
            valueInStore = null;
            sessionStorage.removeItem("access_token");
        }

        var auth_process = sessionStorage.getItem("__auth_process");
        if ((valueInStore == null && auth_process == null) || (valueInStore == 'undefined' && (auth_process == null || auth_process == "true"))) {
            var accountsUrl = "https://accounts.zoho.com/oauth/v2/auth"
            var clientId;
            var scope;
            var redirectUrl;
            if(token != null) {
                clientId = token.clientId;
                scope = token.scope;
                redirectUrl = token.redirectUrl;
            }

            var fullGrant = sessionStorage.getItem("full_grant");
            var grantedForSession = sessionStorage.getItem("granted_for_session");
            if(sessionStorage.getItem("__token_init") != null && ((fullGrant != null && "true" == full_grant) || (grantedForSession != null && "true" == grantedForSession))) {
                accountsUrl += '/refresh';
            }
            if (clientId && scope) {
                sessionStorage.setItem("__token_init", Date.now());
                sessionStorage.removeItem("access_token");
                sessionStorage.setItem("__auth_process", "true");
                window.open(accountsUrl + "?" + "scope" + "=" + scope + "&"+ "client_id" +"=" + clientId + "&response_type=token&state=zohocrmclient&redirect_uri=" + redirectUrl);
                ["granted_for_session", "access_token","expires_in","expires_in_sec","location","api_domain","state","__token_init","__auth_process"].forEach(function (k) {
                    var isKeyExists = localStorage.hasOwnProperty(k);
                    if(isKeyExists){
                        sessionStorage.setItem(k, localStorage[k]);
                    }
                    localStorage.removeItem(k);
                });
                valueInStore = sessionStorage.getItem("access_token");
            }
        }
        if(token != null && valueInStore != 'undefined'){
            token.accessToken = valueInStore;
        }
        return token.accessToken;
    }

    async makeAPICall(requestDetails) {
        return new Promise(function (resolve, reject) {
            var body, xhr, i;
            body = requestDetails.body || null;
            xhr = new XMLHttpRequest();
            xhr.withCredentials = true;
            xhr.open(requestDetails.method, requestDetails.uri, true);
            for (i in requestDetails.headers) {
                xhr.setRequestHeader(i, requestDetails.headers[i]);
            }
            xhr.send(body);
            xhr.onreadystatechange = function() {
                if(xhr.readyState == 4) {
                    resolve(xhr);
                }
            }
        })
    }
}
CopiedrecordIDList = List();
recordIDList.add("692969000000416006");
recordIDList.add("692969000000287129");
recordIDList.add("692969000000287038");


input1 = Map();
input1.put("Lead_Source", "Advertisement");

inputList = List();
inputList.add(input1);

params = Map();
params.put("data", inputList);
params.put("over_write", true);
params.put("ids", recordIDList);

response = invokeurl
[
	url :"https://www.zohoapis.com/crm/v2/Deals/actions/mass_update"
	type :POST
	parameters: params.toString()
	connection:"crm_oauth_connection"
];
info response;

In the request, "@input.json" contains the sample input data.

Request JSON Keys

  • cvidstring, mandatory when custom view fields or territory fields are updated

    The custom view ID whose records you want to mass update

  • over_writeboolean, optional

    Used when updating a multi-select picklist field.
    Possible values - true: replaces all the multi-select picklist values with the value specified for mass update.
    false: adds the specified value to the picklist.Default is false.

  • territoryJSON object, mandatory, when territory fields are updated

    Used to update records in that territory.
    Possible keys - id (string): The territory ID to update the records in that territory.
    include_child (boolean): Boolean field to indicate whether you want to mass update the child territory records as well. Default is false.

  • idsJSON array, mandatory, when records are updated by IDs

    Specify the IDs of the records you want to mass update.

Sample Input

CopiedWith cvid and Territory ID
{
    "data": [
        {
            "Industry": "Education"//field to be updated
        }
    ],
    "cvid": "554023000000091515", //custom view ID to mass update records in that custom view
    "territory": {
        "id": "554023000000430409",//ID of the territory to mass update records in that territory
        "include_child": true //include child territory records for mass updation
    }
}

With Record IDs in the Input 
{
    "data": [
        {
            "Lead_Source": "Advertisement",
            "Type": "Existing Business",
            "Languages_Known": [
                "English",
                "Spanish"
            ]
        }
    ],
    "over_write": true,
    "ids": [
        "554023000000497007",
        "554023000000497021",
        "554023000000497035"
    ]
}

In the sample input with record IDs, "Languages_Known" is a custom multi-select picklist in the Deals module.

Response JSON Keys

  • codestring

    Indicates the status of mass update

  • detailsJSON object

    Specifies the "job_id" (for scheduler type), modified time and the name and ID of the user who modified the record (for non-scheduler type).

  • created_timeDate Time in ISO8601 format

    Specifies the time period when the record was created.

  • idstring

    Specifies the unique ID (record ID) of the record that was updated.

  • Created_ByJSON Object

    Specifies the name and ID of the user that created the record.

  • messagestring

    Specifies if the record is updated or the reason for error, if any.

  • statusstring

    Specifies the status of the record as updated, error etc.

Possible Errors

  • INVALID_DATAHTTP 400

    No field found
    Resolution: No field is specified in the input

  • INVALID_DATAHTTP 400

    Max field limit exceeded
    Resolution: Number of fields to be mass updated has exceeded the allowed limit for that module

  • INVALID_DATAHTTP 400

    This field cannot be updated in the Mass Update
    Resolution: The specified field is not found in the module or it is not allowed for mass update

  • INVALID_DATAHTTP 400

    Field cannot be updated as it is associated with a layout rule
    Resolution: The specified field is used as primary in a layout rule

  • INVALID_DATAHTTP 400

    Field cannot be updated as it is associated with a validation rule
    Resolution: The specified field is used as primary in a validation rule

  • INVALID_DATAHTTP 200

    Field is not visible
    Resolution: The specified field is made invisible/inaccessible to the user

  • INVALID_DATAHTTP 400

    The id given seems to be invalid
    Resolution: The record ID, cvid, or territory ID specified is invalid

  • CANNOT_PROCESSHTTP 400

    The record is in stop processing
    Resolution: The specified record is in the stop processing state

  • RECORD_IN_BLUEPRINTHTTP 400

    The record is in blue print
    Resolution: The specified record is in blueprint and user tries to update a blueprint picklist value

  • MANDATORY_NOT_FOUNDHTTP 400

    required field not found
    Resolution: No cvid or record ID is specified in the input

  • CANNOT_PERFORM_ACTIONHTTP 400

    no permission to perform an action on this record
    Resolution: User does not have permission to perform any action on the record

  • ALREADY_SCHEDULEDHTTP 202

    Already a Mass Action scheduler is running for the given cvid
    Resolution: The records in the custom view specified are already scheduled for mass update

  • LIMIT_EXCEEDEDHTTP 400

    Record count exceeded
    Resolution: Number of records that can be mass updated has exceeded the maximum allowed limit of 50000

  • NOT_APPROVEDHTTP 400

    record not approved
    Resolution: The record with the specified ID is not approved

  • NO_RECORDS_FOUNDHTTP 400

    no record found to update
    Resolution: There are no records in the custom view specified

  • NO_PERMISSIONHTTP 403

    permission denied
    Resolution: User does not have permission to mass update records

  • NO_PERMISSIONHTTP 403

    Field Edit Permission not given
    Resolution: User does not have permission to edit the field

  • NO_PERMISSIONHTTP 403

    Customview not accessible
    Resolution: Custom view is not accessible to the user or the module

  • INVALID_MODULEHTTP 400

    the module name given seems to be invalid
    Resolution: The module name specified is incorrect. Refer to supported modules section above and specify a valid module API name.

  • INVALID_URL_PATTERNHTTP 404

    Please check if the URL trying to access is a correct one
    Resolution: The request URL specified is incorrect. Specify a valid request URL. Refer to request URL section above.

  • OAUTH_SCOPE_MISMATCHHTTP 401

    Unauthorized
    Resolution: Client does not have ZohoCRM.mass_update.{module_name}.UPDATE scope. Create a new client with valid scope. Refer to scope section above.

  • INTERNAL_ERRORHTTP 500

    Internal Server Error
    Resolution: Unexpected and unhandled exception in Server. Contact support team.

  • INVALID_REQUEST_METHODHTTP 400

    The http request method type is not a valid one
    Resolution: You have specified an invalid HTTP method to access the API URL. Specify a valid request method. Refer to endpoints section above.

  • AUTHORIZATION_FAILEDHTTP 400

    User does not have sufficient privilege to schedule mass update.
    Resolution: The user does not have the permission to schedule mass update. Contact your system administrator.

  • RECORD_LOCKEDHTTP 400

    Cannot update record that is not approved yet
    Resolution: Please wait until the Zia image or the merge duplicates process is complete and try again.

  • NOT_APPROVEDHTTP 400

    Cannot update record that is not approved yet
    Resolution:

    • Case 1: If the record is in the rejected state due to Zia image validation, either upload a new image (or) delete the failed image and, resubmit the record to Zia image validation.
    • Case 2: If the record is in Zia record approval, the system will not allow you to update the images of the record until the reviewer approves or rejects the record.

Note

  • It is mandatory to specify either custom view ID or record IDs in the input.
  • It is mandatory to specify the custom view ID when you want to mass update records in a territory.
  • You cannot mass update Email, lookup fields, layout fields, multi line fields, and line items.
  • You can mass update up to three fields in the Deals module and only one field in all other modules in a single API call.
  • You can mass update a maximum of 500 records in a single API call when you use the non-scheduler type mass update (i.e with record IDs).
  • You can mass update a maximum of 50,000 (fifty thousand) records in a single API call when you use the scheduler type mass update (i.e by specifying the cvid and territory ID).
  • While mass updating records based on their IDs, if some of the records have invalid data, only those records will not be processed.
  • Use Territories API to get the territory ID.
  • For the non-scheduler type mass update, automation rules such as approvals, blueprints, and workflows are triggered automatically.
  • For the scheduler type mass update, automation rules are triggered automatically when the record count is less than 1000. When the record count is greater than 1000, automation rules do not get triggered.

Sample Response

Copied{
    "data": [
        {
            "code": "SUCCESS",
            "details": {
                "job_id": "554023000000506003"
            },
            "message": "mass update scheduled successfully",
            "status": "success"
        }
    ]
}