Using the CData ODBC Driver for Monday.com in PyCharm

The CData ODBC Drivers can be used in any environment that supports loading an ODBC Driver. In this tutorial we will explore using the CData ODBC Driver for Monday.com from within PyCharm. Included are steps for adding the CData ODBC Driver as a data source, as well as basic PyCharm code to query the data source and display results.

To begin, this tutorial will assume that you have already installed the CData ODBC Driver for Monday.com as well as PyCharm.

Add Pyodbc to the Project

Follow the steps below to add the pyodbc module to your project.

1. Click File -> Settings to open the project settings window.
2. Click Project Interpreter from the Project: YourProjectName menu.
3. To add pyodbc, click the + button and enter pyodbc.
4. Click Install Package to install pyodbc.

Connect to Monday.com

You can now connect with an ODBC connection string or a DSN. See the Getting Started section in the CData driver documentation for a guide to creating a DSN on your OS.

You can connect to Monday.com using either API Token authentication or OAuth authentication.

Connecting with an API Token

Connect to Monday.com by specifying the APIToken. Set the AuthScheme to Token and obtain the APIToken as follows:

• API tokens for admin users
  1. Log in to your Monday.com account and click on your avatar in the bottom left corner.
  2. Select Admin.
  3. Select "API" on the left side of the Admin page.
  4. Click the "Copy" button to copy the user's API token.
• API tokens for non-admin users
  1. Click on your profile picture in the bottom left of your screen.
  2. Select "Developers"
  3. Click "Developer" and then "My Access Tokens" at the top.
  4. Select "Show" next to the API token, where you'll be able to copy it.

Connecting with OAuth Authentication

Alternatively, you can establish a connection using OAuth (refer to the OAuth section of the Help documentation).

Below is the syntax for a DSN:

[CData Monday Source]
Driver = CData ODBC Driver for Monday.com
Description = My Description
APIToken = eyJhbGciOiJIUzI1NiJ9.yJ0aWQiOjE0MTc4NzIxMiwidWlkIjoyNzI3ODM3OSwiaWFkIjoiMjAyMi0wMS0yMFQxMDo0NjoxMy45NDFaIiwicGV

Execute SQL to Monday.com

Instantiate a Cursor and use the execute method of the Cursor class to execute any SQL statement.

import pyodbc

cnxn = pyodbc.connect('DRIVER={CData ODBC Driver for Monday};APIToken = eyJhbGciOiJIUzI1NiJ9.yJ0aWQiOjE0MTc4NzIxMiwidWlkIjoyNzI3ODM3OSwiaWFkIjoiMjAyMi0wMS0yMFQxMDo0NjoxMy45NDFaIiwicGV;')
cursor = cnxn.cursor()
cursor.execute("SELECT Id, DueDate FROM Invoices WHERE Status = 'SENT'")
rows = cursor.fetchall()
for row in rows:
 print(row.Id, row.DueDate)

After connecting to Monday.com in PyCharm using the CData ODBC Driver, you will be able to build Python apps with access to Monday.com data as if it were a standard database. If you have any questions, comments, or feedback regarding this tutorial, please contact us at [email protected].