Windsor brings all your Monday data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Monday Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| activity_logs__board_id | NUMERIC | activity_logs.board_id | activity_logs.board_id | activity_logs |
| activity_logs__created_at | TEXT | activity_logs.created_at | activity_logs.created_at | activity_logs |
| activity_logs__created_at_int | NUMERIC | activity_logs.created_at_int | activity_logs.created_at_int | activity_logs |
| activity_logs__data | TEXT | activity_logs.data | activity_logs.data | activity_logs |
| activity_logs__entity | TEXT | activity_logs.entity | activity_logs.entity | activity_logs |
| activity_logs__event | TEXT | activity_logs.event | activity_logs.event | activity_logs |
| activity_logs__id | TEXT | activity_logs.id | activity_logs.id | activity_logs |
| activity_logs__pulse_id | NUMERIC | activity_logs.pulse_id | activity_logs.pulse_id | activity_logs |
| boards__board_kind | TEXT | boards.board_kind | boards.board_kind | boards |
| boards__columns | OBJECT | boards.columns | boards.columns | boards |
| boards__communication | TEXT | boards.communication | boards.communication | boards |
| boards__creator | OBJECT | boards.creator | boards.creator | boards |
| boards__description | TEXT | boards.description | boards.description | boards |
| boards__groups | OBJECT | boards.groups | boards.groups | boards |
| boards__id | TEXT | boards.id | boards.id | boards |
| boards__name | TEXT | boards.name | boards.name | boards |
| boards__owners | OBJECT | boards.owners | boards.owners | boards |
| boards__permissions | TEXT | boards.permissions | boards.permissions | boards |
| boards__state | TEXT | boards.state | boards.state | boards |
| boards__subscribers | OBJECT | boards.subscribers | boards.subscribers | boards |
| boards__tags | OBJECT | boards.tags | boards.tags | boards |
| boards__top_group | OBJECT | boards.top_group | boards.top_group | boards |
| boards__type | TEXT | boards.type | boards.type | boards |
| boards__updated_at | TEXT | boards.updated_at | boards.updated_at | boards |
| boards__updated_at_int | NUMERIC | boards.updated_at_int | boards.updated_at_int | boards |
| boards__updates | OBJECT | boards.updates | boards.updates | boards |
| boards__views | OBJECT | boards.views | boards.views | boards |
| boards__workspace | OBJECT | boards.workspace | boards.workspace | boards |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| items__assets | OBJECT | items.assets | items.assets | items |
| items__board | OBJECT | items.board | items.board | items |
| items__column_values | OBJECT | items.column_values | items.column_values | items |
| items__created_at | TEXT | items.created_at | items.created_at | items |
| items__creator_id | TEXT | items.creator_id | items.creator_id | items |
| items__group | OBJECT | items.group | items.group | items |
| items__id | TEXT | items.id | items.id | items |
| items__name | TEXT | items.name | items.name | items |
| items__parent_item | OBJECT | items.parent_item | items.parent_item | items |
| items__state | TEXT | items.state | items.state | items |
| items__subscribers | OBJECT | items.subscribers | items.subscribers | items |
| items__updated_at | TEXT | items.updated_at | items.updated_at | items |
| items__updated_at_int | NUMERIC | items.updated_at_int | items.updated_at_int | items |
| items__updates | OBJECT | items.updates | items.updates | items |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| tags__color | TEXT | tags.color | tags.color | tags |
| tags__id | TEXT | tags.id | tags.id | tags |
| tags__name | TEXT | tags.name | tags.name | tags |
| teams__id | NUMERIC | teams.id | teams.id | teams |
| teams__name | TEXT | teams.name | teams.name | teams |
| teams__picture_url | TEXT | teams.picture_url | teams.picture_url | teams |
| teams__users | OBJECT | teams.users | teams.users | teams |
| today | DATE | Today | Today's date | |
| updates__assets | OBJECT | updates.assets | updates.assets | updates |
| updates__body | TEXT | updates.body | updates.body | updates |
| updates__created_at | TEXT | updates.created_at | updates.created_at | updates |
| updates__creator_id | TEXT | updates.creator_id | updates.creator_id | updates |
| updates__id | TEXT | updates.id | updates.id | updates |
| updates__item_id | TEXT | updates.item_id | updates.item_id | updates |
| updates__replies | OBJECT | updates.replies | updates.replies | updates |
| updates__text_body | TEXT | updates.text_body | updates.text_body | updates |
| updates__updated_at | TEXT | updates.updated_at | updates.updated_at | updates |
| users__birthday | TEXT | users.birthday | users.birthday | users |
| users__country_code | TEXT | users.country_code | users.country_code | users |
| users__created_at | TEXT | users.created_at | users.created_at | users |
| users__email | TEXT | users.email | users.email | users |
| users__enabled | BOOLEAN | users.enabled | users.enabled | users |
| users__id | TEXT | users.id | users.id | users |
| users__is_admin | BOOLEAN | users.is_admin | users.is_admin | users |
| users__is_guest | BOOLEAN | users.is_guest | users.is_guest | users |
| users__is_pending | BOOLEAN | users.is_pending | users.is_pending | users |
| users__is_verified | BOOLEAN | users.is_verified | users.is_verified | users |
| users__is_view_only | BOOLEAN | users.is_view_only | users.is_view_only | users |
| users__join_date | TEXT | users.join_date | users.join_date | users |
| users__location | TEXT | users.location | users.location | users |
| users__mobile_phone | TEXT | users.mobile_phone | users.mobile_phone | users |
| users__name | TEXT | users.name | users.name | users |
| users__phone | TEXT | users.phone | users.phone | users |
| users__photo_original | TEXT | users.photo_original | users.photo_original | users |
| users__photo_small | TEXT | users.photo_small | users.photo_small | users |
| users__photo_thumb | TEXT | users.photo_thumb | users.photo_thumb | users |
| users__photo_thumb_small | TEXT | users.photo_thumb_small | users.photo_thumb_small | users |
| users__photo_tiny | TEXT | users.photo_tiny | users.photo_tiny | users |
| users__time_zone_identifier | TEXT | users.time_zone_identifier | users.time_zone_identifier | users |
| users__title | TEXT | users.title | users.title | users |
| users__url | TEXT | users.url | users.url | users |
| users__utc_hours_diff | NUMERIC | users.utc_hours_diff | users.utc_hours_diff | users |
| workspaces__account_product | OBJECT | workspaces.account_product | workspaces.account_product | workspaces |
| workspaces__created_at | TEXT | workspaces.created_at | workspaces.created_at | workspaces |
| workspaces__description | TEXT | workspaces.description | workspaces.description | workspaces |
| workspaces__id | TEXT | workspaces.id | workspaces.id | workspaces |
| workspaces__kind | TEXT | workspaces.kind | workspaces.kind | workspaces |
| workspaces__name | TEXT | workspaces.name | workspaces.name | workspaces |
| workspaces__owners_subscribers | OBJECT | workspaces.owners_subscribers | workspaces.owners_subscribers | workspaces |
| workspaces__settings | OBJECT | workspaces.settings | workspaces.settings | workspaces |
| workspaces__state | TEXT | workspaces.state | workspaces.state | workspaces |
| workspaces__team_owners_subscribers | OBJECT | workspaces.team_owners_subscribers | workspaces.team_owners_subscribers | workspaces |
| workspaces__teams_subscribers | OBJECT | workspaces.teams_subscribers | workspaces.teams_subscribers | workspaces |
| workspaces__users_subscribers | OBJECT | workspaces.users_subscribers | workspaces.users_subscribers | workspaces |