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

Quick Links

New to Zoho Recruit?

Access Zoho Recruit

New to Zoho Forms?

Latest Feature Updates

Explore our Pricing & Plans

Zoho Campaigns Resources

Campaigns Community Learning Series

Zoho Developer Community

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

New to Zoho Desk?

Access Zoho Desk

What's New in Zoho Desk

Use cases

Make the most of Zoho Desk with the use cases.

Learn More

eBooks

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

Download eBooks

Videos

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

Watch Now

Webinar

What's New in Zoho Desk

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

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
Anu Abraham
Ashley

Sticky Posts
Kaizen #197: Frequently Asked Questions on GraphQL APIs
🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
Kaizen #198: Using Client Script for Custom Validation in Blueprint
Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
Celebrating 200 posts of Kaizen! Share your ideas for the milestone post
Hello Developers, We launched the Kaizen series in 2019 to share helpful content to support your Zoho CRM development journey. Staying true to its spirit—Kaizen Series: Continuous Improvement for Developer Experience—we've shared everything from FAQs
Kaizen #193: Creating different fields in Zoho CRM through API
🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
Client Script | Update - Introducing Commands in Client Script!
Have you ever wished you could trigger Client Script from contexts other than just the supported pages and events? Have you ever wanted to leverage the advantage of Client Script at your finger tip? Discover the power of Client Script - Commands! Commands

New to Zoho Social?

Manage your brands on social media

Access Zoho Social

Zoho Pagesense Resources

New to Zoho TeamInbox?

Zoho TeamInbox Resources

Zoho DataPrep Resources

New to Zoho DataPrep?

Access Zoho DataPrep

Zoho CRM Plus Resources

Zoho Books Resources

Zoho Subscriptions Resources

Zoho Projects Resources

Zoho Sprints Resources

Qntrl Resources

Zoho Creator Resources

Zoho CRM Resources

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

Design. Discuss. Deliver.

Create visually engaging stories with Zoho Show.

Get Started Now

Zoho Show Resources

Writer

Get Started. Write Away!

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

Start Writing

Zoho CRM コンテンツ

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

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

Nederlandse Hulpbronnen

ご検討中の方

