Bulk Write API using PHP SDK v5 Part II

Welcome to another exciting week of Kaizen! This week, we will continue our discussion on Bulk Write API. In last week's post, we covered the features of Bulk Write API, and explained in detail the first two steps involved in using Bulk Write API. Today, we'll discuss how to create a bulk write job, fetch the job status, and download the results.

1. Prepare the CSV file

2. Upload your zip file

3. Create a Bulk Write job

After uploading the file and obtaining the file ID, the next step is to create a bulk write job. For this, you will require the file ID, callback URL, and the field API names to perform one of the three operations: insert, update, or upsert. Upon a successful API call, the response will provide a job ID, with which you can check the job status in the next step.

The following are the keys you need to set.

callback (JSON object, optional) : The CallBack object defines the callback URL and method for receiving notifications or updates about the job's status.
character_encoding (string, optional) : Specify the encoding to be used for the data being written.
operation (string, mandatory) : Specify the type of operation to be performed in the bulk write job. Possible values are insert, update and upsert.
ignore_empty (Boolean, optional) : If you have a few empty fields while updating the record and you want the system to ignore it, input the value as TRUE.
resource (JSON array, optional): Initiate an object of Resource class that contains the details of the module, file, and field mappings associated with the bulk write job. The resource array contains the file_id, module, find_by, field_mappings and type keys. For more details, refer to our help document here.

Mapping fields in bulk write jobs

To specify which value in the CSV file should be mapped to which field in the CRM module, you can use the field_mappings key in the resource array. This is an optional key, and if you omit it, the system will use the headers of the CSV file to map the fields. When the field_mappings is skipped, the CSV headers must be the field API names and, all the columns of your CSV file will be used for import. In this case, you should remove columns that you do not want to import into your CRM account.

Please note that the CSV headers will be ignored if field_mappings is used while creating the bulk write job.

When to use the field_mappings key?

You should use the field_mappings key if:

The column headers in your CSV file are different from the field API names in the CRM module.
You want to ignore certain columns in the CSV file.
You want to specify a default value for a field in the CRM module.

Rules for using the field_mappings key

When you map a field by specifying the field_mappings key, it is mandatory to specify either the index or the default_value key, or the system will throw an error.
The index is the position of the field in the CSV file, starting from 0.
The default_value key is used when you want to provide a default value for a field. By specifying a default value, you ensure that if a cell in the CSV file is empty, the system will populate it with the default value.
Use the ignore_empty key when you want the system to skip updating fields that are empty in the source file. Please note that for insert operation, ignore_empty will be set as false by default.

Index	Default Value	Ignore Empty	Empty Cell	Action
YES	YES/NO	TRUE/FALSE	NO	CSV Value
YES	YES	TRUE/FALSE	YES	Default Value
YES	NO	TRUE	YES	No Update
YES	NO	FALSE	YES	Empty
NO	YES	TRUE/FALSE	YES/NO	Default Value

If you specify the index and there are no empty cells in the source file, the system will use the values from the CSV file for the corresponding fields. The default_value will be ignored in this case.
For update and insert operations, when the index is specified and there are a few cells for which the value is empty in the source file, then for the corresponding records with empty value:

If default_value is specified, the field will be updated with the default_value.
If default_value is not specified, the system will handle the corresponding fields differently depending on the value of the ignore_empty key.

The field will be left untouched if ignore_empty is set to TRUE.
The field will be updated to an empty value if ignore_empty is FALSE.

When the index is not specified, but a default_value is given, the system will update the corresponding fields in the CRM module with the specified default value.

Bulk Insert with lookup and user lookup data

Here is an example of a simple bulk write job request:

<?php

namespace bulkwrite;

use com\zoho\crm\api\bulkwrite\BulkWriteOperations;

use com\zoho\crm\api\bulkwrite\RequestWrapper;

use com\zoho\crm\api\bulkwrite\CallBack;

use com\zoho\crm\api\util\Choice;

use com\zoho\crm\api\bulkwrite\Resource;

use com\zoho\crm\api\bulkwrite\FieldMapping;

use com\zoho\crm\api\modules\MinifiedModule;

