Kaizen #192 - Implementing Custom Token Persistence in Python SDK

Welcome back to another week of Kaizen!

Last week, we discussed how to implement Login with Zoho using OAuth 2.0 and saw how to bring it to life in a real-world application with the Zoho CRM Python SDK. We also discussed how Zylker Academy built a custom student portal powered by Zoho authentication.

In our sample project, we used the file-based persistence method, a simple setup where the access and refresh tokens are stored in a local file. While this method is great for getting started, it might not always fit your business requirements.

That is why our SDKs offer multiple ways to persist your tokens.

This week, we will explore why token persistence matters for your app’s secure operation, and how to implement custom token persistence methods, including a practical example using SQLite.

Why does token persistence matter?

When a user logs in via OAuth, Zoho returns two tokens:

An access token (valid for one hour), used to access Zoho CRM data.
A refresh token, used to get a new access token when the current one expires.

If your app does not store these tokens properly, your users will be forced to log in again every time they make an API call. Or every time their access token gets expired. That is not inconvenient; it is a poor user experience.

When you use Zoho CRM SDKs, this is all handled for you behind the scenes. When you first authenticate with Zoho, the SDK stores your access and refresh tokens. Later, when a token expires, the SDK automatically uses the refresh token to get a new one. All you have to do is configure and initialize the SDK, and you are ready to start making API calls using the different methods offered by our SDKs!

From the user’s perspective, it means:

They do not have to log in every time.
Their sessions are automatically renewed without interruption.
Token revocation can be done centrally.

From a developer’s perspective:

You can control how and where tokens are stored.
You have control to enforce policies like session timeouts or token cleanup.

Supported token persistence options

The Zoho CRM SDKs support three token persistence mechanisms:

File Persistence:

As we have already seen in last week's Kaizen, in this method, the tokens are stored in a local file of your choice. This can be configured while configuring and initializing the SDK. While this is simple and great for internal and local use, it might not always meet the needs of a growing business. For instance, if the file gets deleted or corrupted, you lose the tokens. It also poses a security risk, as storing tokens in files may expose them to unauthorised access if the file is not properly secured.

Database Persistence:

This stores tokens in a MySQL database, making it better suited for production environments. It is more robust and can handle larger-scale user management.

Using this persistence method, you can only provide the following connection parameters - host, DB name, table name, username, password, and port number.

Custom Persistence:

But what if neither of these options fits your needs? Maybe you are working in an environment without traditional storage like AWS's Secret Manager, or you prefer any other Database, or running a microservice in a container where local storage is more practical. That is where Custom Token Persistence comes in.

Custom Token Persistence

Custom persistence means you can implement your own logic for storing and retrieving OAuth tokens, instead of relying on the SDK’s default mechanism. To do this, you should create a class that implements the TokenStore interface and override a standard set of methods, each handling a specific part of the token lifecycle.

Here’s what your custom class must implement:

Method	Purpose	Return Type
find_token(self, token)	Given a token, return a full Token (OAuthToken) object from storage. Used before making any CRM API call.	Token(OAuthToken) object
save_token(self, token)	Called right after Zoho returns a new access/refresh token. Your implementation must persist it.	None
delete_token(self, id)	Delete a specific token using its unique ID.	None
get_tokens(self)	Return all stored tokens.	A list of Token(OAuthToken) objects
delete_tokens()	Delete all stored tokens. Useful during cleanup or logout.	None
find_token_by_id(id)	Retrieve a token by its unique identifier.	Token(OAuthToken) object

The token object is an instance of OAuthToken. The SDK will invoke these methods automatically as part of its flow. You just have to focus on where and how to store the tokens. With this, you can persist tokens to any storage as long as your class handles these methods correctly.

Understanding the token object

Before we dive deeper into custom token persistence, let's clarify what this token (OAuthToken) object is and how you should work with it.

The token object is an instance of OAuthToken. This class bundles all the credentials and details the SDK needs to authenticate your API requests. Here’s what it holds:

access_token
refresh_token
client_id
client_secret
redirect_url
expires_in
user_signature
id
api_domain

Implementing Custom Token Persistence with SQLite

Now that we've covered the basics of token persistence and how Zoho SDK supports custom stores, let’s dive into a practical, real-world example using SQLite as the backend for storing tokens.