Recent Topics
Zoho Desk Integration - Add the option to send the estimate from the Zoho Desk Ticket Integration
Hi, Currently in the Zoho Desk integration, the user is able to create an estimate from a ticket, once the estimate is created the user can see the estimate under the ticket (see screenshot below), but is not able to send that estimate from Zoho Desk.
Zoho Creator to Zoho CRM Images
Right now, I am trying to setup a Notes form within Zoho Creator. This Notes will note the Note section under Accounts > Selected Account. Right now, I use Zoho Flow to push the notes and it works just fine, with text only. Images do not get sent (there
Utilisation de Zoho en conformité avec l’article 286 du Code général des impôts (CGI)
Cher(e) client(e), Conformément à l’article 286 du Code général des impôts (CGI) impose aux entreprises assujetties à la TVA d’utiliser des systèmes de caisse ou de gestion commerciale certifiés lorsqu’elles enregistrent des ventes à des particuliers.
Issue showing too many consultations in my workspace link.
Hi Team, I’ve set up two Workspaces to track meetings from different sources. So far, this has been working well, and the two Workspaces are differentiated without any issues. However, when I navigate to Consultations and share the link to my personal
Zoho Books - France
L’équipe de Zoho France reçoit régulièrement des questions sur la conformité de ses applications de finances (Zoho Books/ Zoho Invoice) pour le marché français. Voici quelques points pour clarifier la question : Zoho Books est un logiciel de comptabilité
Zoho CRM Plain Text Template: Line Breaks and Formatting Issue
Hello, I'm following the instructions to create email templates in Zoho CRM, but I'm having a problem with the plain text version. https://help.zoho.com/portal/en/kb/zoho-sign/integrations/zoho-apps/zoho-crm/articles/zoho-crm-email-templates#Steps_to_create_a_custom_email_template
Signature field is showing black
Hello, When customer signed the service form, it is showing as below picture Phone model: iPhone 16 Pro We tried delete and install application, but it not solved. This has on phone of a few person. There is any advice to solve this?
Introducing Profile Summary: Faster Candidate Insights with Zia
We’re excited to launch Profile Summary, a powerful new feature in Zoho Recruit that transforms how you review candidate profiles. What used to take minutes of resume scanning can now be assessed in seconds—thanks to Zia. A Quick Example Say you’re hiring
Zoho MCP has no tools for Creator or 3rd Party Apps?
I don't see a Zoho MCP community forum so putting this here. Two big problems I see: 1) Although Zoho advertises "over 950 3rd party apps" as available through their MCP, when I go to "Add Tools" there are ZERO 3rd party apps available to choose from.
👋 Welcome to the Zoho MCP Community
Hello all, glad to have you here! This is your space for everything AI agents, MCP tools, and intelligent business apps. This community is for you — developers, partners, creators, and businesses exploring how agents can transform work. Whether you’re
CRM Validation Rules Support Only Single Condition
Simply put, CRM validation rules support only a single condition for each field on "All Records". You also cannot specify additional validation rules on the same field because it has already been used in an existing validation rule. The ONLY solution
Strategic Idea: A Unified and Interactive Employee Lifecycle Dashboard
Hello Zoho Community and Team, I am proposing a powerful, high-level feature that could transform the HRMS from a system of record into a truly strategic talent management platform: A Unified Employee Lifecycle Dashboard. The Problem: Currently, employee
Maximum file limit in zoho people LMS
Dear Team, I am having approximately 4.9 GB of material, including PPTs and videos for uploading in zoho people LMS course. May I know what is the maximum limit limit for the course files Thanking you, With regards, Logeswar V Executive _ Operations
Unapproved Leaves are hard to distinguish in Attendance View
This is a an unapproved leave request It appears in the Attendance view without any visual indicator if its approved or not For a whole day request this might be manageable but for hourly requests it gets very hard to know which are approved, which are
Performance Appraisal Probation Period
Hello All, Is there any possible way to create an appraisal cycle for new staff members, at the end of probation period? Many thanks!
Zoho Creatorの一括操作における処理の同期/非同期について
現在、Creatorのレポート機能を利用して、複数のレコードに対して一括で処理を実行しようとしていますが、処理の実行順序について確認したいことがあります。レポート内の複数レコードに一括で処理を実行した際、処理は同期的に行われるのでしょうか？それとも非同期的に行われるのでしょうか？【同期処理の場合】レコード①に対する処理が開始され、終了後にレコード②に対する処理が開始され、最後にレコード③に対する処理が実行されるように、処理が順番に行われる場合。【非同期処理の場合】レコード①、レコード②、レコード③の処理が一斉に開始され、それぞれ並行して処理が行われ、全処理が終了する場合。
Control who sees Timeline and Interactions in Zoho CRM through Profiles
The feature has been enabled for all DCs (except US, EU, and IN DCs). We will be rolling it out to the other DCs in the upcoming days. Dear All, In a CRM, not all users would require access to the history of a record. For instance, a Marketing Operations
Adding Chargebee as a Data Connector
Is it possible to get Chargebee added as a Zoho Analytics data connector?
Need Easy Way to Update Item Prices in Bulk
Hello Everyone, In Zoho Books, updating selling prices is taking too much time. Right now we have to either edit items one by one or do Excel export/import. It will be very useful if Zoho gives a simple option to: Select multiple items and update prices
Search Records returning different values than actually present
Hey! I have this following line in my deluge script: accountSearch = zoho.crm.searchRecords("Accounts","(RS_Enroll_ID:equals:" + rsid + ")",1,200,{"cvid":864868001088693817}); info "Account search size: " + accountSearch.size(); listOfAccounts = zoho.crm.searchRecords("Accounts","(RS_Enroll_ID:equals:"
Delete commerce website
I need to delete a commerce website, but the only option is to click on settings, REQUEST DELETE, choose an urgency notice, add a message....AND THEN nothing, no way to send the request. Why is nothing simple!?!?! I just want to delete the store. The
Adding external users to Zoho Social under Zoho ONE licence - how to best achieve this
My client has a small business, and we are looking to implementing Zoho ONE with a single flexible user licence as that is all they really need and offers the best pricing for the range of modules we eventually wish to set them up with, one of which will
Has anyone built a custom AI support agent inside Zoho (SalesIQ/Zobot)?
Hi all, I’ve been experimenting with building my own AI support assistant and wanted to see if anyone here has tackled something similar within Zoho. Right now, I’ve set up a Retrieval-Augmented Generation (RAG) pipeline outside of Zoho using FAISS. It
Whats the Time out Limit for API Calls from Deluge?
Hi Creator Devs, We are making API calls to third party server via Deluge. Getting this error message: Error at line : 24, The task has been terminated since the API call is taking too long to respond. Please try again after sometime. Whats the default
Can't create package until Bill created?
I can't understand why we cannot create a package until a Bill is created? We are having to created draft Bills to create a package when the item is received, but we may not have received a Bill from the supplier. Also, Bill # is required, but we normally
This mobile number has been marked spam. Please contact support.
Problem Description: One of our sales agents in our organization is unable to sign in to Zoho Mail. When attempting to log in, the following message appears: This mobile number has been marked as spam. Please contact support at as@zohocorp.com @zohocorp
Print checks for owner's draw
Hi. Can I use Zoho check printing for draws to Owner's Equity? This may be a specific case of the missing Pay expenses via Check feature. If it's not available, are there plans to add this feature?
Dynamically prefill ticket fields
Hello, I am using Zoho Desk to collect tickets of our clients about orders they placed on our website. I would like to be able to prefill two tickets fields dynamically, in this case a readonly field for the order id, and a hidden field for the seller id. The clients access the ticket form by clicking a link in our customer area, so ideally I would like to pass the values to prefill with as part of the URL. I imagine that this could be along the lines of calling https://our-domain/portal/newticket?order_id=123&seller_id=456
Zoho Desk Partners with Microsoft's M365 Copilot for seamless customer service experiences
Hello Zoho Desk users, We are happy to announce that Zoho Desk has partnered with Microsoft's M365 to empower customer service teams with enhanced capabilities and seamless experiences for agents. Microsoft announced their partnership during their keynote
Zoho Books - Show Related Sales Orders on Quotes
Hi Books team, I've noticed that the Quotes don't show show the related Sales Order. My feature request is to also show related Sales Orders above the Quote so it's easy to follow the thread of records in the sales and fulfilment process. Below screenshot
Zoho Books - Hide Convert to Sales Order if it can't be used.
Hi Books team, I noticed that it is not possible to convert a Quote to a Sales Order when a Quote is not yet marked as accepted. My idea is to not show the Convert to Sales Order button when it is not possible to use it, or show it in a grey inactive
What’s New in Zoho Inventory | April 2025
Hello users, April has been a big month in Zoho Inventory! We’ve rolled out powerful new features to help you streamline production, optimise stock management, and tailor your workflows. While several updates bring helpful enhancements, three major additions
Copy a Record Template from one Form to another
I have a Creator application with several forms. I developed a record template for one of the reports/forms but want to use most of it for another of the form/report combinations in the application. Is there a way to copy the template (code or otherwise) to another form?
Zoho Books - Quotes to Sales Order Automation
Hi Books team, In the Quote settings there is an option to convert a Quote to an Invoice upon acceptance, but there is not feature to convert a Quote to a Sales Order (see screenshot below) For users selling products through Zoho Inventory, the workflow
Zoho Books - Include Quote Status in Workflow Field Triggers
Hi Zoho Books team, I recently tried to create a Workflow rule based on when a Quote is Accepted by the customer. This is something which I thought would be very easy to do, however I discovered that Status is not listed as a field which can be monitored
When Zoho Tables Beta will be open to EU data center
Hello all, We in EU are looking at you all using and testing and are getting jealous :) When we will be able to get into the beta also? We don't mind testing and playing with beta software. Thank you!
Pass current date to a field using Zoho Flow
I am trying to generate an invoice automatically once somebody submits a record in Zoho CRM. I get an error in the invoice date. I have entered {{zoho.currentdate}} in the Date field. When I test the flow, I get "Zoho Books says "Invalid value passed
API: Mark Sales Order as Open + Custom Status
Hi, it's possible to create Custom Status (sub-status actually) states for the Sales Order. So you have Open, Void. Then under Open you can have Open, and create one called Order Paid, Order Shipped, etc etc...which is grouped under Open. I can use the
Zoho Quartz Screen Recording
Hello, can we get access to Quartz, please, as a standalone solution? It would be great for creating training videos for current and future staff on how to use Zoho software according to our company requirements. Thank you
Please add an “Auto-Apply Unused Credits” toggle
Hello — please add a simple org-level option to automatically apply unused credits (credit notes, excess payments, retainers) to new invoices and/or bills. An ON/OFF toggle with choices “invoices”, “bills”, or “both” would save lots of manual work for
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 Developer Community

Use cases

eBooks

Videos

Webinar

France ZUGs

Topic Participants

Anu Abraham

Ashley

Sticky Posts

Kaizen #197: Frequently Asked Questions on GraphQL APIs

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

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

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

Client Script | Update - Introducing Commands in Client Script!

Zoho TeamInbox Resources

Zoho CRM Plus Resources

Zoho Books Resources

Zoho Subscriptions Resources

Zoho Projects Resources

Zoho Sprints Resources

Qntrl Resources

Zoho Creator Resources

Zoho CRM Resources

Zoho Show Resources

Get Started. Write Away!

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

Nederlandse Hulpbronnen

ご検討中の方

Recent Topics

Zoho Desk Integration - Add the option to send the estimate from the Zoho Desk Ticket Integration

Zoho Creator to Zoho CRM Images

Utilisation de Zoho en conformité avec l’article 286 du Code général des impôts (CGI)

Issue showing too many consultations in my workspace link.

Zoho Books - France

Zoho CRM Plain Text Template: Line Breaks and Formatting Issue

Signature field is showing black

Introducing Profile Summary: Faster Candidate Insights with Zia

Zoho MCP has no tools for Creator or 3rd Party Apps?

👋 Welcome to the Zoho MCP Community

CRM Validation Rules Support Only Single Condition

Strategic Idea: A Unified and Interactive Employee Lifecycle Dashboard

Maximum file limit in zoho people LMS

Unapproved Leaves are hard to distinguish in Attendance View

Performance Appraisal Probation Period

Zoho Creatorの一括操作における処理の同期/非同期について

Control who sees Timeline and Interactions in Zoho CRM through Profiles

Adding Chargebee as a Data Connector

Need Easy Way to Update Item Prices in Bulk

Search Records returning different values than actually present

Delete commerce website

Adding external users to Zoho Social under Zoho ONE licence - how to best achieve this

Has anyone built a custom AI support agent inside Zoho (SalesIQ/Zobot)?

Whats the Time out Limit for API Calls from Deluge?

Can't create package until Bill created?

This mobile number has been marked spam. Please contact support.

Print checks for owner's draw

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