Monday
This page contains the setup guide and reference information for the Monday source connector.
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
- Log into your Airbyte Cloud account.
- In the left navigation bar, click Sources. In the top-right corner, click +new source.
- On the Set up the source page, enter the name for the Monday connector and select Monday from the Source type dropdown.
- Fill in your API Key or authenticate using OAuth and then click Set up source.
Connect using OAuth 2.0
option
- Select
OAuth2.0
inAuthorization Method
. - Click on
authenticate your Monday account
. - Proceed with the authentication using the credentials for your Monday account.
Connect using API Token
option
- Generate an API Token as described here.
- Use the generated
api_token
in the Airbyte connection.
Supported sync modes
The Monday source connector supports the following features:
Feature | Supported? |
---|---|
Full Refresh Sync | Yes |
Incremental Sync | Yes |
SSL connection | No |
Namespaces | No |
Supported Streams
Several output streams are available from this source:
Important Notes:
-
Columns
are available from theBoards
stream. By syncing theBoards
stream you will get theColumns
for eachBoard
synced in the database The typical name of the table depends on thedestination
you use likeboards.columns
, for instance. -
Column Values
are available from theItems
stream. By syncing theItems
stream you will get theColumn Values
for eachItem
(row) of the board. The typical name of the table depends on thedestination
you use likeitems.column_values
, for instance. If there are more endpoints you'd like Airbyte to support, please create an issue. -
Incremental sync for
Items
andBoards
streams is done using theActivity 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.
Reference
Config fields reference
Changelog
Expand to review
Version | Date | Pull Request | Subject |
---|---|---|---|
2.1.6 | 2024-12-19 | 49943 | Pin CDK constraint to avoid breaking change in newer versions |
2.1.5 | 2024-10-31 | 48054 | Moved to DeclarativeOAuthFlow specification |
2.1.4 | 2024-08-17 | 44201 | Add boards name to the items stream |
2.1.3 | 2024-06-04 | 38958 | [autopull] Upgrade base image to v1.2.1 |
2.1.2 | 2024-04-30 | 37722 | Fetch display_value field for column values of Mirror , Dependency and Connect Board types |
2.1.1 | 2024-04-05 | 36717 | Add handling of complexityBudgetExhausted error. |
2.1.0 | 2024-04-03 | 36746 | Pin airbyte-cdk version to ^0 |
2.0.4 | 2024-02-28 | 35696 | Fix extraction for null value in stream Activity logs |
2.0.3 | 2024-02-21 | 35506 | Support for column values of the mirror type for the Items stream. |
2.0.2 | 2024-02-12 | 35146 | Manage dependencies with Poetry. |
2.0.1 | 2024-02-08 | 35016 | Migrated to the latest airbyte cdk |
2.0.0 | 2024-01-12 | 34108 | Migrated to the latest API version: 2024-01 |
1.1.4 | 2023-12-13 | 33448 | Increase test coverage and migrate to base image |
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 |