SQLite is a lightweight, file-based database engine. It is perfect when you want a persistent store without the complexity of a full database server.

The CustomStoreSQLite Class

This class implements all six required methods of the TokenStore interface using SQLite as the backend.

1. Initialization and Table Setup

When you create a CustomStoreSQLite object, it immediately checks if the token table exists in the SQLite database file zohooauth.db. If the DB or the table is missing, its __init__() method creates one with all the necessary columns to store token details like id, user_name, client_id, client_secret, refresh_token, access_token, grant_token, expiry_time, redirect_url and api_domain.

def __init__(self):

"""

Initializes the SQLite database and sets up the oauthtoken table if needed.

"""

self.db_name = 'zohooauth.db'

if not self.check_table_exists():

connection = sqlite3.connect(self.db_name)

cursor = connection.cursor()

cursor.execute("CREATE TABLE oauthtoken (id varchar(10) NOT NULL,user_name varchar(255), client_id "

"varchar(255), client_secret varchar(255), refresh_token varchar(255), access_token "

"varchar(255), grant_token varchar(255), expiry_time varchar(20), redirect_url varchar("

"255), api_domain varchar(255), primary key (id))")

cursor.close()

This means the first time your app runs, it sets up its own database schema automatically.

2. Saving a Token - save_token(self, token)

Purpose:

This method is called every time Zoho returns a new token, whether after a login or a token refresh. Your implementation is responsible for safely persisting this token, typically by upserting (inserting or updating) a row in your database that uniquely identifies the token’s user and client combination.

Expected behaviour:

The method must store the token in your custom database or storage system.

If a matching token already exists (based on user, refresh token, or client credentials), it should be updated.
If no match exists, a new entry must be created.
Tokens should not be duplicated. Multiple users should be managed separately.

Input Parameters: An instance of Token(OAuthToken) class containing details like access token, refresh token, user signature, client ID/secret, etc.

Return value: None. But must raise exceptions on failure.

Sample Implementation using SQLite:

Here is the logic used in the implementation of save_token() method:

If the user name is available, use it to update the token.
If no user name but the access token is available in the table, update by the access token.
If there is a refresh or grant token with the same client credentials, then update accordingly.
If none of these match, insert as a new row.

def save_token(self, token):

if not isinstance(token, OAuthToken):

return

cursor = None

connection = None

try:

connection = sqlite3.connect(self.db_name)

oauth_token = token

query = "update oauthtoken set "

if oauth_token.get_user_signature() is not None:

name = oauth_token.get_user_signature().get_name()

if name is not None and len(name) > 0:

query = query + self.set_token(oauth_token) + " where user_name='" + name + "'"

elif oauth_token.get_access_token() is not None and len(oauth_token.get_access_token()) > 0 and \

self.are_all_objects_null([oauth_token.get_client_id(), oauth_token.get_client_secret()]):

query = query + self.set_token(

oauth_token) + " where access_token='" + oauth_token.get_access_token() + "'"

elif ((oauth_token.get_refresh_token() is not None and len(oauth_token.get_refresh_token()) > 0) or

(oauth_token.get_grant_token() is not None and len(

oauth_token.get_grant_token()) > 0)) and oauth_token.get_client_id() is not None \

and oauth_token.get_client_secret() is not None:

if oauth_token.get_grant_token() is not None and len(oauth_token.get_grant_token()) > 0:

query = query + self.set_token(

oauth_token) + " where grant_token='" + oauth_token.get_grant_token() + "'"

elif oauth_token.get_refresh_token() is not None and len(oauth_token.get_refresh_token()) > 0:

query = query + self.set_token(

oauth_token) + " where refresh_token='" + oauth_token.get_refresh_token() + "'"

query = query + " limit 1"

try:

cursor = connection.cursor()

cursor.execute(query)

if cursor.rowcount <= 0:

if oauth_token.get_id() is not None or oauth_token.get_user_signature() is not None:

if oauth_token.get_refresh_token() is None and oauth_token.get_grant_token() is None \

and oauth_token.get_access_token() is None:

raise SDKException(Constants.TOKEN_STORE, Constants.GET_TOKEN_DB_ERROR1)

if oauth_token.get_id() is None:

newId = str(self.generate_id())

oauth_token.set_id(newId)

query = "insert into oauthtoken (id,user_name,client_id,client_secret,refresh_token,access_token," \

