Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for Zoho CRM

Python Connector for Zoho CRM is a connectivity solution for accessing Zoho CRM from Python applications to read and update data. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows and Windows Server.

Standard SQL syntax

The connector fully supports the ANSI SQL standard and lets you execute SQL statements against your Zoho CRM data just like you would normally work with relational databases. Simple queries are directly converted to Zoho CRM API calls and executed on the Zoho CRM side. Complex queries are transformed into simpler queries, which are then converted to Zoho CRM API calls. The embedded SQL engine then processes the results in the local cache and applies advanced SQL features from the original complex query.

Using the connector

To retrieve data from a database:

Import the module.

import devart.zohocrm

Connect to a database using the connect() module method and obtain a connection object: If you have a refresh token:

my_connection = devart.zohocrm.connect(
    Domain="your_zoho_domain",
    RefreshToken="your_refresh_token"
)

If you don't have a refresh token:

response = devart.zohocrm.signin(Domain="your_zoho_domain")
my_connection = devart.zohocrm.connect(
    Domain="your_zoho_domain",
    RefreshToken=response["Refresh Token"]
)

Create a cursor object using the cursor() connection method.

my_cursor = my_connection.cursor()

Execute the SQL statement using the execute() cursor method.

my_cursor.execute("SELECT * FROM employees")

Retrieve the result set using one of the fetch*() cursor methods.

for row in my_cursor.fetchall(): 
    print(row)

Ordering and activating the license

You can purchase a license for the connector on the ordering page:
https://www.devart.com/python/zohocrm/ordering.html

To activate the license, follow the instructions in the documentation:
https://docs.devart.com/python/zohocrm/activate-a-license.htm

What's new

Python Connector for Zoho CRM 1.2

  • Added support for Python 3.13
  • Added support for Canadian data center

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

