Skip to content

Monday.com

Monday.com is a Work OS that powers teams to run projects and workflows with confidence. It's a simple, yet powerful platform that enables people to manage work, meet deadlines, and build a culture of transparency.

URI format

The URI format for Monday.com is as follows:

monday://?api_token=<api_token>

URI parameters:

  • api_token is your Monday.com API token for authentication.

Setting up a Monday.com Integration

You can obtain an API token from the Monday.com Developer Console. For more information, see Monday.com authentication documentation.

To get your API token:

  1. Go to your Monday.com account
  2. Click on your profile picture in the top right corner
  3. Select "Admin" → "API"
  4. Generate a new API token

Example

Let's say you want to ingest all boards into a DuckDB database called monday.db. For this example the value of api_token will be fake_token.

You can run the following to achieve this:

sh
ingestr ingest \
  --source-uri "monday://?api_token=fake_token" \
  --source-table "boards" \
  --dest-uri "duckdb://./monday.db" \
  --dest-table "public.boards"

Tables

Monday.com source allows ingesting the following resources into separate tables:

TablePrimary/Merge KeyInc KeyInc StrategyDetails
account--replaceAccount information including name, slug, tier, and plan details. Full reload on each run.
account_roles--replaceAccount roles with their types and permissions. Full reload on each run.
users--replaceUsers in your Monday.com account with their profiles and permissions. Full reload on each run.
boardsidupdated_atmergeBoards with their metadata, state, and configuration. Incrementally loads only updated boards.
workspaces--replaceWorkspaces containing boards and their settings. Full reload on each run.
webhooks--replaceWebhooks configured for boards with their events and configurations. Full reload on each run.
updatesidupdated_atmergeUpdates (comments) on items with their content and metadata. Incrementally loads only updated entries.
teams--replaceTeams in your account with their members. Full reload on each run.
tags--replaceTags used across your account for organizing items. Full reload on each run.
custom_activities--replaceCustom activity types defined in your account. Full reload on each run.
board_columns--replaceColumns defined in all boards with their types and settings. Full reload on each run.
board_views--replaceViews configured for boards with their filters and settings. Full reload on each run.

Use these as --source-table parameter in the ingestr ingest command.

NOTE

Monday.com has rate limits for API requests. The source handles pagination automatically and respects the API's maximum page size of 100 items.