"grant_token,expiry_time,redirect_url,api_domain) values (?,?,?,?,?,?,?,?,?,?);"

val = (token.get_id(),

token.get_user_signature().get_name() if token.get_user_signature() is not None else None,

token.get_client_id(), token.get_client_secret(), token.get_refresh_token(),

token.get_access_token(), token.get_grant_token(), token.get_expires_in(),

token.get_redirect_url(), token.get_api_domain())

cursor.execute(query, val)

except Error as e:

raise e

finally:

connection.commit()

cursor.close() if cursor is not None else None

connection.close() if connection is not None else None

except Exception as ex:

raise SDKException(Constants.TOKEN_STORE, Constants.SAVE_TOKEN_DB_ERROR, cause=ex)

3: Fetching a Token - find_token(self, token)

Purpose:

This is the method the SDK calls whenever it needs to make an API call on behalf of a user, but has only partial token information.

Depending on the token flow - Grant Token, Refresh Token, Access Token, or ID-based - only a specific token or ID may be provided during the API call. In such cases, find_token(self, token) method locates and return the complete OAuthToken object from storage if a matching one exists. If no matching token exists in the storage, this method will return None, and the SDK will proceed to generate a new token with the provided details and save it using the save_token(self, token) method.

Expected behavior:

Based on the available details in the input token (user name, access token, refresh or grant token), this method should query storage and return a complete token object.
If no match is found, it should return None.

Input Parameters: A partially filled Token(OAuthToken) object.

Return value: A fully populated Token object if found, or None.

Sample Implementation using SQLite:

The find_token(self, token) method implementation does the following:

Dynamically builds a WHERE clause based on available attributes.
Queries the database for a matching record.
Fetches the matching record, if any, and populates the Token object with the full set of stored values (access token, refresh token, expiry time, etc.).
Returns the Token object if a matching record is found, or return None.

Without this method, your app wouldn’t know which token to use during API calls. For example, consider the case when a user reopens your app after hours. You have their refresh token stored. The SDK calls find_token(self, token) to get the full token and proceeds without requiring a fresh login.

def find_token(self, token):

cursor = None

connection = None

try:

connection = sqlite3.connect(self.db_name)

if isinstance(token, OAuthToken):

oauth_token = token

query = "select * from oauthtoken"

if oauth_token.get_user_signature() is not None:

name = oauth_token.get_user_signature().get_name()

if name is not None and len(name) > 0:

query = query + " where user_name='" + name + "'"

elif oauth_token.get_access_token() is not None and self.are_all_objects_null(

[oauth_token.get_client_id(), oauth_token.get_client_secret()]):

query = query + " where access_token='" + oauth_token.get_access_token() + "'"

elif oauth_token.get_refresh_token() is not None or oauth_token.get_grant_token() is not None and \

oauth_token.get_client_id() is not None and oauth_token.get_client_secret() is not None:

if oauth_token.get_grant_token() is not None and len(oauth_token.get_grant_token()) > 0:

query = query + " where grant_token='" + oauth_token.get_grant_token() + "'"

elif oauth_token.get_refresh_token() is not None and len(oauth_token.get_refresh_token()) > 0:

query = query + " where refresh_token='" + oauth_token.get_refresh_token() + "'"

query = query + " limit 1"

cursor = connection.cursor()

cursor.execute(query)

result = cursor.fetchone()

if result is None:

return None

self.set_merge_data(oauth_token, result)

except Exception as ex:

raise SDKException(Constants.TOKEN_STORE, Constants.GET_TOKEN_DB_ERROR1, cause=ex)

finally:

cursor.close() if cursor is not None else None

connection.close() if connection is not None else None

return token

4: Deleting a Token - delete_token(self, id)

Purpose:

Delete a specific token record from storage based on a unique token ID. It is commonly used when a user logs out or an admin revokes access for a user.

Expected behaviour:

Locate the token record by its unique ID.
Delete the corresponding record from storage.

Input Parameters: The token ID to be deleted.

Return values: None

Sample Implementation using SQLite:

def delete_token(self, id):

cursor = None

try:

connection = sqlite3.connect(self.db_name)

try:

cursor = connection.cursor()

query = "delete from oauthtoken where id= " + id + ";"

cursor.execute(query)

connection.commit()

except Error as ex:

raise ex

finally:

