Monday

Availability: Airbyte Cloud: ✅, Airbyte OSS: ✅
Support Level: Certified
Latest Version: 1.1.3
Definition Id: 80a54ea2-9959-4040-aac1-eee42423ec9b

Prerequisites

• Monday API Token / Monday Access Token

You can find your Oauth application in Monday main page -> Profile picture (bottom left corner) -> Developers -> My Apps -> Select your app.

You can get the API token for Monday by going to Profile picture (bottom left corner) -> Admin -> API.

Setup guide

1. Log into your Airbyte Cloud account.
2. In the left navigation bar, click Sources. In the top-right corner, click +new source.
3. On the Set up the source page, enter the name for the Monday connector and select Monday from the Source type dropdown.
4. Fill in your API Key or authenticate using OAuth and then click Set up source.

Connect using OAuth 2.0 option:

1. Select OAuth2.0 in Authorization Method.
2. Click on authenticate your Monday account.
3. Proceed the authentication using your credentials for your Monday account.

Connect using API Token option:

1. Generate an API Token as described here.
2. Use the generated api_token in the Airbyte connection.

Supported sync modes

The Monday supports full refresh syncs

Feature	Supported?
Full Refresh Sync	Yes
Incremental Sync	Yes
SSL connection	No
Namespaces	No

Supported Streams

Several output streams are available from this source:

• Activity logs
• Items
• Boards
• Teams
• Updates
• Users
• Tags
• Workspaces

Important Notes:

• Columns are available from the Boards stream. By syncing the Boards stream you will get the Columns for each Board synced in the database The typical name of the table depends on the destination you use like boards.columns, for instance.

• Column Values are available from the Items stream. By syncing the Items stream you will get the Column Values for each Item (row) of the board. The typical name of the table depends on the destination you use like items.column_values, for instance. If there are more endpoints you'd like Airbyte to support, please create an issue.

• Incremental sync for Items and Boards streams is done using the Activity logs stream. Ids of boards and items are extracted from activity logs events and used to selectively sync boards and items. Some data may be lost if the time between incremental syncs is longer than the activity logs retention time for your plan. Check your Monday plan at https://monday.com/pricing.

Performance considerations

The Monday connector should not run into Monday API limitations under normal usage. Please create an issue if you see any rate limit issues that are not automatically retried successfully.

Changelog

Version	Date	Pull Request	Subject
1.1.3	2023-09-23	30248	Add new field "type" to board stream
1.1.2	2023-08-23	29777	Add retry for 502 error
1.1.1	2023-08-15	29429	Ignore null records in response
1.1.0	2023-07-05	27944	Add incremental sync for Items and Boards streams
1.0.0	2023-06-20	27410	Add new streams: Tags, Workspaces. Add new fields for existing streams.
0.2.6	2023-06-12	27244	Added http error handling for 403 and 500 HTTP errors
0.2.5	2023-05-22	225881	Fix pagination for the items stream
0.2.4	2023-04-26	25277	Increase row limit to 100
0.2.3	2023-03-06	23231	Publish using low-code CDK Beta version
0.2.2	2023-01-04	20996	Fix json schema loader
0.2.1	2022-12-15	20533	Bump CDK version
0.2.0	2022-12-13	19586	Migrate to low-code
0.1.4	2022-06-06	14443	Increase retry_factor for Items stream
0.1.3	2021-12-23	8172	Add oauth2.0 support
0.1.2	2021-12-07	8429	Update titles and descriptions
0.1.1	2021-11-18	8016	🐛 Source Monday: fix pagination and schema bug
0.1.0	2021-11-07	7168	🎉 New Source: Monday