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

Blogs | GandS - Catch The Exception

GandS


If you want to integrate salesforce with your app, In the begginning, you’ve heared lot of terms like SOQL, REST, etc with salesfoce. If thats confusing same as me, this article is only for you.

<h1 id="salesforce">What is salesforce CRM?</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. Salesforce CRM is the one among them and it is mostly used CRM around the world. Salesfoce 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 Salesforce Workbench?</h1>

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

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

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

<br />

<h1 id="terms">Apex, SOQL, Objects, Records, Visualforce other common Salesforce terms</h1>
<h2 id="apex">Apex</h2>

Apex is one of the programming language developed by salesforce specifically for the Salesforce CRM. It is primarily used for writing server side code, such as triggers, classes, and controllers, to extend the capabilities of Salesforce.

Some of the key characteristics of Apex:

- Object-Oriented : It follows OOP concept that allows developers to define and create classes, objects, and interfaces.

- Strongly-Typed : Variables must be declared with a specific data type and cannot be implicitly converted to other types.

- Triggers : Code snippets 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.

- Web Services : Supports to expose custom web services, allowing external systems to interact with Salesforce and perform CRUD operations.

- Unit Testing : It has built-in support for unit testing which allows developers to write a test cases to check the quality of the code and identifying and fixing issues early.

<h2 id="visualforce">Visualforce</h2>

It is a web development framework developed by salesforce specifically for building custom user interfaces and pages within the Salesforce. It is a markup language that allows developers to create customized layouts, forms, and components to enhance the user experience and extend the functionality of Salesforce applications.

<h2 id="SOQL">SOQL</h2>

SOQL (Salesforce Object Query Language) is a query language used to retrieve data from Salesforce databases. It is designed by Salesforce for quering the salesforce 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 salesforce 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="objects">Objects</h2>

Objects represent a table that stores specific types of data. Simply Objects are entities that holds records with related information.

It supports both standard objects and custom objects:

- Standard Objects : These are Salesforce built-in Objects such as Account, Contact, Opportunity, Lead and etc.

- Custom Objects : These are objects that you can create to store organization-specific data that is unique to your business processes. Custom objects allow you to define the fields, relationships, and behaviors that best suit your requirements.

<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 objects we can have standard salesforce fields along with organization specific custom fields.

<h1 id="generate-key">Generate Private Key and Self-Signed Digital Certificate</h1>

This process produces two files:

- `server.key` - The private key. Which is used to sign the JWT claim generated by your code.
- `server.crt` - The digital certificate. You upload this file when you create the required connected app.

1. Open a terminal or command prompt.
2. Install OpenSSL on your computer. Please check whether it is installed or not.

- In macOS or Linux

```bash
which openssl
```

- In Windows

```bash
where openssl
```

3. Change to our app directory.

```bash
cd app
```

4. Generate a private key and self-signed digital certificate.

```bash
openssl req -x509 -sha256 -nodes -days 36500 -newkey rsa:2048 -keyout private-key.pem -out cert.pem
```

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

