Connect to Zoho CRM using Python

You can connect to Zoho CRM from Python using Devart ODBC Driver for Zoho CRM.

Install the pyodbc library

To install the pyodbc library, run the following command:

pip install pyodbc

Define a connection string

An ODBC connection requires a connection string, which can either use a predefined DSN or be specified through connection string parameters (a DSN-less connection).

For information about available parameters, see Connection string parameters.

DSN connection string

You can use a connection string with a predefined DSN.

connectionString = "DSN=your_dsn"

If you need credentials other than those used in the DSN, specify them in the connection string to override the DSN values.

connectionString = "DSN=your_dsn;User ID=your_username;Password=your_password"

For information on configuring a DSN on Windows, see Windows DSN configuration.

DSN-less connection string

You can establish a connection without a DSN by specifying all necessary parameters directly in the connection string.

The following example uses OAuth 2.0 authentication.

connectionString = "DRIVER=Devart ODBC Driver for Zoho CRM;Domain=crm.zoho.com;Refresh Token=your_refresh_token"

For more information, see DSN-less connections.

Connect to Zoho CRM

The following Python code demonstrates how to connect to Zoho CRM and fetch data using the ODBC driver.

# Import the pyodbc library for ODBC connections
import pyodbc

# Define an ODBC connection string
connectionString = "your_connection_string"

connection = pyodbc.connect(connectionString)

# Create an object to interact with a data source
cursor = connection.cursor()

# Execute a SQL query
query = "SELECT Id, First_Name FROM Contacts"
cursor.execute(query)

# Fetch and print the query results
print("Query results:")
for row in cursor.fetchall():
    # Output each tuple of the query results to the console
    print(row)

# Close the cursor and the connection
cursor.close()
connection.close()