cursor.close() if cursor is not None else None

connection.close() if connection is not None else None

except Error as ex:

raise SDKException(code=Constants.TOKEN_STORE, message=Constants.DELETE_TOKEN_DB_ERROR, cause=ex)

5: Deleting All Tokens - delete_tokens(self)

Purpose: Delete all tokens from storage, typically used for global logout or cleanup scenarios.

Expected behaviour: Remove all token records from storage in a single operation.

Input Parameters: None

Return Values: None

Sample Implementation using SQLite:

def delete_tokens(self):

cursor = None

try:

connection = sqlite3.connect(self.db_name)

try:

cursor = connection.cursor()

query = "delete from oauthtoken;"

cursor.execute(query)

self.connection.commit()

except Error as ex:

raise ex

finally:

cursor.close() if cursor is not None else None

connection.close() if connection is not None else None

except Error as ex:

raise SDKException(code=Constants.TOKEN_STORE, message=Constants.DELETE_TOKENS_DB_ERROR, cause=ex)

6: Fetch all tokens - get_tokens(self)

Purpose: Retrieve all currently stored tokens.

Expected behaviour:

Query storage for all token records.
Construct and return a list of token objects

Input Parameters: None

Return Value: A list of Token objects representing all stored tokens.

Sample Implementation using SQLite:

def get_tokens(self):

cursor = None

try:

connection = sqlite3.connect(self.db_name)

tokens = []

try:

cursor = connection.cursor()

query = "select * from oauthtoken;"

cursor.execute(query)

results = cursor.fetchall()

for result in results:

oauth_token = object.__new__(OAuthToken)

self.set_oauth_token(oauth_token)

self.set_merge_data(oauth_token, result)

tokens.append(oauth_token)

return tokens

except Error as ex:

raise ex

finally:

cursor.close() if cursor is not None else None

connection.close() if connection is not None else None

except Error as ex:

raise SDKException(code=Constants.TOKEN_STORE, message=Constants.GET_TOKENS_DB_ERROR, cause=ex)

7. Finding a Token by ID - find_token_by_id(self, id)

Purpose: Retrieve a specific token by its unique id.

Expected behaviour:

Search storage for a token with the given ID.
If found, return the complete token object; if not, return None.

Input Parameters: The unique identifier of the token (id)

Return Values: Returns a fully populated Token(OAuthToken) object if found; otherwise, returns None.

Sample Implementation using SQLite:

This method should follows a similar pattern to find_token, but use the unique id as the search key.

def find_token_by_id(self, id):

cursor = None

try:

connection = sqlite3.connect(self.db_name)

try:

query = "select * from oauthtoken where id='" + id + "'"

oauth_token = object.__new__(OAuthToken)

self.set_oauth_token(oauth_token)

cursor = connection.cursor()

cursor.execute(query)

results = cursor.fetchall()

if results is None or len(results) <= 0:

raise SDKException(Constants.TOKEN_STORE, Constants.GET_TOKEN_BY_ID_DB_ERROR)

for result in results:

self.set_merge_data(oauth_token, result)

return oauth_token

except Error as ex:

raise ex

finally:

cursor.close() if cursor is not None else None

connection.close() if connection is not None else None

except Error as ex:

raise SDKException(code=Constants.TOKEN_STORE, message=Constants.GET_TOKEN_BY_ID_DB_ERROR, cause=ex)

Please find the complete custom_store_sqlite.py file here.

How to use this in your project

To start using this custom token persistence class in your own Python project, follow these steps:

Download the custom_store_sqlite.py and place this inside your project directory.
Import the class in the script where you initialize the SDK. In our sample project, this is the record.py file.
from store.custom_store_sqlite import CustomStoreSQLite
In the SDK configuration, use the CustomStoreSQLite method instead of the FireStore method:

def init(self, client_id, code, location, redirect_url):

environment = DataCenter.get(location)

client_secret = "17565609051856218813123b9a98de52c301722b7d"

logger = Logger.get_instance(level=Logger.Levels.INFO,

file_path="./logs.txt")

store = CustomStoreSQLite()

token = OAuthToken(client_id=client_id,

client_secret=client_secret,

grant_token=code,

redirect_url=redirect_url)

Initializer.initialize(environment=environment,

token=token,

logger=logger,

store=store)

