How to Use Monday API to Set up Integrations and Workflows

1. Log in to your monday.com account.
2. Click on your avatar in the bottom left corner, and select "Admin" from the dropdown menu.
3. In the Admin section, click on "API" in the left sidebar.
4. Click the "Generate" button to create a new API key.
5. Copy the generated API key and store it safely, as you will not be able to see it again.

monday.com uses GraphQL, a query language for APIs. You'll interact with the API by sending requests with GraphQL queries or mutations. Queries are used to fetch data, while mutations are used to modify data.

To install GraphQL for Python, you will need the graphene package. It provides an easy way to define GraphQL schemas and execute queries in Python. Here's how to install it:

3.1 Make sure you have Python installed on your system. If not, download it from the official website: https://www.python.org/downloads/

3.2 Open a terminal or command prompt on your computer.

3.3 (Optional) Create a virtual environment to isolate your project dependencies. This is a good practice to avoid potential conflicts with other Python projects. To create a virtual environment, execute the following commands:

python -m venv myenv

Replace "myenv" with your desired environment name.

Now, activate the virtual environment:

On Windows:

myenv\Scripts\activate

On macOS/Linux:

source myenv/bin/activate

3.4 Install the "gql" library by running the following command:

pip install gql

Create a new Python file and import the necessary modules:

import os from gql import gql, Client from gql.transport.requests import RequestsHTTPTransport

Set up the GraphQL client with your API key:

api_key = "your_api_key_here" # Replace with your actual API key url = "https://api.monday.com/v2" transport = RequestsHTTPTransport(url=url, headers={"Authorization": api_key}, use_json=True) client = Client(transport=transport, fetch_schema_from_transport=True)

Create a function that fetches all boards and their names:

def get_all_boards(): query = gql( """ query { boards { id name } } """ ) result = client.execute(query) return result["boards"]

Call the function and print the results:

boards = get_all_boards() print(boards)

To create a custom workflow, first identify the specific actions you want to automate. For example, you can create a workflow that:

1. Creates a new board when a specific condition is met.
2. Adds a new group to the board with a specified name.
3. Adds an item to the group with specific column values.

Create functions for adding a group to a board and adding an item to a group:

def create_group(board_id, group_name): mutation = gql( """ mutation($board_id: Int!, $group_name: String!) { create_group(board_id: $board_id, group_name: $group_name) { id title } } """ ) result = client.execute(mutation, variable_values={"board_id": board_id, "group_name": group_name}) return result["create_group"] def create_item(board_id, group_id, item_name, column_values): mutation = gql( """ mutation($board_id: Int!, $group_id: String!, $item_name: String!, $column_values: JSON!) { create_item(board_id: $board_id, group_id: $group_id, item_name: $item_name, column_values: $column_values) { id name } } """ ) result = client.execute(mutation, variable_values={"board_id": board_id, "group_id": group_id, "item_name": item_name, "column_values": column_values}) return result["create_item"]

Create a function that implements the custom workflow:

def custom_workflow(): # Step 1: Create a new board board = create_board("My Custom Workflow Board") board_id = board["id"] # Step 2: Add a new group to the board group = create_group(board_id, "My Group") group_id = group["id"] # Step 3: Add an item to the group item_name = "My Item" column_values = '{"status": {"label": "Done"}}' # Replace with desired column values item = create_item(board_id, group_id, item_name, column_values) print("Custom workflow complete!")

Call the custom workflow function:

custom_workflow()