use com\zoho\crm\api\bulkwrite\DefaultValue;

require_once "vendor/autoload.php";

class CreateBulkWriteJob

{

public static function initialize()

{

// Add init code here.

// Refer to this post for more details

}

public static function createBulkWriteJob(string $moduleAPIName, string $fileId)

{

$bulkWriteOperations = new BulkWriteOperations();

$requestWrapper = new RequestWrapper();

// Set the callback URL, and method

$callback = new CallBack();

$callback->setUrl("add_your_callback_url_here");

$callback->setMethod(new Choice("post"));

$requestWrapper->setCallback($callback);

$requestWrapper->setCharacterEncoding("UTF-8"); //character encoding

$requestWrapper->setOperation(new Choice("insert")); //specify the type of operation

// module, file and field mapping details

$resourceIns = new Resource();

// To set the type of module that you want to import. The value is data.

$resourceIns->setType(new Choice("data"));

$module = new MinifiedModule();

$module->setAPIName($moduleAPIName);

$resourceIns->setModule($module);

$resourceIns->setFileId($fileId);

$resourceIns->setIgnoreEmpty(true);

$fieldMapping1 = new FieldMapping();

$fieldMapping1->setAPIName("Account_Name");

$fieldMapping1->setIndex(0);

$fieldMapping2 = new FieldMapping();

$fieldMapping2->setAPIName("Phone");

$fieldMapping2->setIndex(1);

$fieldMapping3 = new FieldMapping();

$fieldMapping3->setAPIName("Parent_Account");

$fieldMapping3->setIndex(2);

$fieldMapping3->setFindBy("id");

$fieldMapping4 = new FieldMapping();

$fieldMapping4->setAPIName("Referred_User");

$fieldMapping4->setIndex(3);

$fieldMapping4->setFindBy("id");

$defaultValue = new DefaultValue();

$defaultValue->setValue("4876876327565");

$fieldMapping4->setDefaultValue($defaultValue);

$resourceIns->setFieldMappings([$fieldMapping1, $fieldMapping2, $fieldMapping3, $fieldMapping4]);

$requestWrapper->setResource([$resourceIns]);

//Call createBulkWriteJob method that takes RequestWrapper instance as parameter

$response = $bulkWriteOperations->createBulkWriteJob($requestWrapper);

// Add your code to handle the response received in the $response.

}

CreateBulkWriteJob::initialize();

$moduleAPIName = "Accounts"; //The module to which you want to insert the records

$fileId = "48768764054001"; // add your file_id received in the response of Upload File

CreateBulkWriteJob::createBulkWriteJob($moduleAPIName, $fileId);

In the above code, Referred_User is a user lookup field, and Parent_Account is a lookup field in the Accounts module. The CSV file contains the unique ID of the corresponding records in the lookup modules.

Here is a sample CSV file used for the above Bulk Insert job. Note that the unique record IDs of the lookup (Parent_Account) and user lookup(Referred_User ) fields. If you choose to schedule the job without using field mappings, ensure that you provide headers for these fields in the format field_api_name.id with the record IDs in the corresponding columns.

Updating or Upserting records by unique key:

During an update operation, the find_by field acts as a unique key that identifies the record to be updated. You can use the unique record id, or any other unique field for this. For example, if the Phone field is a unique field in the Accounts module, specifying setFindBy("Phone") allows updates based on the values present in the Phone field. Similarly, for an upsert operation, if there is no existing record matching the provided Phone number, a new record will be inserted. Conversely, if a matching record is found, it will be updated.

Here is the code snippet for the field_mapping for an update operation using the Phone field as the unique key.

//You can use setFindBy method to update/upsert records based on a unique field

$resourceIns->setFindBy("Phone");

//fieldMapping for the unique field

$fieldMapping1 = new FieldMapping();

$fieldMapping1->setAPIName("Phone");

$fieldMapping1->setIndex(1);

$fieldMapping2 = new FieldMapping();

$fieldMapping2->setAPIName("Description");

$fieldMapping2->setIndex(8);

Importing Subform Data

The Bulk Write API allows you to import and update records with subforms. To insert or update records with subforms, you must import the parent records first with Bulk Write API. For this bulk write job, $moduleAPIName has to be set with parent module with proper $fieldMapping. Refer to the first sample for more details.

Once you have imported the parent records, get the parent record ids, prepare the CSV file with the subform data, and create a Bulk Write job for the subform module. You can get the parent record ids from the result zip file in Step 5 (Download the result). Refer to our previous post to know how to prepare the CSV file with the Subform data.

Consider a subform named Contact_details in the Accounts module, with the fields Contact_Name, Contact_Email, and Contact_Phone. Here is the code snippet for the field_mapping to import the subform data.

//field_mapping for the Parent_Id

$fieldMapping1 = new FieldMapping();

$fieldMapping1->setAPIName("Parent_Id");

$fieldMapping1->setIndex(0);

$fieldMapping1->setFindBy("id");

//add proper field_mapping for the subform fields with the subform field API names

Note that in this case, the $moduleAPIName is the api name of the subform (Contact_details) and the operation type should be insert. The subform data is added to the corresponding record specified by Parent_Id field in the subform CSV.

Multiselect Lookup Fields in Bulk Write API

To upload records with multiselect lookup fields, you can follow the same steps as for subforms. First, import the parent records using a Bulk Write job. Then, import the multiselect lookup field data using another Bulk Write job. For the multiselect lookup field data, the CSV file should contain both the parent record ID and the multiselect lookup field data. Please note that this method does not work for line items.

Consider a multiselect lookup field named Clients in the Accounts module, which is linked to the Contacts module. In your CSV file, ensure that you include both the Parent Record ID and the linked record IDs. For multiselect lookup data, the $moduleAPIName should be the API name of the linked module, and in the field_mappings, the API names used should correspond to the field API names from the lookup module. Check the following sample code for more details.

//field_mapping for module 1 (Contacts)

$fieldMapping1 = new FieldMapping();

$fieldMapping1->setAPIName("Client_Account"); //field API name in the linked module

$fieldMapping1->setIndex(0);

$fieldMapping1->setFindBy("id");

// field_mapping for module 2 (Accounts)

$fieldMapping2 = new FieldMapping();

$fieldMapping2->setAPIName("Account"); // field API name in the linked module

$fieldMapping2->setIndex(1);

$fieldMapping2->setFindBy("id");

4. Check job status

The Bulk Write API offers two options for monitoring the status of a job: polling and callback. If you prefer not to poll for job status, you can wait for the system to notify you of job completion by using the provided callback URL in the Create Bulk Write Job request. Alternatively, you can choose to poll the API using the job ID obtained from the previous step to check the status of the scheduled bulk write job. The job status can be one of the following: ADDED, INPROGRESS, or COMPLETED. Only completed jobs will include the download-URL key in the response.

Here is a code snippet to check the job status and get the download URL from the response.

public static function getBulkWriteJobDetails(string $jobId)

{

$bulkWriteOperations = new BulkWriteOperations();

//Call getBulkWriteJobDetails method that takes jobId as parameter

$response = $bulkWriteOperations->getBulkWriteJobDetails($jobId);

if ($response != null) {

$responseWrapper = $response->getObject();

if ($responseWrapper instanceof BulkWriteResponse) {

$result = $responseWrapper->getResult();

if ($result != null)

echo ("Bulkwrite DownloadUrl: " . $result->getDownloadUrl() . "\n");

}

5. Download the result

In this step, you can obtain the result of the bulk write job in a ZIP file that includes a CSV file containing the details of the job. Please note that you can get the details of only one bulk write job in a single API call.

To download the result, you need to use the download_url provided in the response. The CSV file will consist of the first three mapped columns from the uploaded file, as well as three additional columns: STATUS, RECORD_ID, and ERRORS.

{

public static function initialize()

{

// Add init code here.

// Refer to this post for more details

}

public static function downloadBulkWriteResult(string $downloadUrl, string $destinationFolder)

{

$bulkWriteOperations = new BulkWriteOperations();

$response = $bulkWriteOperations->downloadBulkWriteResult($downloadUrl);

// Add your code to handle the response received in the $response.

}

DownloadBulkWriteResult::initialize();

$downloadUrl = "paste_your_download_url_here";

$destinationFolder = "/Documents";

DownloadBulkWriteResult::downloadBulkWriteResult( $downloadUrl,$destinationFolder);

The image shows the result of an Upsert operation. As you can see, few of the records were skipped because the unique field had a duplicate value.

We hope you found this post useful. If you have any further questions, reach out to us at support@zohocrm.com or let us know in the comments section. We are looking forward to hearing from you!

Stay tuned for more useful posts in the series. See you all next week!

Access your files securely from anywhere

New to Zoho Recruit?

Access Zoho Recruit

New to Zoho Forms?

Latest Feature Updates

Explore our Pricing & Plans

Zoho Campaigns Resources

Campaigns Community Learning Series

Zoho Developer Community

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day
Ask the Experts

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
Anu Abraham

Sticky Posts
Client Script | Update - Introducing Commands in Client Script!
Have you ever wished you could trigger Client Script from contexts other than just the supported pages and events? Have you ever wanted to leverage the advantage of Client Script at your finger tip? Discover the power of Client Script - Commands! Commands
Kaizen #165 : How to call Zoho CRM APIs using Client Script
Welcome back to another exciting Client Script post! In this post, we will discuss one of the most frequently asked questions: How do you call Zoho CRM APIs from Client Scripts? In this kaizen post, 1. Ways to make calls to Zoho CRM APIs using Client
Kaizen#162 : Add Tags and Open Pre-filled Email Drafts via Client Scripts
Hello everyone! Welcome to another informative Kaizen post. In this post, let us see how to accomplish the following using Client Script. 1. How to auto-tag a record based on field update? 2. How to Open a pre-filled email draft This post will provide
Extension Pointers - JS SDK series #4: Managing data from a widget using ZOHO.CRM.HTTP
Handling and managing the data between two applications is a major factor for an efficient business. There are a variety of ways to handle data between Zoho CRM and other third-party applications. You can use deluge CRM tasks, create connectors, use API
Kaizen #152 - Client Script Support for the new Canvas Record Forms
Hello everyone! Have you ever wanted to trigger actions on click of a canvas button, icon, or text mandatory forms in Create/Edit and Clone Pages? Have you ever wanted to control how elements behave on the new Canvas Record Forms? This can be achieved

New to Zoho Social?

Manage your brands on social media

Access Zoho Social

Zoho Pagesense Resources

New to Zoho TeamInbox?

Zoho TeamInbox Resources

Zoho DataPrep Resources

New to Zoho DataPrep?

Access Zoho DataPrep

Zoho CRM Plus Resources

Zoho Books Resources

Zoho Subscriptions Resources

Zoho Projects Resources

Zoho Sprints Resources

Qntrl Resources

Zoho Creator Resources

Zoho CRM Resources

CRM Community Learning Series
Kaizen
Functions
Meetups
Kbase
Resources
Digest
CRM Marketplace
MVP Corner

Design. Discuss. Deliver.

Create visually engaging stories with Zoho Show.

Get Started Now

Zoho Show Resources

Writer

Get Started. Write Away!

Writer is a powerful online word processor, designed for collaborative work.

Start Writing

Zoho CRM コンテンツ

その他のサービスコンテンツ

Zoho Campaigns
Zoho サービスのWebセミナー

Nederlandse Hulpbronnen

ご検討中の方

Recent Topics
Syncing with Google calendar, Tasks and Events
Is it possible to sync Zoho CRM calendar, task and events with Google Calendar's tasks and events. With the increasing adoption by many major tool suppliers to sync seamlessly with Google's offerings (for instance I use the excellent Any.do task planning
Filtert products by multi select custom field
Hello, this is seems like a must addition, why it can not be done now?
CRM quotes and sub forms.
Recently upgraded to Enterprise CRM - now some added hopes/questions * In a subform in quotes, if I add a "Percent" field, called Overage for instance. I would expect it to allow me to enter a percent like "10%" and carry the percent forward to formulas
Is there a notification API when a new note is addeding
Trying to push to Cliq, or email notification when there's a new note added in module. How to implement this?
Problem with WorkDrive and Vivo X200 Pro
Hey there, after a long odyssey of searching for a new phone, several issues and defects with a phone from another brand and many reinstallations and transfers I stuck to the Vivo X200 Pro. So far, so great. Only thing not working is the Zoho WorkDrive,
Cambiar nombre de usuario
Hola. Tengo una cuenta en zoho, por ejemplo Minombre @ midominio.es Y quiero cambiarlo a Miotronombre @ midominio.es Se puede cambiar??? Con la cuenta gratuita de zoho, cuantos nombres puedo tener en un dominio??? Gracias y buen dia
Can't add company logo and favicon as a superadmin
I am logged in as the superadmin but can't add company logo and favicon - the fields are greyed out. Any idea as to what the problem could be?
Inquiry regarding B2B website through Zoho Commerce
We are looking to build an online B2B customer portal for Consumer Goods primarily for order placement, with an e-commerce-style layout. Additionally, we would like to offer our customers features such as: 1.Viewing past orders and order updates 2.Accessing
ASAP Chrome Extension not loading
We have ASAP enabled in Zoho Desk. I installed the ASAP Chrome Extension (Windows 10), but when I click the extension button while on our site, it never fully loads. I just get what's shown below.
Why is the Zoho portal not mobile friendly?
I just got started with the portal and im sort of shocked how it looks. I already filled a hint/complaint about this. On the website you see a wonderful site with a modern design. Yet in real life its a mid 2000 look and feel. One major issue i see thats
New Asap Widget How to update my code
I know you're still working on updating the documentation for calling the Asap Widget, the existing documentation is no longer valid. In the old 1.0 version I was able to do many things programmatically in javascript. I could open an article directly
Condition in templates
Is it possible for me to add merge field conditionally in my templates. For example Dear ${Leads.Gender == "Male" ? "Sir" : "Ma"},
How to Dynamicaly display image in the Detailed View Report ?
I have an "Add Employee" form that includes an image field for uploading an employee's profile picture from their local computer. In the "Apply Leave" form, I also have an image field where I want the employee's profile picture to be auto-populated based
Zoho Flow Custom Function to Register Sale in Zoho Thrive
Hi Thrive team, I want to create a custom function which sends purchase information back into Thrive for Affiliate commission. I'm stuck on how to setup the connection, specifically creating an OAuth connection through https://api-console.zoho.eu/ Please
Sending User-centric reports to all users
I would like to automate an e-mail report to all users that sends them a weekly e-mail listing their open Potentials. I've created a Report that uses the ${CURRENTUSER} criterion and scheduled the report to send to several users, but they all receive
How do I add new line and format text in zoho desk ticket?
I am generating a ticket via API and looking to update "description" field of ticket whenever I need. Is there a document where I can find supported formatting for description field on a ticket. I need to find: Adding a new line and adding bold text,
Automation #6 - Prevent Re-opening of Closed Tickets
This is a monthly series where we pick some common use cases that have been either discussed or most asked about in our community and explain how they can be achieved using one of the automation capabilities in Zoho Desk. Typically when a customer submits
Feature Request - Insert URL Links in Folders
I would love to see the ability to create simple URL links with titles in WorkDrive. or perhaps a WorkDrive extension to allow it. Example use case: A team is working on a project and there is project folder in WordDrive. The team uses LucidChart to create a drawing/s for the project. The team member could create a link to the LucidChart drawing/s and allow WordDrive to truly be a repository for ALL the project documents, even those outside of WorkDrive. A folder is dedicated to a CRM account. A
ZOHO DESK ヘルプセンターの言語選択メニューの表示方法
ZOHO DESK のヘルプセンターを構築し、多言語化設定をしました。顧客のヘルプセンター画面右上に言語選択メニューが表示されないため、弊社の契約先会社に問い合わせましたが、「通常は多言語化をオンにすると表示するためCSS を触り過ぎではないか」という指摘のみでした。試行中ですが表示できません。何か要因となる情報をお持ちの方がいましたらご教授いただけますと幸いです。 ↓の赤枠を表示したいのですが、表示できません。
How to reply to thread via API
We have built a webapp for our customers that uses the Zoho Desk API to enable each customer to view their full list of tickets, view individual tickets and raise new tickets. The Zoho Desk API doesn't have the ability to reply to a ticket/thread. Replies
Email Builder Editor is not functioning or loading correctly
Email editor function is not working or loading correctly in any template, new or old. Cleared my cache, restarted browser, problem unchanged.
Create Tasklist with Tasklist Template using API v3
In the old API, we could mention the parameter 'task_template_id' when creating a tasklist via API to apply a tasklist template: https://www.zoho.com/projects/help/rest-api/tasklists-api.html#create-tasklist In API v3 there does not seem to be a way to
Issue in downloading the sent logs
Hi Team, I'm unable to export the sent file for any email campaign. When selecting all fields, the system indicates that the document will be sent via email, but I haven't received it. At times, it shows a download option, but the file doesn’t get downloaded.
Integrate Google Chat with Zoho CRM for seamless collaboration
Hello everyone, Sales is a team sport and sales reps have to be in constant communication with people inside and outside their organization. While email remains the most effective channel for important conversations, sales reps often collaborate via chat.
customers enter orders?
Anyway we can let a customer into CRM and enter their own orders , no access to anything else except history reports, no access to any other contacts. Greg Aanes 2109 Queen Street Bellingha WA USA
Zoho Learn - URL Parameters for Externally Shared Articles?
Hey Folks, Are there any parameters one can append to URLs for externally-shared articles? Specifically, can I add a parameter that hides the Manual name (use case being I want to embed the article in another webpage)? Also, can one password-protect an
Why Sharing Rules do Not support relative date comparison???
I am creating a Sharing Rule and simply want to share where "Last Day of Coverage" (Date field) is Greater than TODAY (Starting Tomorrow). However, sharing rules don't have the option to compare a date field to a relative date (like today), only to Static
Post message to a channel using a simple one-line command!
Hi Everybody! This post is all about posting a message in a Channel using cURL, Wget and PowerShell. cURL is a light-weight, command interface used to transfer data to a server. The steps are pretty easy! The three most important points here are Generating an Auth token Get your Channel Unique Name Form your message as a JSON structure Generating an Auth token To use the 'Messaging API' you'll need Cliq's authentication token from Zoho Accounts. Generate an auth token by hitting the below-given
Activity or History Log User Login
Hi Everyone, I have Zoho Customer Portal, which has pages and reports. Is it possible to create 1 field such as true/false to find out users who have opened the customer portal? Like a kind of user activity log. Thank you so much.
How to associate a document sent in Zoho Sign with an deal in the CRM?
Hi, often documents are loaded in Zoho sign and sent for signature. These sometimes are linked to a deal in the Zoho CRM and would be nice to see the status of the document within the CRM. I am aware of the integration, but that assumes that the document
Invalid Emails in CRM
Is there a way to get a report or create a view that shows all email addresses that are invalid for any reason? I keep coming across them and want to ensure that they are flagged with users to update. This is on a custom module.
Add Custom Reports To Dashboard or Home Tab
Hi there, I think it would be great to be able to add our custom reports to the Home Tab or Dashboards. Thanks! Chad
Associating an Email from CRM Email Parser to Contact Record via Function
Is it possible to create a custom function that will associate email records from zCRM's Email Parser functionality to a contact record where specific fields match? Our use-case is that we have service providers using third-party event booking systems
Update Client Record based on creation of custom module record
Hi! Hoping for someone's help with this one. I have a custom module called 'Agreement History. Whenever a deal is won, it creates a new record in this module with associated 'Products' and 'Clients' to track rental history and contracts. What I'm trying
Inputting VAT Pre-Registration expenses for first VAT Return
Hi Zoho, I've just registered for VAT and am setting up Zoho to handle calculations and VAT return submissions. I'm struggling to figure out how to input the last 4 years worth of expenses into Zoho so that they're calculated in the VAT module. When I
How to Bring to front the picture?
I have 2 pictures that have to layers but i can't find bring to front button, Thank
setting owner of note when adding via deluge
My organization has requested the ability to mass update the notes related list in the deals module. Since this can't be done with the mass update feature, I created an update "notes single" line field and created a workflow rule that triggers a function
Creating email schedules with custom filters for Pivot/Summary Reports in Zoho Analytics
Hi Zoho, I have a Weekly Inventory Report that I'd like to send out to various vendors. Is it possible to create an email schedule for each vendor with customized filtering at the scheduling level? Currently, we generate two pre-filtered reports (copies
Can Client generate Sales Order by himself?
My business primarily operates in the B2B sector, and I've observed that my sales team and I spend an excessive amount of time obtaining sales orders from our customers. This is particularly relevant in a product-based business with multiple SKUs. I am
Python - code studio
Hi, I see the code studio is "coming soon". We have some files that will require some more complex transformation, is this feature far off? It appears to have been released in Zoho Analytics already
Next Page

Bulk Write API using PHP SDK v5 Part II

Bulk Write API using PHP SDK v5 Part II

1. Prepare the CSV file

2. Upload your zip file

3. Create a Bulk Write job

Mapping fields in bulk write jobs

When to use the field_mappings key?

Rules for using the field_mappings key

Bulk Insert with lookup and user lookup data

Updating or Upserting records by unique key:

Importing Subform Data

Multiselect Lookup Fields in Bulk Write API

4. Check job status

5. Download the result

Access your files securely from anywhere

Zoho Developer Community

France ZUGs

Topic Participants

Anu Abraham

Sticky Posts

Client Script | Update - Introducing Commands in Client Script!

Kaizen #165 : How to call Zoho CRM APIs using Client Script

Kaizen#162 : Add Tags and Open Pre-filled Email Drafts via Client Scripts

Extension Pointers - JS SDK series #4: Managing data from a widget using ZOHO.CRM.HTTP

Kaizen #152 - Client Script Support for the new Canvas Record Forms

Zoho TeamInbox Resources

Zoho CRM Plus Resources

Zoho Books Resources

Zoho Subscriptions Resources

Zoho Projects Resources

Zoho Sprints Resources

Qntrl Resources

Zoho Creator Resources

Zoho CRM Resources

Zoho Show Resources

Get Started. Write Away!

その他のサービス コンテンツ

Nederlandse Hulpbronnen

ご検討中の方

Recent Topics

Syncing with Google calendar, Tasks and Events

Filtert products by multi select custom field

CRM quotes and sub forms.

Is there a notification API when a new note is addeding

Problem with WorkDrive and Vivo X200 Pro

Cambiar nombre de usuario

Can't add company logo and favicon as a superadmin

Inquiry regarding B2B website through Zoho Commerce

ASAP Chrome Extension not loading

Why is the Zoho portal not mobile friendly?

New Asap Widget How to update my code

Condition in templates

How to Dynamicaly display image in the Detailed View Report ?

Zoho Flow Custom Function to Register Sale in Zoho Thrive

Sending User-centric reports to all users

How do I add new line and format text in zoho desk ticket?

Automation #6 - Prevent Re-opening of Closed Tickets

Feature Request - Insert URL Links in Folders

ZOHO DESK ヘルプセンターの言語選択メニューの表示方法

How to reply to thread via API

Email Builder Editor is not functioning or loading correctly

Create Tasklist with Tasklist Template using API v3

Issue in downloading the sent logs

Integrate Google Chat with Zoho CRM for seamless collaboration

customers enter orders?

Zoho Learn - URL Parameters for Externally Shared Articles?

Why Sharing Rules do Not support relative date comparison???

Post message to a channel using a simple one-line command!

Activity or History Log User Login

How to associate a document sent in Zoho Sign with an deal in the CRM?

Invalid Emails in CRM

Add Custom Reports To Dashboard or Home Tab

Associating an Email from CRM Email Parser to Contact Record via Function

Update Client Record based on creation of custom module record

Inputting VAT Pre-Registration expenses for first VAT Return

How to Bring to front the picture?

setting owner of note when adding via deluge

Creating email schedules with custom filters for Pivot/Summary Reports in Zoho Analytics

Can Client generate Sales Order by himself?

Python - code studio

その他のサービスコンテンツ