That’s it! With this, all token operations (save, fetch, delete) will be routed through your custom store backed by SQLite.

The above video demonstrates this is in action. You can see what the database looks like when populated.

More Custom Persistence Implementations

The advantage of using Zoho CRM SDKs is that it doesn't box you in. You are free to implement token persistence in a way that fits your business logic, team expertise, or project requirements. Whether you prefer SQLite, NoSQL, or something entirely different, the SDK gives you full control through the TokenStore interface.

In the SQLite example above, we walked through how to implement a custom store using a persistent file-based database. You need to implement all the methods as explained in the previous section, no matter where you decide to persist your tokens.

To make things easier, we have included two additional reference implementations:

An in-memory store, where tokens are stored in a dictionary
A list-based store, which keeps token records as simple lists

Each one fully implements the required methods of the TokenStore interface.

SQLite In-Memory DB

This implementation uses SQLite's in-memory mode (using ":memory:") to store tokens in RAM. Here, we have implemented all the required methods from the TokenStore interface: find_token(), save_token(), delete_token(), get_tokens(), delete_tokens() and find_token_by_id().

Please find the custom_store_in_memory.py file here.

List-Based Persistence Using Simple Lists

The second reference implementation is a list-based token store that keeps token records in an in-memory Python list of lists. Each inner list represents a token’s attributes, such as ID, user signature, client ID, access token, refresh token, and so on.

This custom store fully implements all required methods from the TokenStore interface.

Please find the custom_store_list.py file here.

We hope this was useful and gives you enough info to build your own token persistence methods tailored to your needs. We used Python SDK here, but you can apply the same logic with any of our other SDKs. It is all the same logic, just different programming languages. Just remember to implement the required methods exactly as expected by the SDK, as explained here.

Give it a try, and please let us know how it goes or if you hit any bumps! Comment below, or send an email to support@zohocrm.com. We will be waiting to hear from you!

Happy coding!

We are excited to be approaching the 200th post in our Kaizen series! As we get closer to this milestone, we would love to hear from you. Have questions, suggestions, or topics you would like us to cover in our future Kaizen posts? Your feedback helps us make the series even better.

Please take a moment to share your thoughts with us using this form - we'd really appreciate it!

Previous Kaizen: Kaizen #191 - Implementing "Login with Zoho" using Python SDK | Kaizen Directory

Download Links:

Sample project files

Further Reading:

Access your files securely from anywhere

Zoho FSM Video Tutorials

Workforce

Mobile App

Job Scenarios

Scheduled Maintenance

FSM × Desk

FSM × Books & Invoice

FSM × WhatsApp

MCP Tool Guide MCP Changelog

What's new

Blogs

Community

Zia

API resources

Pricing

Integrations

Town Hall

Custom Apps

Centralize Knowledge. Transform Learning.

All-in-one knowledge management and training platform for your employees and customers.

Access Zoho Learn

Quick Links

New to Zoho Recruit?

Access Zoho Recruit

New to Zoho Forms?

Latest Feature Updates

