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

Quick Links

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

New to Zoho Desk?

Access Zoho Desk

What's New in Zoho Desk

Use cases

Make the most of Zoho Desk with the use cases.

Learn More

eBooks

Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

Download eBooks

Videos

Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

Watch Now

Webinar

What's New in Zoho Desk

Desk Community Learning Series
Meetups
Ask the Experts
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
Anu Abraham

Sticky Posts
Kaizen #197: Frequently Asked Questions on GraphQL APIs
🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
Kaizen #198: Using Client Script for Custom Validation in Blueprint
Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
Celebrating 200 posts of Kaizen! Share your ideas for the milestone post
Hello Developers, We launched the Kaizen series in 2019 to share helpful content to support your Zoho CRM development journey. Staying true to its spirit—Kaizen Series: Continuous Improvement for Developer Experience—we've shared everything from FAQs
Kaizen #193: Creating different fields in Zoho CRM through API
🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
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

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
Emoji Support in Bigin CRM
We request the implementation of emoji support across Bigin CRM. This feature should allow users to seamlessly use emojis in text fields, headlines, and deals. It would enhance communication, improve the visual appeal of records, and bring more personalization
How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.
How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.
How do you add or update tags on Zoho CRM records via n8n? (Workarounds or best practices?)
Hi all, I’m running into some limitations with the Zoho CRM node in n8n and was wondering how others have handled this: From what I see, the standard Zoho CRM node in n8n doesn’t allow you to add or update tags when creating or updating contacts/leads.
Set Custom Icon for Custom Modules in new Zoho CRM UI
Why is Zoho Meeting quality so poor?
I've just moved from Office 365 to Zoho Workplace and have been generally really positive about the new platform -- nicely integrated, nice GUI, good and easy-to-understand control and customisation, and at a reasonable price. However, what is going on
Bigin Booking Pages enhancements
I would like to ask for several enhancements for the brand new (and promising) Booking feature. 1. Add "Contact/Mobile" Field to Booking form We use Mobile as key (id), but unfortunately it is missing from the Booking form, only Home Phone is available.
Enhancements to Client script?
Hi Zoho CRM, I've been extensively using Client Scripts to enhance our Deal form experience, particularly for real time validations and auto updating fields based on specific logic. However, I've encountered a challenge regarding permission boundaries.
Amount in words in Indian format
Hi, I had coded the following code to convert amount in words. But in the code in the format of US like million. But i need in Lakh and Crore. So pls suggest ideas r post corrected code string Num2Words(int val) { val_s = input.val.toString(); th = {"", "thousand", "million", "billion", "trillion"}; // uncomment this line for English Number System // th = {"","thousand","million", "milliard","billion"}; dg = {"zero", "one", "two", "three", "four", "five", "six", "seven", "eight",
What are people using to send Service based emails?
Zoho Campaigns is for marketing. Users can unsubscribe from these emails. Service based emails need to be delivered and can without the worry of Can-spam act. What are people using to send service based emails? My mailing list is derived from a database
Standalone LMS tool
Will Zoho release a standalone LMS (Learning management System) than can be used by external parties (guest)?
Announcing Kiosk 1.1 - Customize screen titles, configure new fields & actions, use values from your Kiosk to update fields, and more.
Hello all We are back again with more enhancements to Kiosk. So what's new? Enhancements made to the Components Add titles for your Kiosk screens and adjust its width to suit your viewing preferences. Three new fields can be added to your screen: Percentage,
Empowered Custom Views: Cross-Module Criteria Now Supported in Zoho CRM
Hello everyone, We’re excited to introduce cross-module criteria support in custom views! Custom views provide personalized perspectives on your data and that you can save for future use. You can share these views with all users or specific individuals
New Customization options in the module builder: Quick Create and Detail view
Hello everyone, We have introduced two new components to the module builder: Quick create and Detail view. The Quick Create Component It is a mini form used to create a record and associate it to the parent record from a lookup field. For example, if you have a Deals lookup in the Contacts module, then you can associate existing deals or create a deal and associate it with the contact. You can customize this Quick Create form by adding standard as well as custom fields. There is no limit to the number
An Overview of Dario Schiraldi Deutsche Bank Executive
Hello Community, Dario Schiraldi is an executive at Deutsche Bank, focused on advancing the firm’s financial services and crafting its global strategic vision. With 20 years of expertise in leadership roles, he has spearheaded successful market acquisitions
Sending gmail to a particular person fails because the address gets changed to "gmaill", with a second "l" typo somewhere
I send to bob@gmail.com (example) and get an error sending to bob@gmaill.com, only for this one person. Note the extra "l" in the email the system tried to send to, which was not in the address I entered. Can't find a typo in the contact or anywhere else
Emailing a document to WorkDrive
Does WorkDrive include the ability to upload a document by sending an attachment to an email address? (Books and Expenses include this functionality) If it doesn't is it under consideration? on the Road Map?
Issue showing too many consultations in my workspace link.
Hi Team, I’ve set up two Workspaces to track meetings from different sources. So far, this has been working well, and the two Workspaces are differentiated without any issues. However, when I navigate to Consultations and share the link to my personal
Url filter Report date (pivot chart)
Hello. Is it possible to filter the data in pivot char using parameters in the url? I'm trying but I should not doing very well. Something like: https://creator.zoho.com/.../....../#Report:MyPivotChartReport?MyDate=01-Jan-2012;31-Jun-2012;MyDate_op=58 Saludos
Allow Changing Appointment Status from "Completed" to "No Show" or Other Valid States
Hi Zoho Bookings Team, We hope you're doing well. We would like to submit a feature request regarding appointment status management in Zoho Bookings. 🎯 Use Case Sometimes, an appointment is mistakenly marked as Completed, but later we realize that the
Ability to modify what displays in calendar invite?
I am a long time calendly user and want to make the switch to bookings. I understand that there is not currently a meets/hangouts integration, is one on the roadmap? Is there anyway I can modify the calendar invite to include the meet link? I can add it to the emails no problem, but I would also like it to display on their calendar. Is there some work around I can do to get it on the calendar? Also am I able to modify the calendar event title?
Zoho One and Tally Integration
Has Anyone in this forum done any implementation with Zoho CRM and Tally accounting software. If so who have you used and how easy was it?
Microsoft PowerPoint files Extremely slow to save
I and others on my team have noticed that Microsoft PowerPoint documents are extremely slow to save when using WorkDrive. It always takes over 30 seconds to save a file. Word and Excel files seem to save in a typical length of time, but PowerPoint is
How can users unblock their blocked Zoho Mail accounts?
After the reason for the account block (storage exceeded, spam detection etc.) has been rectified, the user can unblock the account from the UnBlock Me page. Account support@edu2review.com Edu2Review is an education review platform, we rate the quality
Adding additional fields for batch information
Hello, I am looking at adding additional information into our inventory module. we would like to be able to see up to 8 attributes that will be individual & different for each batch (i.e. batch specific information) but currently I seem to only be able
API PARAMETER FOR TICKET CLOSED TIME
Hi, Is there a parameter for filtering tickets by closed time in zoho api, i can see closed time in the API response i get, but can't get tickets by that field while calling. Regards, Anvin Alias
Dynamic Pickup List Values using Deluge and Client Script
I would like to dynamically show Pickup List Values For example we need to fetch some data from an on premise application and display it so they can choose and pick This can be done in Creator but I didn't find anything for CRM
Pick List Issues
I have created a pick list that looks at a table in a sheet, it selects the column I want fine. Various issues have come along. The option to sort the pick list is simplistic, only allows an ascending alphabetical sort. Bad luck if you want it descending.
Auto-sync field of lookup value
This feature has been requested many times in the discussion Field of Lookup Announcement and this post aims to track it separately. At the moment the value of a 'field of lookup' is a snapshot but once the parent lookup field is updated the values diverge.
Issue with Zoho Projet
Zoho Project on all the cellphones of my customer is crashing. He has mixed brands (Samsung and Pixel). Everything is fine on website and mobile website. Could not reproduce the issue in workshop using Samsung/Pixel/iPhone Uninstallation of Zoho Project
Four types of task dependencies
"Nothing is particularly hard if you divide it into small jobs." - Henry Ford Projects, small or large, are driven by simple work units called tasks. Monitoring standalone tasks might look simple but as the workflow becomes elaborate, tasks may start relying on one another. In project management, this relationship between tasks is termed as "Task Dependencies". Dependency between tasks arise
Kit Items Breaking Automations - "Provide mapped components for all kit items"
This has been brought up in other threads, but I believe this issue warrants its own topic. Whenever a sales document (Estimate, Sales Order, Invoice) is created or manipulated programmatically, trying to include a Kit as an Item throws this error: "Provide
VAT-type Taxes in US Edition?
I'm located in the US, and I use the Zoho One US edition of Books. We are in the process of registering with Canadian authorities for their GST / HST, which is a VAT-type of scheme. It is not immediately obvious to me how one would deal with input tax
Restrict user from viewing the detail standard view
Is there any way to restrict a user(it can be user-field-based) from viewing the detail standard view? Basically, I have created a canvas detailed view so that on some conditions I can hide some data from the users but the standard view client script
Ecommerce integration with prestashop
Development of campaigns integration with prestahop. When???
How to create an article containing images and rich text via the api?
Hi, I'm trying to migrate our kb articles from our previous helpdesk service, and import them to ZohoDesk. Is there any way to create an article that contains images? Is it possible to add formatting to articles created via the API? Thanks, Adam.
Number of statement execution limit exceeded on deluge scheduled function
I'm working on a send email functionality in creator that sends out crew work orders at the end of the day each day for the next day. I'm running into the issue that zoho is unable to handle the number of statements that I am doing to be able to successfully
Multi-currency in Zoho CRM Forecast and Reports
As a company we have branches in 4 different countries with as many different currencies. Our Sales Teams would like to work with their local currency as much as possible. The Forecast module using only 1 currency is practically usable only by the sales
Organizing contacts/members by company
I work for a membership organization (representing businesses) and am trying to use Zoho CRM more effectively for managing the points of contact for our members. Currently, our members are listed in our CRM by the primary point of contact's name, but
Fetch Records using Dynamic Criteria
Hi, I have a form that builds a filter based on user input. I need to fetch the records based on dynamic criteria. How would I accomplish this as there is no eval function? For example: desiredRecord = Form1[dynamicCriteria];
Color of Text Box Changes
Sometimes I find the color of text boxes changed to a different color. This seems to happen when I reopen the same slide deck later. In the image that I am attaching, you see that the colors of the whole "virus," the "irology" part of "virology," and
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

Use cases

eBooks

Videos

Webinar

France ZUGs

Topic Participants

Anu Abraham

Sticky Posts

Kaizen #197: Frequently Asked Questions on GraphQL APIs

Kaizen #198: Using Client Script for Custom Validation in Blueprint

Celebrating 200 posts of Kaizen! Share your ideas for the milestone post

Kaizen #193: Creating different fields in Zoho CRM through API

Client Script | Update - Introducing Commands in Client Script!

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

Emoji Support in Bigin CRM

How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.

How do you add or update tags on Zoho CRM records via n8n? (Workarounds or best practices?)

Set Custom Icon for Custom Modules in new Zoho CRM UI

Why is Zoho Meeting quality so poor?

Bigin Booking Pages enhancements

Enhancements to Client script?

Amount in words in Indian format

What are people using to send Service based emails?

Standalone LMS tool

Announcing Kiosk 1.1 - Customize screen titles, configure new fields & actions, use values from your Kiosk to update fields, and more.

Empowered Custom Views: Cross-Module Criteria Now Supported in Zoho CRM

New Customization options in the module builder: Quick Create and Detail view

An Overview of Dario Schiraldi Deutsche Bank Executive

Sending gmail to a particular person fails because the address gets changed to "gmaill", with a second "l" typo somewhere

Emailing a document to WorkDrive

Issue showing too many consultations in my workspace link.

Url filter Report date (pivot chart)

Allow Changing Appointment Status from "Completed" to "No Show" or Other Valid States

Ability to modify what displays in calendar invite?

Zoho One and Tally Integration

Microsoft PowerPoint files Extremely slow to save

How can users unblock their blocked Zoho Mail accounts?

Adding additional fields for batch information

API PARAMETER FOR TICKET CLOSED TIME

Dynamic Pickup List Values using Deluge and Client Script

Pick List Issues

Auto-sync field of lookup value

Issue with Zoho Projet

Four types of task dependencies

Kit Items Breaking Automations - "Provide mapped components for all kit items"

VAT-type Taxes in US Edition?

Restrict user from viewing the detail standard view

Ecommerce integration with prestashop

How to create an article containing images and rich text via the api?

Number of statement execution limit exceeded on deluge scheduled function

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