devart_zohocrm_connector-1.2.0-cp313-cp313-win_amd64.whl (5.9 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_zohocrm_connector-1.2.0-cp313-cp313-win32.whl (5.7 MB view details)

Uploaded CPython 3.13 Windows x86

devart_zohocrm_connector-1.2.0-cp312-cp312-win_amd64.whl (5.9 MB view details)

Uploaded CPython 3.12 Windows x86-64

devart_zohocrm_connector-1.2.0-cp312-cp312-win32.whl (5.7 MB view details)

Uploaded CPython 3.12 Windows x86

devart_zohocrm_connector-1.2.0-cp311-cp311-win_amd64.whl (5.9 MB view details)

Uploaded CPython 3.11 Windows x86-64

devart_zohocrm_connector-1.2.0-cp311-cp311-win32.whl (5.7 MB view details)

Uploaded CPython 3.11 Windows x86

devart_zohocrm_connector-1.2.0-cp310-cp310-win_amd64.whl (5.9 MB view details)

Uploaded CPython 3.10 Windows x86-64

devart_zohocrm_connector-1.2.0-cp310-cp310-win32.whl (5.7 MB view details)

Uploaded CPython 3.10 Windows x86

devart_zohocrm_connector-1.2.0-cp39-cp39-win_amd64.whl (5.9 MB view details)

Uploaded CPython 3.9 Windows x86-64

devart_zohocrm_connector-1.2.0-cp39-cp39-win32.whl (5.7 MB view details)

Uploaded CPython 3.9 Windows x86

devart_zohocrm_connector-1.2.0-cp38-cp38-win_amd64.whl (5.9 MB view details)

Uploaded CPython 3.8 Windows x86-64

devart_zohocrm_connector-1.2.0-cp38-cp38-win32.whl (5.7 MB view details)

Uploaded CPython 3.8 Windows x86

devart_zohocrm_connector-1.2.0-cp37-cp37m-win_amd64.whl (5.9 MB view details)

Uploaded CPython 3.7m Windows x86-64

devart_zohocrm_connector-1.2.0-cp37-cp37m-win32.whl (5.7 MB view details)

Uploaded CPython 3.7m Windows x86

File details

Details for the file devart_zohocrm_connector-1.2.0-cp313-cp313-win_amd64.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 52cfacef8c32934f69140683c0ce3ae5df179f225ebb6481ac5d33659ba9820c
MD5 a5faabae4b3e3cf815a2315542470d4a
BLAKE2b-256 08b3b1afe8bdf17bb2244b8e784f042868fc41af11cb975887ae93788e74f786

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp313-cp313-win32.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 84105de0a04368e6bab902e036725bdd8b29bba0680d308ec68337460dd7d30b
MD5 a16885adc355b0fe2b30757be331a795
BLAKE2b-256 b18368fb309472b91076932c3c2875021ad0ea4d506211bcf353d6c03df04b27

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp312-cp312-win_amd64.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 0bdefeaebd3e0200d3744f9ef3640ecbde822be9f81b40ccdecd0c3fc85eda5c
MD5 3373f12bdbac5d3f8e39e2df73574b95
BLAKE2b-256 d2805c938c657533c7ac5df8c8f852176968b21e4e354243c4828eed54bb80c9

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp312-cp312-win32.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 398d58ae7e3b6358cbe4d098e7cd58e17d744030515188849f7ad8acb3a7a21c
MD5 6180fbfa13434423406de01ae0e1ff67
BLAKE2b-256 7e2e4dadea7cd5ab4494f45daa6037bbddf3c511a9f3813989c339922f4c242c

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 bce7ba31af323069348f7b16f0c9fdbb77c136ca7df044bef02fd835f6e819f4
MD5 8afe8baa6d45e225a215e1d240caab9a
BLAKE2b-256 a82b34fc50cbb46d8aafe40224c5183fd50ae43c90de1ea161c17b4c582015cb

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp311-cp311-win32.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 3d46a66dd2ac81e4e8caa19bf7f202cc3faf93cf69c0e09b7ffecf825029653f
MD5 fe538bfcf635452940c8551d83190f6e
BLAKE2b-256 1858d6b782e2504712c32afd6c7a034fa52682dd848215345c46ada322be9305

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 fe54108b69fffba73f54c3676c9daf97343700b489d8b667574823a0c12d7847
MD5 5da1a3283ad9b28ce649165784b41df9
BLAKE2b-256 e956db5870fafa3f622a6ec021a80d71ce6559d1650d00d2a2fa26c56d039afe

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp310-cp310-win32.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 c8310f541471132656a27f123ca4b09339db83e5d9a5369dd0267da185672f3e
MD5 96e51b73c2577ac5f7548ad8c40cb0c5
BLAKE2b-256 b787636bd3628dd8ef95b26d77cc76a9feedca002d1fb5cc4a54d8902017d747

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 6cf7da57c944387caf0fae1ad83d9879533604d8c4c84d112b2762b7c7c916eb
MD5 7cb50b6adee143a85ea0b8ebf97f9e17
BLAKE2b-256 048218c22d730053054170fae823178c06140161753b72ad358368d90873daca

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp39-cp39-win32.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 e0d928b38e697048dbb90e913f8010875cbd9ec6d596c3ac340c278da00ebe10
MD5 026a607f0af01ce0646d902f5f2be894
BLAKE2b-256 c08dedad4680f89bf0e847774f447df5e0c267cba404dcc6675454048e3a6b40

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 671074f5cafd269c236639a8415bef69a59450a2d65ab2e5afee58e270d613e4
MD5 624bbc07fe98bd6645e0e5acabed9a8e
BLAKE2b-256 cead262bd3aa0dc8e178a1ef489d2c97909c6ea79d2d8629cbeb6b825762d527

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp38-cp38-win32.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 bed8df2ac40acf85024e1c813dbfe5ee37cb53b283df2dd418dc3b6962418018
MD5 a60cc24c5a952bc9ad0b062292562be8
BLAKE2b-256 cefa0aed4061c576cb14d872fb18f23d657b40ede76ae8fa229312cd41cf00b2

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp37-cp37m-win_amd64.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 8523fe6244e7d1b70bd57923103914faf09199ad1d07edf48bf0cbc59fef6721
MD5 09da44aa91172f73b76cce6af3da6eff
BLAKE2b-256 d0880ce638f230f9727166a64e6a25e7e088e80c9de84c7836bb33ee6da8dbc1

See more details on using hashes here.

File details

Details for the file devart_zohocrm_connector-1.2.0-cp37-cp37m-win32.whl.

File metadata

File hashes

Hashes for devart_zohocrm_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 de66fc53741df029e78ea8dbb3c177d4d1c64e28fffced36ac73e9f848df2039
MD5 117edc6b23da63a8b84df44fcdf1762b
BLAKE2b-256 8c227665ed7c9126be5181cff217a361871bdcdf59bda7db7c6dc8dd6ea069cd

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page