GandS

If you want to integrate ZohoCRM with your app, In the begginning, you’ve heared lot of terms like COQL, REST, etc with ZohoCRM. This article explain key terms involved in ZohoCRM and how we can integrate with your node application.

<div align="center">
  {' '}
  <h2 align="center">ஆரம்பிக்கலாங்களா !!!</h2>{' '}
</div>
<br />

<h1 id="ZohoCRM">What is ZohoCRM?</h1>

CRM stands for Customer Releationship Management. It is a software that is used to store customer information like name, address, phone, email, etc. And also keep track of the customer activities. There are numerous CRM softwares are available out there. ZohoCRM is the one among them. ZohoCRM CRM helps your business in terms of marketing, sales, commerce, service and IT team works which makes your customers happy.

<h1 id="workbench">What is ZohoCRM Workbench?</h1>

ZohoCRM workbench is a free, open source, web based application to manage the ZohoCRM data. This allows developers and admins to integrate the ZohoCRM with any third party application. It allows transfer data between your ZohoCRM environments and Workbench.

<h1 id="benefits">Benefits of Using ZohoCRM Workbench</h1>

- Minimal, pretty fast and really easy to use.
- Can perform both COQL as well as REST.
- Work with any standard modules as well as custom modules.
- Can make use of Advanced REST Mode.
- You can host this in your server (Self Hosted).

<br />
<h1 id="terms">COQL, Modules, Records, other common ZohoCRM terms </h1>

<h2 id="COQL">COQL</h2>

COQL (CRM Object Query Language) is a query language used to retrieve data from ZohoCRM databases. It is designed by ZohoCRM for quering the ZohoCRM objects and their fields to fetch specific records that match certain criteria. Is is similar to standard SQL but with some changes that allows to work with ZohoCRM objects.

Since it is based on standard SQL, it allows various querying techniques like get only required fields, filtering, sorting, aggregation and traversing relationships between objects.

<h2 id="Modules">Modules</h2>
Modules represent a table that stores specific types of data. It is analogous to a column in a spreadsheet. Simply Modules are entities that holds records with related information.

Here are some of the standard modules in Zoho CRM:

- Leads
- Contacts
- Accounts
- Task
- Notes
- Attachments

> You can create your own modules based on your business needs

<h2 id="records-fields">Records vs Fields</h2>

Records are instance of Objects that contains specific data. whereas Fields are attributes or columns of the records such as name, phone, email, etc.

Similar to Modules, we can have standard ZohoCRM fields along with organization specific custom fields.

<h2 id="Pipeline">Pipeline</h2>

A visual representation of your sales funnel, showing the progress of your opportunities from lead to deal. It helps to track the progress of the sales team. Zoho allows us to use both pre-built pipelines or custom pipelines that you can customize.

You will need to specify the following when you are creating pipeline in ZohoCRM:

- Stages - Based on your sales process.
- Criteria - For moving opportunities between two pipeline stages.
- Metrics - To track for each stages.

<h2 id="Workflow">Workflow</h2>

A set of automated rules that execute before or after specific events like lead creation, updating or even deletion. It allows developers to perform anything based on the events and their business logic.

Some example scenarios:

- Send a welcome email to a lead when they are created in your CRM.
- Update lead status whenever the lead stage changes in the pipeline.
- Assign the task to the sales representative when the lead reaches a certain stage in your sales pipeline.
- Alert customer when their subscription is about to end.

<h2 id="Customization">Customization</h2>

The ability to change the look (UI) and feel of Zoho CRM to match your client, branding and business needs.

<h1 id="configuration">ZohoCRM Configuration</h1>

You can sign up for a free ZohoCRM developer account [here](https://www.zoho.com/crm/signup.html).

Once You are created your account, Follow the steps carefully,

You're required to create a client app when using the OAuth 2.0 JWT bearer authorization flow.

Open Zoho API Console from [here](https://api-console.zoho.com) and Create a new connected app by clicking `Add Client` in top right corner (Refer Screenshot Below).

<br />

![App Manager](//images.ctfassets.net/d0q84pcgw6si/6KgIhqmdw7dJwYpDDED1Cp/d3e1922ec77c41e432a927944ad5c514/console.png)

<br />

- Now you have to select the Client Type from these option. Since this is a browser based application, you can choose `Client-based Applications`.
  <br />

![Application Type](//images.ctfassets.net/d0q84pcgw6si/2tXZjyErxKEojRxGKQ6o0G/ac7fd6052c44ab832b43034a7cd755b9/Application.png)
<br />

- Fill basic informations like client name, Homepage URL, authorized URL, Domain. Keep localhost for now. You can change this to your website url once you moved to production. (Refer Screenshot Below)

<br />

![App Details](//images.ctfassets.net/d0q84pcgw6si/49SPQRjyDb2VKlkL2BhfCq/dff9e7ea71ac51dd90ea4e8f4dd3abf4/AppDetails.png)
<br />

Click save ZohoCRM to create a app for you with `Client ID` and `Client Secret`.

Once created, click on manage consumer details, make a note of `Client ID` and `Client Secret` and fill these details in you .env file.

<br />
<br />

<h1 id="run-in-local">Running Code Locally</h1>

- Clone the project

```bash
  git clone https://github.com/gokulselvan-r/zoho-workbench
```

- Go to the project directory

```bash
  cd zoho-workbench
```

- Install dependencies

```bash
  npm install
```

- Start the server

```bash
  npm run build-n-start
```

<h1 id="conclusion">Conclusion</h1>

This minimal ZohoCRM workbench provides various capabilities for developers working with the ZohoCRM platform. It allows the developers to test and troubleshoot their integrations with the ZohoCRM. It provides an environment for executing REST and COQL requests, examining response data, and debugging any issues that may arise when executing REST and COQL requests.

<div align="center">
  {' '}
  <h1 align="center">நன்றி</h1>{' '}
</div>


This article will help you to integrate your nodejs application with the ZohoCRM. It also covers about Basics of ZohoCRM and Other terms like COQL, Triggers and also CRUD Operations Using Both COQL and REST API.

ZohoCRM-workbench

Self Hosted Minimal ZohoCRM Workbench

Discover expert insights on web development, IT services, and tech trends at GandS – your tech guide.

Tag: Zoho

Self Hosted Minimal ZohoCRM Workbench