You can sign up for a free salesforce developer account [here](https://developer.salesforce.com/signup).

You'll get a email from salesforce on sucessfull signup. In this email, you’ll get your verification link, developer URL and user name. On verifiying, you’ll be asked to enter the password initially. Verify your password and proced which then it’ll redirect to your home page. (These are one time setup).

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

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

- Navigate to `App Manager` in `Apps` and Create a new connected app by clicking `New Connected App` in top right corner (Refer Screenshot Below).
  <br />

![App Manager](//images.ctfassets.net/d0q84pcgw6si/7MZbDjhH4LiWem8Un5ORmT/839fb59db2eec9ea9ee1fb176536f09f/S3.png)

<br />

- Fill basic informations like app name, API name(salesforce generate for you based on app name or else you can have your own), email, Most importantly enable OAUTH settings and give http://localhost:8080/auth/callback as callback URL , enable use digital signature and upload your digital signature that we have generated by using openssl. Select and add the required scope. (For testig you can select all the scopes). (Refer Screenshot Below)

<br />

![Create Connected App](//images.ctfassets.net/d0q84pcgw6si/2CbWUUxMFRNfwJ3S2az83y/58928203a941588c278803bbafec2264/S4.png)

<br />

Click save and wait few minutes for salesforce to create a app for you.

Once created, click on manage consumer details, make a note of `Consumer Key` and `Consumer 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/salesforce-workbench
```

- Go to the project directory

```bash
  cd salesforce-workbench
```

- Install dependencies

```bash
  npm install
```

- Start the server

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

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

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


This article will help you to integrate your nodejs application with the salesforce. It also covers about Basics of Salesforce and Other terms like SOQL, APEX Classes and Triggers and also CRUD Operations Using Both SOQL and REST.

Salesforce Workbench

Self Hosted Minimal Salesforce Workbench

If you are a developer, At some point you have heard the word GraphQL. At the time you may have lots of questions running in your mind like what is it? What is the different between REST and GraphQL? Why GraphQL? Which language support GraphQL and so on. You can get the answers for your questions here.

<h1 id="graphql">What is GraphQL</h1>

GraphQL is an acronym of “Graph Query Language”. It is a query language and server-side runtime for API’s. (Just as name suggests 😉).

We know that, SQL (Structured Query Language) is used to querying on Relational Databases. Similarly, GraphQL is a mechanism that allows you to retriving only the fields that you need. Once GraphQL is implemented, no need to create or modify everything in your backend. I undersand it bit confused. It is confusing only in the begginning and not if you complete this article. Knowing history is important. So Before we dive in, let’s understand, [Five Ws](https://gist.github.com/geekygands/6ab20861b477ef86999d31c1cffe8b81) of GraphQL.

<div align="center">
  {' '}
  <h2 align="center"> Agárrate fuerte</h2>{' '}
</div>
<br />
<br /># Five Ws of GraphQL

We have already seen one of Five Ws, Which is nothing but What is GraphQL, Let see another Four Ws.

GraphQL was first built and used by facebook in 2012 internally and was released externally in 2015. Facebook identified themselves with an issue. Facebook started to suffer poor performances and frequently crashed as the become more complex. Facebook solved this issue by developing a technology called GraphQL. It is designed to make APIs fast, flexible and developer friendly. It cab be even deployed within an IDE known as GraphiQL.

<h1 id="rest-api"> How it is different from REST API?</h1>

- In REST API, we usually use HTTP Methods like GET, POST, PUT, PATCH, DELETE whereas in GraphQl we use Query, Mutation and Subscription.
- With Traditional REST API, we have to create seperate end point based on the request. When your app gets complicated, It is hard to scale because of hundrads of hundrads routers or more. GraphQL uses a single endpoint where everything is handled. Scaling an application is simple when compared to REST API,
- GraphQL allows us to fetch the data that is required. It allows us to specify which data has to be return whereas in REST API, It return all the data from the backend.
- GraphQL uses Type System for describing our backend. (Typescript hardcore fans will get this.)
- GraphQL is self documented. GraphiQL will automatically document all your queries and mutataions. Also GraphiQL allows developer and tester to debug and test without using the apollo client.
- GraphQL is way faster than some of the popular traditional API's.

Apart from this, GraphQL have other advantages as well as disadvantages.

<h1 id="advantages">Advantages</h1>

- Strongly typed : Each layer of a GraphQL query corresponds to a particular type, and each type describes a set of available fields.
- Defines a data shape : When GraphQL queries are requested to graphql server, it returns the response simple and required shape. So, it facilitates you to write a specific query according to your requirement.

<h1 id="disadvantages">Disadvantages</h1>

- GraphQL Rate Limiting : In Rest API, we can limit the request whereas in GraphQL it is not possible.
- GraphQL Caching : Implementing a cache is more complecated than REST API.

<br />
<br /># Example Scenario

Let say you went for a outing and decided to do several things like gave a college notes to your friend, purchasing shoes at mall, went to bank to withdraw, etc.

In REST model, you have to travel at different places to complete them. On the other hand, In GraphQL, you can tell your friend to assist to do everything for you. You’ll just travel to your friend house only.

Hope you get the idea of GraphQL. Cool! So how does it work? thats what we're about see.

<h1 id="terms">Schemas, Resolvers and other common GraphQL terms</h1>

<h2 id="schemas">Schemas</h2>

Central to every GraphQL server is its schema. GraphQL schema describe the pattern or shape of the graph. It gives idea about the data which operations can perform on the server. It is written in easy and readable SDL or Schema Definition Language. It’s like a How the data can be requested from the server. Here’s a sample SDL

```graphql
type Computer {
  name: String!
  modal: String!
  memory: String!
  processor: String!
}
```

```graphql
type Human {
  name: String!
  age: Int!
}
```

If you look at the above schema, it clearly state that Computer type contains name,modal, memory,processor of string type and ! represent NOT NULL type and Human type contains name and age of string and not null type. Apart from int and string other data type like float,list, etc also supported in GraphQL. So this schema allows us to write a query and mutation in GraphQL.

<h2 id="resolvers">Resolvers</h2>

Resolver is a function that's responsible for populating the data for a single field in your schema. It can populate that data in any way you define, such as by fetching data from a back-end database or a third-party API.

Here’s a example :

```js
const resolvers = {
  Query: {
    computers() {
      return computer;
    },
    humans() {
      return human;
    },
  },
};
```

<h2 id="query">Query</h2>

Same as SQL, GraphQL Query is the way to retrive the data from the backend server. It is same as using GET Method in REST.

Let’s say you want to get the customer name and age from the backend stored in the database, you would have use the query like given below .

```graphql
query {
  customer {
    name
    age
  }
}
```

Let’s say you want to get the specific customer information from the database, you would have use the query like this.

```graphql
query {
  user(id: "23") {
    name
    age
  }
}
```

Here we have another main advantage of GraphQL is it support quering the nested information like we use JOIN in SQL. Now let’s assume you want to query customer information along with the order details, query structure look like this..

```graphql
query {
  customer {
    name
    age
    orders {
      id
      amount
    }
  }
}
```

<h2 id="mutation">Mutation</h2>

Mutation is the way to add, update or delete the data. It is same as using POST, PUT, and DELETE Method in REST.

Using mutation we can perform create, modify or delete in the backend. Let say you want to create customer, mutation structure look like given below.

```graphql
mutation {
  addCustomer(name: "Geeky GandS", age: 3) {
    name
    age
  }
}
```

<h2 id="subscription">Subscription</h2>

Subscription is a way to retrieve data just like query but the difference is that subscription continuously listen for updated values and send updated values to client that choose to listen to real-time message from the server. for that it establishes long lasting connection with server.

Basic subscription looks like this:

```graphql
subscription {
  users {
    id
    name
    age
  }
}
```

<h1 id="languages">Language Support</h1>

<br />
![GraphQL Supported Languages](//images.ctfassets.net/d0q84pcgw6si/4p8r2VK4yyHrIlHjpq9VU4/604a838bc326271741b5f26f56d0acfd/graphql-language.png)
<br />
<br />

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

GraphQL makes a lot simpler to fetch the data from the backend when compared to REST, which is the main reason for GraphQL fast. But GraphQL does not support HTTP status code mechanism and error magement and monitoring. Both GraphQL and REST has its own advantages and disadvantages. REST is old traditional way and used by everyone and on the other hand GraphQL is also becoming popular in recent times. Based on your application usage you can choose whatever you want.

<div align="center">
  {' '}
  <h1 align="center"> Bella Ciao</h1>{' '}
</div>


GraphQL is a powerful query language and runtime for APIs that was developed by Facebook. It allows to request only the required data rather than returning all the data. In this blog, You'll get the idea on GraphQL and other terms like Schemas, Resolvers, Query, Mutation, etc.

GraphQL

Demystifying GraphQL - A Comprehensive Guide


<h1 id="introduction">Naming Conventions In Programing</h1>

In Programming, Naming Conventions refers to set of rules and patterns used to name a variables, functions, classes, methods, interfaces and so on. These conventions ensure consistency and improve code readability, making it easier for developers to understand and maintain the codebase. Based on the programming language and developement community, naming conventions can vary from one to other.

<h1 id="popular">Popular Naming Conventions</h1>

Some of the popular naming conventions used by the developers.

<h2 id="camel">Camel Case</h2>

In Camel Case, naming should starts with a small letter. If the name has multiple words, then the words will starts with a capital letter.

first letter of the first word is small and remaining words are capital.

Some of the examples:

- firstName
- lastName
- proofOfIdentity

<h2 id="pascal">Pascal Case</h2>

Pascal Case is similar to Camel Case. But the difference is, it starts with a capital letter.

Some of the examples:

- FirstName
- LastName
- ProofOfIdentity

<h2 id="snake">Snake Case</h2>

In Snake Case, naming should starts with a small letter. If the name has multiple words, then the words will starts with a small letter with underscore (`_`) to seperate the words.

In a nutshell, first letter of the each word is small, seperated with (`_`).

Some of the examples:

- first_name
- last_name
- proof_of_identity

<h2 id="kebab">Kebab Case</h2>

Kebab Case is similar to the Snake Case, But hyphen (`-`) is used instead of (`_`) to seperate the words.

Some of the examples:

- first-name
- last-name
- proof-of-identity

<br />
<br />

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

We've seen the most popular naming conventions that you should know.Naming conventions are not something related to programming language. Instead, they are adopted by developers across the world and considered best practice to produce clean, readable and maintainable code. It's good to familiarize yourself with the naming convention within your developement team or organization.

<div align="center">
  {' '}
  <h1 align="center"> Bella - Ciao</h1>{' '}
</div>


If you've been programming for a while, you may have heard the words 'camel case' or 'pascal case'. This article will help you to understand various naming conventions used in any programing languages.

Naming Conventions

From camelCase To snake_case - Naming Conventions

ChatGPT is an AI Chatbot developed by OpenAI. It has been buzzing around the technology world. If you are someone who has been using ChatGPT for a while and wants to integrate it to WhatsApp, then this blog is only for you. Here we are using OpenAI API, WhatsApp API, and uses FastAPI for Creating a webhook. Looks interesting na? So Let's get Botified.

<h1 id="opanai">OpenAI Developer</h1>

You need OpenAI API key to use OpenAI API and SDK. We are using this to send our messages to OpenAI thus we'll get the appropriate response from OpenAI based on the request. You can sign up for a free OpenAI account [here](https://platform.openai.com/).

On Successful signup, you need to create a API Key. To do this visit the API Keys [page](https://platform.openai.com/account/api-keys). Then click on `Create new secret key` and give any name.

> You need to paste this key into your .env file. So For now, Just note down the API KEY.

<br />

<h1 id="facebook">Facebook Developer</h1>

You can sign up for a free facebook developer account [here](https://developers.facebook.com/).

Once developer account setup is completed, You're required to create a new app.

1. On dashboard, Click on `Create App` button.
   <br />

![App Dashboard](//images.ctfassets.net/d0q84pcgw6si/608s1a5eHyR1Hxw6Co75ho/b76fb1563a9baaf50f7cc8439bb3c359/1.png)

<br />

2. Initially, It'll ask you to select the purpose of the app. Each option has some predefined configurations inside the app. If you don't know what to select, Select `Others`.

<br />

![App Purpose](//images.ctfassets.net/d0q84pcgw6si/3v03iXOjCCD69kflZtaM03/107c8cc7cc95a43f0bf671e1f18aa92f/2.png)

<br />

3. Then, you'll need to select the type of the App. Here select `Business` which is more related to our requirement.

<br />

![App Type](//images.ctfassets.net/d0q84pcgw6si/1QG5C6XZbQdFdHc7YevTre/126a6a114c9ba9efa0390e56c91daecf/3.png)

<br />

4. After that, Type `App Name`, `Contact Email`, `Business Account`. These data can be anything.

<br />

![App Details](//images.ctfassets.net/d0q84pcgw6si/2RgUZSi3aBeLll9vhk6PXd/1533fe59fbd6e02d2f29b782db2fa571/4.png)

<br />

5. In App Dashboard, There you can see various type of integration. Select Setup which is in `WhatsApp` card.

<br />

![App Integration](//images.ctfassets.net/d0q84pcgw6si/5LWIHnJscCWODrWUl1jUh4/32b8b05f005186db93cb0d583e09d4ce/5.png)

<br />

6. Click on `Start Using The API`.

<br />

![WhatsApp Setup](//images.ctfassets.net/d0q84pcgw6si/5xurovGp5K5epkd9stsqOX/ec7548177443fcca77aaf58d15dbd491/6.png)

<br />

7. Here you can find Temporary access token (we can also create long lived access token), Test phone number, Your phone number, and a sample WhatsApp API request.

<br />

![WhatsApp API](//images.ctfassets.net/d0q84pcgw6si/2Q8iHWuoIti7rixKJCWXDt/6b6594e3178276087de7ee73943d482c/7.png)

<br />

> You need to paste this Access token and Test phone number into your .env file. So For now, Just note down the Access token and Test phone number.

<br />

Since this is a developement mode, You are allowed to have 5 numbers from the test number. It'll only work from this 5 numbers. If you want to use this bot in real time people, you are required to purchase a phone number and need to verify your business.

<br />

8. Subscribe the fields based on the requirement. Only `messages` field is enough for events that has to be trigged on messages. But for now, You can select all the permissions.

<br />

![API Subscription](//images.ctfassets.net/d0q84pcgw6si/2kDxFlulBUZVkz5fjhQizV/7b322ee319087ad91b9e662c7fe57a2a/9.png)

<br />

9. Need to configure the Webhook for integrating WhatApp with our Backend code.

<br />

![WhatsApp Webhook](//images.ctfassets.net/d0q84pcgw6si/1DqcBJbRsoOCg7qHowLKMV/1b75785f6a29fe301e3782357ba62ea2/8.png)

<br />

- `Callback URL` - Our backend server URL. Whenever any events occurred on the selected fields from previous step, the data with the action is sent to this URL.
- `Verify token` - Any string that should match with VERIFYTOKEN in our .env file.

<br />

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

- Clone the project

```bash
  git clone https://github.com/gandstech/openai-whatsapp-fastapi
```

- Go to the project directory

```bash
  cd openai-whatsapp-fastapi
```

- Install dependencies

```bash
  pip install -r requirements.txt
```

- Copy the env.local to .env and fill OPENAI_TOKEN (Obtained from OpenAI Account), VERIFYTOKEN (Any String that has to match with `Verify Token` in Webhook configuration), FACEBOOK_API (Obtained from Facebook Developer Account) and TEST_PHONE_NUMBER(Obtained from Facebook Developer Account).

```bash
  cp env.local .env
```

- Start the server

```bash
  uvicorn main:app --reload
```

- Use ngrok or some other services to put our app in the public.

```bash
ngrok http 8000 --region us
```

> This generate a public accessible URL that should be given as a callback URL in webhook configurations. Ex. https://8e6c-103-103-9-234.ngrok-free.app/python-fastapi/webhook/facebook

- From your WhatsApp, send any message to the test number obtained in facebook developer to test the chatbot.
  <br />

<h1 id="flow">Flow Diagram</h1>

<br />
<br />

<div align="center">
  {' '}
  <img
src="//images.ctfassets.net/d0q84pcgw6si/2UnISMctzLWGoxzUh2YBmY/dc1b20b017e0ce6ee45c09172eb5a03a/openai-whatsapp-flow.png"
    align="center"
    alt="Flow Diagram"
  />{' '}
</div>

> Working Flow Of The Bot

<br />
<br />

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

To summarize, you just made your own chatgpt, integrated with whatsapp and had conversation with it.

Feel free to integrate this chatbot backend with other messaging services like slack, telegram or even in your own application. If you want me to help you to integrate with any other application, please reach out to me or leave a comment below.

Have fun with your own whatsapp chatbot!

<br />
<br />


Making your own ChatGPT chatbot is a fun and useful project. In this article, we will discuss on how you can build your own custom ChatGPT and Integrating with whatsapp using facebook developer account.

openai-whatsapp-fastapi

Build Your Own WhatsApp - ChatGPT (OpenAI) With FastAPI

ChatGPT is an AI Chatbot developed by OpenAI. It has been buzzing around the technology world. If you are someone who has been using ChatGPT for a while and wants to integrate it to WhatsApp, then this blog is only for you. Here we are using OpenAI API, WhatsApp API, and uses Flask for Creating a webhook. Looks interesting na? So Let's get Botified.

<h1 id="opanai">OpenAI Developer</h1>

You need OpenAI API key to use OpenAI API and SDK. We are using this to send our messages to OpenAI thus we'll get the appropriate response from OpenAI based on the request. You can sign up for a free OpenAI account [here](https://platform.openai.com/).

On Successful signup, you need to create a API Key. To do this visit the API Keys [page](https://platform.openai.com/account/api-keys). Then click on `Create new secret key` and give any name.

> You need to paste this key into your .env file. So For now, Just note down the API KEY.

<br />

<h1 id="facebook">Facebook Developer</h1>

You can sign up for a free facebook developer account [here](https://developers.facebook.com/).

Once developer account setup is completed, You're required to create a new app.

1. On dashboard, Click on `Create App` button.
   <br />

![App Dashboard](//images.ctfassets.net/d0q84pcgw6si/608s1a5eHyR1Hxw6Co75ho/b76fb1563a9baaf50f7cc8439bb3c359/1.png)

<br />

2. Initially, It'll ask you to select the purpose of the app. Each option has some predefined configurations inside the app. If you don't know what to select, Select `Others`.

<br />

![App Purpose](//images.ctfassets.net/d0q84pcgw6si/3v03iXOjCCD69kflZtaM03/107c8cc7cc95a43f0bf671e1f18aa92f/2.png)

<br />

3. Then, you'll need to select the type of the App. Here select `Business` which is more related to our requirement.

<br />

![App Type](//images.ctfassets.net/d0q84pcgw6si/1QG5C6XZbQdFdHc7YevTre/126a6a114c9ba9efa0390e56c91daecf/3.png)

<br />

4. After that, Type `App Name`, `Contact Email`, `Business Account`. These data can be anything.

<br />

![App Details](//images.ctfassets.net/d0q84pcgw6si/2RgUZSi3aBeLll9vhk6PXd/1533fe59fbd6e02d2f29b782db2fa571/4.png)

<br />

5. In App Dashboard, There you can see various type of integration. Select Setup which is in `WhatsApp` card.

<br />

![App Integration](//images.ctfassets.net/d0q84pcgw6si/5LWIHnJscCWODrWUl1jUh4/32b8b05f005186db93cb0d583e09d4ce/5.png)

<br />

6. Click on `Start Using The API`.

<br />

![WhatsApp Setup](//images.ctfassets.net/d0q84pcgw6si/5xurovGp5K5epkd9stsqOX/ec7548177443fcca77aaf58d15dbd491/6.png)

<br />

7. Here you can find Temporary access token (we can also create long lived access token), Test phone number, Your phone number, and a sample WhatsApp API request.

<br />

![WhatsApp API](//images.ctfassets.net/d0q84pcgw6si/2Q8iHWuoIti7rixKJCWXDt/6b6594e3178276087de7ee73943d482c/7.png)

<br />

> You need to paste this Access token and Test phone number into your .env file. So For now, Just note down the Access token and Test phone number.

<br />

Since this is a developement mode, You are allowed to have 5 numbers from the test number. It'll only work from this 5 numbers. If you want to use this bot in real time people, you are required to purchase a phone number and need to verify your business.

<br />

8. Subscribe the fields based on the requirement. Only `messages` field is enough for events that has to be trigged on messages. But for now, You can select all the permissions.

<br />

![API Subscription](//images.ctfassets.net/d0q84pcgw6si/2kDxFlulBUZVkz5fjhQizV/7b322ee319087ad91b9e662c7fe57a2a/9.png)

<br />

9. Need to configure the Webhook for integrating WhatApp with our Backend code.

<br />

![WhatsApp Webhook](//images.ctfassets.net/d0q84pcgw6si/1DqcBJbRsoOCg7qHowLKMV/1b75785f6a29fe301e3782357ba62ea2/8.png)

<br />

- `Callback URL` - Our backend server URL. Whenever any events occurred on the selected fields from previous step, the data with the action is sent to this URL.
- `Verify token` - Any string that should match with VERIFYTOKEN in our .env file.

<br />

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

- Clone the project

```bash
  git clone https://github.com/gandstech/openai-whatsapp-flask
```

- Go to the project directory

```bash
  cd openai-whatsapp-flask
```

- Install dependencies

```bash
  pip install -r requirements.txt
```

- Copy the env.local to .env and fill OPENAI_TOKEN (Obtained from OpenAI Account), VERIFYTOKEN (Any String that has to match with `Verify Token` in Webhook configuration), FACEBOOK_API (Obtained from Facebook Developer Account) and TEST_PHONE_NUMBER(Obtained from Facebook Developer Account).

```bash
  cp env.local .env
```

- Start the server

```bash
  flask run
```

- Use ngrok or some other services to put our app in the public.

```bash
ngrok http 5000 --region us
```

> This generate a public accessible URL that should be given as a callback URL in webhook configurations. Ex. https://88d5-103-103-9-202.ngrok-free.app/python-flask/webhook/facebook

- From your WhatsApp, send any message to the test number obtained in facebook developer to test the chatbot.
  <br />

<h1 id="flow">Flow Diagram</h1>

<br />
<br />

<div align="center">
  {' '}
  <img
src="//images.ctfassets.net/d0q84pcgw6si/2UnISMctzLWGoxzUh2YBmY/dc1b20b017e0ce6ee45c09172eb5a03a/openai-whatsapp-flow.png"
    align="center"
    alt="Flow Diagram"
  />{' '}
</div>

> Working Flow Of The Bot

<br />
<br />

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

To summarize, you just made your own chatgpt, integrated with whatsapp and had conversation with it.

Feel free to integrate this chatbot backend with other messaging services like slack, telegram or even in your own application. If you want me to help you to integrate with any other application, please reach out to me or leave a comment below.

Have fun with your own whatsapp chatbot!

<br />
<br />


openai-whatsapp-flask

Build Your Own WhatsApp - ChatGPT (OpenAI) With Flask

ChatGPT is an AI Chatbot developed by OpenAI. It has been buzzing around the technology world. If you are someone who has been using ChatGPT for a while and wants to integrate it to WhatsApp, then this blog is only for you. Here we are using OpenAI API, WhatsApp API, and uses Nest.js for Creating a webhook. Looks interesting na? So Let's get Botified.

<h1 id="opanai">OpenAI Developer</h1>

You need OpenAI API key to use OpenAI API and SDK. We are using this to send our messages to OpenAI thus we'll get the appropriate response from OpenAI based on the request. You can sign up for a free OpenAI account [here](https://platform.openai.com/).

On Successful signup, you need to create a API Key. To do this visit the API Keys [page](https://platform.openai.com/account/api-keys). Then click on `Create new secret key` and give any name.

> You need to paste this key into your .env file. So For now, Just note down the API KEY.

<br />

<h1 id="facebook">Facebook Developer</h1>

You can sign up for a free facebook developer account [here](https://developers.facebook.com/).

Once developer account setup is completed, You're required to create a new app.

1. On dashboard, Click on `Create App` button.
   <br />

![App Dashboard](//images.ctfassets.net/d0q84pcgw6si/608s1a5eHyR1Hxw6Co75ho/b76fb1563a9baaf50f7cc8439bb3c359/1.png)

<br />

2. Initially, It'll ask you to select the purpose of the app. Each option has some predefined configurations inside the app. If you don't know what to select, Select `Others`.

<br />

![App Purpose](//images.ctfassets.net/d0q84pcgw6si/3v03iXOjCCD69kflZtaM03/107c8cc7cc95a43f0bf671e1f18aa92f/2.png)

<br />

3. Then, you'll need to select the type of the App. Here select `Business` which is more related to our requirement.

<br />

![App Type](//images.ctfassets.net/d0q84pcgw6si/1QG5C6XZbQdFdHc7YevTre/126a6a114c9ba9efa0390e56c91daecf/3.png)

<br />

4. After that, Type `App Name`, `Contact Email`, `Business Account`. These data can be anything.

<br />

![App Details](//images.ctfassets.net/d0q84pcgw6si/2RgUZSi3aBeLll9vhk6PXd/1533fe59fbd6e02d2f29b782db2fa571/4.png)

<br />

5. In App Dashboard, There you can see various type of integration. Select Setup which is in `WhatsApp` card.

<br />

![App Integration](//images.ctfassets.net/d0q84pcgw6si/5LWIHnJscCWODrWUl1jUh4/32b8b05f005186db93cb0d583e09d4ce/5.png)

<br />

6. Click on `Start Using The API`.

<br />

![WhatsApp Setup](//images.ctfassets.net/d0q84pcgw6si/5xurovGp5K5epkd9stsqOX/ec7548177443fcca77aaf58d15dbd491/6.png)

<br />

7. Here you can find Temporary access token (we can also create long lived access token), Test phone number, Your phone number, and a sample WhatsApp API request.

<br />

![WhatsApp API](//images.ctfassets.net/d0q84pcgw6si/2Q8iHWuoIti7rixKJCWXDt/6b6594e3178276087de7ee73943d482c/7.png)

<br />

> You need to paste this Access token and Test phone number into your .env file. So For now, Just note down the Access token and Test phone number.

<br />

Since this is a developement mode, You are allowed to have 5 numbers from the test number. It'll only work from this 5 numbers. If you want to use this bot in real time people, you are required to purchase a phone number and need to verify your business.

<br />

8. Subscribe the fields based on the requirement. Only `messages` field is enough for events that has to be trigged on messages. But for now, You can select all the permissions.

<br />

![API Subscription](//images.ctfassets.net/d0q84pcgw6si/2kDxFlulBUZVkz5fjhQizV/7b322ee319087ad91b9e662c7fe57a2a/9.png)

<br />

9. Need to configure the Webhook for integrating WhatApp with our Backend code.

<br />

![WhatsApp Webhook](//images.ctfassets.net/d0q84pcgw6si/1DqcBJbRsoOCg7qHowLKMV/1b75785f6a29fe301e3782357ba62ea2/8.png)

<br />

- `Callback URL` - Our backend server URL. Whenever any events occurred on the selected fields from previous step, the data with the action is sent to this URL.
- `Verify token` - Any string that should match with VERIFYTOKEN in our .env file.

<br />

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

- Clone the project

```bash
  git clone https://github.com/gandstech/openai-whatsapp-nestjs
```

- Go to the project directory

```bash
  cd openai-whatsapp-nestjs
```

- Install dependencies

```bash
  npm install
```

- Copy the env.local to .env and fill OPENAI_TOKEN (Obtained from OpenAI Account), VERIFYTOKEN (Any String that has to match with `Verify Token` in Webhook configuration), FACEBOOK_API (Obtained from Facebook Developer Account) and TEST_PHONE_NUMBER(Obtained from Facebook Developer Account).

```bash
  cp env.local .env
```

- Start the server

```bash
  npm start
```

- Use ngrok or some other services to put our app in the public.

```bash
ngrok http 3000 --region us
```

> This generate a public accessible URL that should be given as a callback URL in webhook configurations. Ex. https://35ac-103-103-9-219.ngrok-free.app/node-nest/webhook/facebook

- From your WhatsApp, send any message to the test number obtained in facebook developer to test the chatbot.
  <br />

<h1 id="flow">Flow Diagram</h1>

<br />
<br />

<div align="center">
  {' '}
  <img
src="//images.ctfassets.net/d0q84pcgw6si/2UnISMctzLWGoxzUh2YBmY/dc1b20b017e0ce6ee45c09172eb5a03a/openai-whatsapp-flow.png"
    align="center"
    alt="Flow Diagram"
  />{' '}
</div>

> Working Flow Of The Bot

<br />
<br />

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

To summarize, you just made your own chatgpt, integrated with whatsapp and had conversation with it.

Feel free to integrate this chatbot backend with other messaging services like slack, telegram or even in your own application. If you want me to help you to integrate with any other application, please reach out to me or leave a comment below.

Have fun with your own whatsapp chatbot!

<br />
<br />


openai-whatsapp-nestjs

Build Your Own WhatsApp - ChatGPT (OpenAI) With Nest.js

ChatGPT is an AI Chatbot developed by OpenAI. It has been buzzing around the technology world. If you are someone who has been using ChatGPT for a while and wants to integrate it to WhatsApp, then this blog is only for you. Here we are using OpenAI API, WhatsApp API, and uses Express.js for Creating a webhook. Looks interesting na? So Let's get Botified.

<h1 id="opanai">OpenAI Developer</h1>

You need OpenAI API key to use OpenAI API and SDK. We are using this to send our messages to OpenAI thus we'll get the appropriate response from OpenAI based on the request. You can sign up for a free OpenAI account [here](https://platform.openai.com/).

On Successful signup, you need to create a API Key. To do this visit the API Keys [page](https://platform.openai.com/account/api-keys). Then click on `Create new secret key` and give any name.

> You need to paste this key into your .env file. So For now, Just note down the API KEY.

<br />

<h1 id="facebook">Facebook Developer</h1>

You can sign up for a free facebook developer account [here](https://developers.facebook.com/).

Once developer account setup is completed, You're required to create a new app.

1. On dashboard, Click on `Create App` button.
   <br />

![App Dashboard](//images.ctfassets.net/d0q84pcgw6si/608s1a5eHyR1Hxw6Co75ho/b76fb1563a9baaf50f7cc8439bb3c359/1.png)

<br />

2. Initially, It'll ask you to select the purpose of the app. Each option has some predefined configurations inside the app. If you don't know what to select, Select `Others`.

<br />

![App Purpose](//images.ctfassets.net/d0q84pcgw6si/3v03iXOjCCD69kflZtaM03/107c8cc7cc95a43f0bf671e1f18aa92f/2.png)

<br />

3. Then, you'll need to select the type of the App. Here select `Business` which is more related to our requirement.

<br />

![App Type](//images.ctfassets.net/d0q84pcgw6si/1QG5C6XZbQdFdHc7YevTre/126a6a114c9ba9efa0390e56c91daecf/3.png)

<br />

4. After that, Type `App Name`, `Contact Email`, `Business Account`. These data can be anything.

<br />

![App Details](//images.ctfassets.net/d0q84pcgw6si/2RgUZSi3aBeLll9vhk6PXd/1533fe59fbd6e02d2f29b782db2fa571/4.png)

<br />

5. In App Dashboard, There you can see various type of integration. Select Setup which is in `WhatsApp` card.

<br />

![App Integration](//images.ctfassets.net/d0q84pcgw6si/5LWIHnJscCWODrWUl1jUh4/32b8b05f005186db93cb0d583e09d4ce/5.png)

<br />

6. Click on `Start Using The API`.

<br />

![WhatsApp Setup](//images.ctfassets.net/d0q84pcgw6si/5xurovGp5K5epkd9stsqOX/ec7548177443fcca77aaf58d15dbd491/6.png)

<br />

7. Here you can find Temporary access token (we can also create long lived access token), Test phone number, Your phone number, and a sample WhatsApp API request.

<br />

![WhatsApp API](//images.ctfassets.net/d0q84pcgw6si/2Q8iHWuoIti7rixKJCWXDt/6b6594e3178276087de7ee73943d482c/7.png)

<br />

> You need to paste this Access token and Test phone number into your .env file. So For now, Just note down the Access token and Test phone number.

<br />

Since this is a developement mode, You are allowed to have 5 numbers from the test number. It'll only work from this 5 numbers. If you want to use this bot in real time people, you are required to purchase a phone number and need to verify your business.

<br />

8. Subscribe the fields based on the requirement. Only `messages` field is enough for events that has to be trigged on messages. But for now, You can select all the permissions.

<br />

![API Subscription](//images.ctfassets.net/d0q84pcgw6si/2kDxFlulBUZVkz5fjhQizV/7b322ee319087ad91b9e662c7fe57a2a/9.png)

<br />

9. Need to configure the Webhook for integrating WhatApp with our Backend code.

<br />

![WhatsApp Webhook](//images.ctfassets.net/d0q84pcgw6si/1DqcBJbRsoOCg7qHowLKMV/1b75785f6a29fe301e3782357ba62ea2/8.png)

<br />

- `Callback URL` - Our backend server URL. Whenever any events occurred on the selected fields from previous step, the data with the action is sent to this URL.
- `Verify token` - Any string that should match with VERIFYTOKEN in our .env file.

<br />

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

- Clone the project

```bash
  git clone https://github.com/gandstech/openai-whatsapp-expressjs
```

- Go to the project directory

```bash
  cd openai-whatsapp-expressjs
```

- Install dependencies

```bash
  npm install
```

- Copy the env.local to .env and fill OPENAI_TOKEN (Obtained from OpenAI Account), VERIFYTOKEN (Any String that has to match with `Verify Token` in Webhook configuration), FACEBOOK_API (Obtained from Facebook Developer Account) and TEST_PHONE_NUMBER(Obtained from Facebook Developer Account).

```bash
  cp env.local .env
```

- Start the server

```bash
  npm start
```

- Use ngrok or some other services to put our app in the public.

```bash
ngrok http 3001 --region us
```

> This generate a public accessible URL that should be given as a callback URL in webhook configurations. Ex. https://9d72-103-103-9-219.ngrok-free.app/node-express/webhook/facebook

- From your WhatsApp, send any message to the test number obtained in facebook developer to test the chatbot.
  <br />

<h1 id="flow">Flow Diagram</h1>

<br />
<br />

<div align="center">
  {' '}
  <img
src="//images.ctfassets.net/d0q84pcgw6si/2UnISMctzLWGoxzUh2YBmY/dc1b20b017e0ce6ee45c09172eb5a03a/openai-whatsapp-flow.png"
    align="center"
    alt="Flow Diagram"
  />{' '}
</div>

> Working Flow Of The Bot

<br />
<br />

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

To summarize, you just made your own chatgpt, integrated with whatsapp and had conversation with it.

Feel free to integrate this chatbot backend with other messaging services like slack, telegram or even in your own application. If you want me to help you to integrate with any other application, please reach out to me or leave a comment below.

Have fun with your own whatsapp chatbot!

<br />
<br />


openai-whatsapp-expressjs

Build Your Own WhatsApp - ChatGPT (OpenAI) With Express.js

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.

All Posts

Self Hosted Minimal Salesforce Workbench

Demystifying GraphQL - A Comprehensive Guide

From camelCase To snake_case - Naming Conventions