Explore our Pricing & Plans

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
Announcing the new SKILL.md for Zoho CRM and the updated OAS repository!
We are introducing a new zoho-crm skill to make working with Zoho CRM Developer tools (like APIs, functions, widgets, client scripts, queries etc) easier and faster, with the help of AI in your preferred AI harness like Claude Code, Codex, Cursor, VSCode
Kaizen #261 : Using Zoho CRM Skill to generate complex COQL queries
Hello everyone, In the previous Kaizen posts, we introduced the zoho-crm SKILL.md and discussed how it can help you when you are working with Zoho CRM APIs and Client Script. In this Kaizen, we will focus on using the Zoho CRM `SKILL.md` with GitHub Copilot
Kaizen #256 - Build an Arrival Readiness Web Tab in Zoho CRM
Hi everyone! Welcome back to the Kaizen series! In the post, we discuss a use case in hospitality industry: how an Arrival Readiness web tab widget can be used to let reception staff identify and resolve issues before arrival of guests. Use case In the
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.
Kaizen #226: Using ZRC in Client Script
Hello everyone! Welcome to another week of Kaizen. In today's post, lets see what is ZRC (Zoho Request Client) and how we can use ZRC methods in Client Script to get inputs from a Salesperson and update the Lead status with a single button click. In this

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 Billing 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

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
zoho stream web notifications
since im locked out of IMAP and cant use my mail app that lets my team collaborate and chat below emails, im trying out the zoho version of this... zoho streams. On the bottom of an email in the zoho mail web app, i "comment" and mention another user.
New in Zoho CRM: Pre-fill Public Forms with CRM Data
Public forms just got more flexible! With the new Pre-fill Public Forms with CRM Data option in the Zoho Forms integration, people filling out your public forms can search for a CRM record, select the right one, and have the form automatically populate
HEIC File Type Viewer
Hi, It would be nice to be able to click on the images in the All Entries/Reports Tables which are HEIC the same as JPG, PNG, etc. so they open in a viewer from Zoho or the Attachment Service, today HEIC requires you to download each image and open it
Zoho Books | Product updates | October 2026
Hello users, October brings a range of new features and enhancements to Zoho Books, designed to simplify compliance, streamline accounting workflows, and improve inventory management. From the launch of the Nigeria Edition and France’s e-invoicing capabilities
Specific ListView Canvas on Canvas Home Page Always Loads Most Recent ListView, Not the One Specified
I had mentioned this to ZOHO, but I mainly wanted to see if others in the Community are also facing this problem. I created a Canvas ListView for a Custom Module, and then created a Canvas Home page (technically on a tab item, but I'm not sure if that
print preview
We are using microsoft edge, till 12 sep we were getting directly print option. Now we are getting this preview option we have to click print option again. How to bypass this-preview option?
Zoho Projects - Has something changed regarding to linking Projects and Deals via the API?
I am trying to link Zoho Projects to Deals in CRM using the API, but each time, the Deal Contact is added as a Client user and receives an email invite asking them to join the organisation. These are internal projects and the customer should not have
Connection into Cliq?
I have the SalesIQ chat widget on my site using the Zohobot but I'm not always on and my employees don't keep it open all the time. We do have Cliq open all the time though so I'd love a way to manage those discussions directly in Cliq as they come in.
Kaizen #264 - Using zoho-crm Skill to Write Functions
Hello CRM wizards, Welcome back to another week of Kaizen. In our previous Kaizens, we explored how the zoho-crm skill can assist you across various Zoho CRM developer tools. This time, let us see how it can help you write Deluge Functions, from simple
Edit Pinned Comments in Zoho Desk
It's great that private comments can now be pinned to the top of the ticket but what would be extremely helpful would be to allow for the pinned comment to be edited vs. having to find the comment in the ticket to edit it.
Recover accidentally deleted mail account
Email account was accidentally deleted from admin console.
mail sent to gmail goes directly to spam
Hi TKIM and SPF are configured and verified. E-mails coming from zoho to my personal gmail account are going directly to the spam folder. How can I solve this? I can send you guys the headers privately if you need to.
Shopify Integration: How do I change the default Unit of Measure from KG to PCS
For those using Shopify with Zoho Inventory, has anyone managed to have imported items default to PCS/EA instead of KG? If so, where is this configured? I can only find weight units in Shopify, not a sales unit of measure.
flexible subscription plan
Greetings! We currently have 5 Standard plans, but would like to add 5 mail-lite one just to receive emails (do not need other business features or storage. As Super Admin, I tried to do that my self but didnt see the option on your sales platform. Please
mail
We want our tracked links in campaign and journey emails to use our own domain instead of the shared maillist-manage.net domain. We have already created the CNAME links.rexven.com → customer-campaign.zoho.com (DNS only). Does our plan support a custom
Useless support and impossible to add users for whom I paid for
Over a week ago i signed up for 5 emails addresses and 10GB, and so far I only have 1 email working, no access to the dashboard. Remote connection with "support"....useless Screen grabs sent to "support" useless Messages to "support"... now not answering
Mr
can't access my email
Reduce Mail Lite Renewal from 2 licenses to 1
Hello Zoho Support, I have a Mail Lite 5GB subscription with 2 licenses. have deleted the unused user, and now only 1 user/license is being used. My subscription is due for renewal, but the renewal page still shows 2 licenses and does not give me an option
Adding additional records dynamically to a subset of fields
I'm trying to create a service ticket layout which will be passed to a Creator application for Field Service Management (FSM) purposes. We need to be able to define a specific subset of service product fields such as "Service Product", "Service Product Serial Number", "Service Product Warranty End Date" and "Service Product Current Warranty Status". We may need to record more than one of these subsets, in case the customer has more than one product which has to be serviced on their site. It seems
Push error with Zoho Books and Zoho CRM
I have successfully linked Books and CRM but I have some push errors with the following message: "The customer associated to this record is not linked to module chosen in the current contact sync configuration." I am unable to work this out, could you help please.
Function #24: Automatically display deal name from Zoho CRM on quotes in Zoho Books
Deals allow businesses to organize and visualize their sales pipeline. This provides a clear overview of all potential opportunities and helps in making informed decisions. Zoho CRM empowers you to create deals or potentials for your clients and monitor
{"code":57,"message":"You are not authorized to perform this operation"}
In my trial version of Zoho account, I am trying to integrate Zoho CRM Contact Module with Zoho books but when i call API it gives such type of error {"code":57,"message":"You are not authorized to perform this operation"}. I am using refreshed token
Allow widgets to be placed between native sections in the Ticket Properties panel
One of our biggest frustrations with the Tickets module is how rigid the Ticket Properties panel is. Every section there is built only from native Zoho Desk fields. We can add sections, rearrange fields, and pick layouts, but we can’t put anything custom
#13 Understanding Your Zoho Invoice Limits
Ravi's busiest month was also the month his invoicing stopped working. He had been using Zoho Invoice comfortably for months. Then, just when business picked up, he hit a limit he hadn't expected. The problem wasn't that he had missed a payment or forgotten
Map Dependency Upgrades in Zoho CRM
Map Dependency Fields enhancements are now available across all DCs. Hello everyone, We’ve introduced a set of enhancements to Map Dependency Fields to make setup simpler, faster, and more intuitive. Map Dependency helps control how values appear across
How to Allocate Incoming Purchase Stock to Specific Sales Orders in Zoho Inventory?
Hi all, We are using Zoho One Enterprise and need guidance on managing sales order–wise allocation of incoming stock in Zoho Inventory. Our workflow is: A customer order is received, and the Sales Order is confirmed. The sales team immediately creates
How to disable automatic ticket closure emails for specific outgoing communications?
Is there a way to disable the automatic "Ticket Closed" email notification for specific tickets or outgoing emails? Currently, every time we send an email to a customer, the system automatically sends a "Ticket Created" email, followed by a "Ticket Closed"
Zoho Webinar - Sharing System Audio (NOT AVAILABLE)
Hi, We are having a serious problem with Zoho Webinar. In the webinars we run, we very often share the audio from a video we are streaming directly from YouTube or other applications. Until recently we were using Zoom, but as we use other Zoho applications
What's new in Zoho Workplace | September 2026
Hello Zoho Workplace community! Here's a roundup of all the new features and announcements that went live across Zoho Workplace applications in September. Zoho Mail Compose Options Across Templates You can now use the Undo, Redo, and New List options
Unable to export reports despite enabled report export permissions
Hi Zoho Community, We are unable to export reports in Zoho CRM. When attempting an export, we receive the following error: “Cannot Export Report — You do not have permission to export one or more modules used in this report. Please contact your administrator.”
What does "Tickets for Review" do?
What is the purpose of the va nilla view " Tickets for Review?"
Set department automatically for incoming calls
Is it possible, when receiving an incoming call through Zoho Desk (using Twilio integration), for the department to be auto-selected based on the phone line being called? Currently, we have to manually select the department from the dropdown menu when
Zoho Desk training for administrators in EU and US region
Hello Everyone, Get ready for the certified Virtual Classroom training for our Zoho Desk users in Europe and the US. Our in-house Zoho Desk expert, @Dheeraj | Zoho Desk, will conduct the virtual classroom training. This training focuses on simplifying
Support Plan: Recuring Issue
Hi Zoho Team, Could you please look into this recurring alert and provide clarification on why this restriction is still in place? This issue has become a bottleneck in our workflow, significantly limiting our automation capabilities. We are unable to
Webinar de Zoho People: tecnología para RR. HH.
¿Y si RR. HH. pudiera estar tan conectado con el negocio como el resto de tu organización? La gestión de personas está evolucionando, y los departamentos de Recursos Humanos necesitan herramientas que les permitan ir más allá de las tareas administrativas
Zoho CRM still doesn't let you manage timezones (yearly reminder)
This is something I have asked repeatedly. I'll ask once again. Suppose that you work in France. Next month you have a trip to Guatemala. You call a contact there, close a meeting, record that meeting in CRM. On the phone, your contact said: "meet me
WhatsApp in Zoho CRM Plus: inbound works, every outbound message fails with crm.bm.msg.failed.undefined since Oct 14 (business stopped)
Hello Zoho team and community, We are Roxo Inc, a Zoho CRM Plus customer in Florida. WhatsApp is our main sales and support channel, and since October 14, 11:11 AM EDT we cannot send any WhatsApp message from Zoho CRM. We are facing a large drop in sales
Pushover Notification Module
Hello, it would be good if there would be a "Pushover" (https://pushover.net/) module besides the standard SMS module. Pushover is now very well known, especially in IT, and is becoming more and more popular. The biggest advantage are the customizable
Problem in Mannual journal in Zoho Books
When I Put Manual Journal in Zoho Books Software not allow me to select VAT Rate what is the solution United kindgom version
Zoho CRM's WhatsApp integration now supports multiple accounts, multiple numbers, and custom modules
Hello all, WhatsApp Business now comes with a few exciting enhancements. So far, WhatsApp integration has worked with a single account and a single mobile number. As reliance on the WhatsApp integration has grown, along with the need for multiple accounts
Next Page

Kaizen #192 - Implementing Custom Token Persistence in Python SDK

Kaizen #192 - Implementing Custom Token Persistence in Python SDK

Why does token persistence matter?

Supported token persistence options

File Persistence:

Database Persistence:

Custom Persistence:

Custom Token Persistence

Understanding the token object

Implementing Custom Token Persistence with SQLite

The CustomStoreSQLite Class

1. Initialization and Table Setup

2. Saving a Token - save_token(self, token)

3: Fetching a Token - find_token(self, token)

4: Deleting a Token - delete_token(self, id)

5: Deleting All Tokens - delete_tokens(self)

6: Fetch all tokens - get_tokens(self)

7. Finding a Token by ID - find_token_by_id(self, id)

How to use this in your project

More Custom Persistence Implementations

SQLite In-Memory DB

List-Based Persistence Using Simple Lists

Access your files securely from anywhere

Zoho FSM Video Tutorials

Zoho Developer Community

France ZUGs

Topic Participants

Anu Abraham

Sticky Posts

Announcing the new SKILL.md for Zoho CRM and the updated OAS repository!

Kaizen #261 : Using Zoho CRM Skill to generate complex COQL queries

Kaizen #256 - Build an Arrival Readiness Web Tab in Zoho CRM

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

Kaizen #226: Using ZRC in Client Script

Zoho TeamInbox Resources

Zoho CRM Plus Resources

Zoho Books Resources

Zoho Billing 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

zoho stream web notifications

New in Zoho CRM: Pre-fill Public Forms with CRM Data

HEIC File Type Viewer

Zoho Books | Product updates | October 2026

Specific ListView Canvas on Canvas Home Page Always Loads Most Recent ListView, Not the One Specified

print preview

Zoho Projects - Has something changed regarding to linking Projects and Deals via the API?

Connection into Cliq?

Kaizen #264 - Using zoho-crm Skill to Write Functions

Edit Pinned Comments in Zoho Desk

Recover accidentally deleted mail account

mail sent to gmail goes directly to spam

Shopify Integration: How do I change the default Unit of Measure from KG to PCS

flexible subscription plan

mail

Useless support and impossible to add users for whom I paid for

Mr

Reduce Mail Lite Renewal from 2 licenses to 1

Adding additional records dynamically to a subset of fields

Push error with Zoho Books and Zoho CRM

Function #24: Automatically display deal name from Zoho CRM on quotes in Zoho Books

{"code":57,"message":"You are not authorized to perform this operation"}

Allow widgets to be placed between native sections in the Ticket Properties panel

#13 Understanding Your Zoho Invoice Limits

Map Dependency Upgrades in Zoho CRM

How to Allocate Incoming Purchase Stock to Specific Sales Orders in Zoho Inventory?

How to disable automatic ticket closure emails for specific outgoing communications?

Zoho Webinar - Sharing System Audio (NOT AVAILABLE)

What's new in Zoho Workplace | September 2026

Unable to export reports despite enabled report export permissions

What does "Tickets for Review" do?

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