Monday
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.
Tables in the Monday connector
Table: teams
| No | Column Name | Type | Notes |
|---|
| 1 | picture_url | VARCHAR | |
| 2 | name | VARCHAR | |
| 3 | id | INTEGER | Primary Key |
| 4 | users | VARCHAR | |
Table: boards
| No | Column Name | Type | Notes |
|---|
| 1 | owner | VARCHAR | |
| 2 | workspace | VARCHAR | |
| 3 | columns | VARCHAR | |
| 4 | subscribers | VARCHAR | |
| 5 | description | VARCHAR | |
| 6 | groups | VARCHAR | |
| 7 | top_group | VARCHAR | |
| 8 | updates | VARCHAR | |
| 9 | tags | VARCHAR | |
| 10 | updated_at | VARCHAR | |
| 11 | pos | VARCHAR | |
| 12 | permissions | VARCHAR | |
| 13 | name | VARCHAR | |
| 14 | id | VARCHAR | Primary Key |
| 15 | state | VARCHAR | |
| 16 | communication | VARCHAR | |
| 17 | board_kind | VARCHAR | |
| 18 | views | VARCHAR | |
Table: updates
| No | Column Name | Type | Notes |
|---|
| 1 | assets | VARCHAR | |
| 2 | replies | VARCHAR | |
| 3 | updated_at | VARCHAR | |
| 4 | item_id | VARCHAR | |
| 5 | creator_id | VARCHAR | |
| 6 | created_at | VARCHAR | |
| 7 | id | VARCHAR | Primary Key |
| 8 | text_body | VARCHAR | |
| 9 | body | VARCHAR | |
Table: items
| No | Column Name | Type | Notes |
|---|
| 1 | subscribers | VARCHAR | |
| 2 | created_at | VARCHAR | |
| 3 | updates | VARCHAR | |
| 4 | assets | VARCHAR | |
| 5 | column_values | VARCHAR | |
| 6 | updated_at | VARCHAR | |
| 7 | parent_item | VARCHAR | |
| 8 | creator_id | VARCHAR | |
| 9 | name | VARCHAR | |
| 10 | id | VARCHAR | Primary Key |
| 11 | state | VARCHAR | |
| 12 | board | VARCHAR | |
| 13 | group | VARCHAR | |
Table: users
| No | Column Name | Type | Notes |
|---|
| 1 | birthday | VARCHAR | |
| 2 | is_guest | BOOLEAN | |
| 3 | photo_thumb_small | VARCHAR | |
| 4 | created_at | VARCHAR | |
| 5 | title | VARCHAR | |
| 6 | enabled | BOOLEAN | |
| 7 | is_admin | BOOLEAN | |
| 8 | photo_tiny | VARCHAR | |
| 9 | photo_thumb | VARCHAR | |
| 10 | time_zone_identifier | VARCHAR | |
| 11 | mobile_phone | VARCHAR | |
| 12 | utc_hours_diff | INTEGER | |
| 13 | id | INTEGER | Primary Key |
| 14 | email | VARCHAR | |
| 15 | is_view_only | BOOLEAN | |
| 16 | photo_original | VARCHAR | |
| 17 | join_date | VARCHAR | |
| 18 | photo_small | VARCHAR | |
| 19 | is_verified | BOOLEAN | |
| 20 | url | VARCHAR | |
| 21 | country_code | VARCHAR | |
| 22 | phone | VARCHAR | |
| 23 | name | VARCHAR | |
| 24 | location | VARCHAR | |
| 25 | is_pending | BOOLEAN | |
External Resources
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.