Monday Connector Reference

4 metrics112 dimensions

The Monday connector exposes 116 fields (4 metrics, 112 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Monday Fields

Monday activity_logs fields

The activity_logs report of the Monday connector includes 8 fields.

ID Type Name Description
activity_logs__board_id TEXT activity_logs.board_id activity_logs.board_id
activity_logs__created_at TEXT activity_logs.created_at activity_logs.created_at
activity_logs__created_at_int NUMERIC activity_logs.created_at_int activity_logs.created_at_int
activity_logs__data TEXT activity_logs.data activity_logs.data
activity_logs__entity TEXT activity_logs.entity activity_logs.entity
activity_logs__event TEXT activity_logs.event activity_logs.event
activity_logs__id TEXT activity_logs.id activity_logs.id
activity_logs__pulse_id TEXT activity_logs.pulse_id activity_logs.pulse_id

Monday boards fields

The boards report of the Monday connector includes 20 fields.

ID Type Name Description
boards__board_kind TEXT boards.board_kind boards.board_kind
boards__columns OBJECT boards.columns boards.columns
boards__communication TEXT boards.communication boards.communication
boards__creator OBJECT boards.creator boards.creator
boards__description TEXT boards.description boards.description
boards__groups OBJECT boards.groups boards.groups
boards__id TEXT boards.id boards.id
boards__name TEXT boards.name boards.name
boards__owners OBJECT boards.owners boards.owners
boards__permissions TEXT boards.permissions boards.permissions
boards__state TEXT boards.state boards.state
boards__subscribers OBJECT boards.subscribers boards.subscribers
boards__tags OBJECT boards.tags boards.tags
boards__top_group OBJECT boards.top_group boards.top_group
boards__type TEXT boards.type boards.type
boards__updated_at TEXT boards.updated_at boards.updated_at
boards__updated_at_int NUMERIC boards.updated_at_int boards.updated_at_int
boards__updates OBJECT boards.updates boards.updates
boards__views OBJECT boards.views boards.views
boards__workspace OBJECT boards.workspace boards.workspace

Monday General fields

The General report of the Monday connector includes 3 fields.

ID Type Name Description
account_id TEXT Account ID The unique identifier for the account.
account_name TEXT Account Name The name of the account.
date DATE Date The date of the record.

Monday items fields

The items report of the Monday connector includes 14 fields.

ID Type Name Description
items__assets OBJECT items.assets items.assets
items__board OBJECT items.board items.board
items__column_values OBJECT items.column_values items.column_values
items__created_at TIMESTAMP items.created_at items.created_at
items__creator_id TEXT items.creator_id items.creator_id
items__group OBJECT items.group items.group
items__id TEXT items.id items.id
items__name TEXT items.name items.name
items__parent_item OBJECT items.parent_item items.parent_item
items__state TEXT items.state items.state
items__subscribers OBJECT items.subscribers items.subscribers
items__updated_at TIMESTAMP items.updated_at items.updated_at
items__updated_at_int NUMERIC items.updated_at_int items.updated_at_int
items__updates OBJECT items.updates items.updates

Monday tags fields

The tags report of the Monday connector includes 3 fields.

ID Type Name Description
tags__color TEXT tags.color tags.color
tags__id TEXT tags.id tags.id
tags__name TEXT tags.name tags.name

Monday teams fields

The teams report of the Monday connector includes 4 fields.

ID Type Name Description
teams__id TEXT teams.id teams.id
teams__name TEXT teams.name teams.name
teams__picture_url TEXT teams.picture_url teams.picture_url
teams__users OBJECT teams.users teams.users

Monday updates fields

The updates report of the Monday connector includes 9 fields.

ID Type Name Description
updates__assets OBJECT updates.assets updates.assets
updates__body TEXT updates.body updates.body
updates__created_at TEXT updates.created_at updates.created_at
updates__creator_id TEXT updates.creator_id updates.creator_id
updates__id TEXT updates.id updates.id
updates__item_id TEXT updates.item_id updates.item_id
updates__replies OBJECT updates.replies updates.replies
updates__text_body TEXT updates.text_body updates.text_body
updates__updated_at TEXT updates.updated_at updates.updated_at

Monday users fields

The users report of the Monday connector includes 25 fields.

ID Type Name Description
users__birthday TEXT users.birthday users.birthday
users__country_code COUNTRY users.country_code users.country_code
users__created_at TEXT users.created_at users.created_at
users__email TEXT users.email users.email
users__enabled BOOLEAN users.enabled users.enabled
users__id TEXT users.id users.id
users__is_admin BOOLEAN users.is_admin users.is_admin
users__is_guest BOOLEAN users.is_guest users.is_guest
users__is_pending BOOLEAN users.is_pending users.is_pending
users__is_verified BOOLEAN users.is_verified users.is_verified
users__is_view_only BOOLEAN users.is_view_only users.is_view_only
users__join_date DATE users.join_date users.join_date
users__location TEXT users.location users.location
users__mobile_phone TEXT users.mobile_phone users.mobile_phone
users__name TEXT users.name users.name
users__phone TEXT users.phone users.phone
users__photo_original TEXT users.photo_original users.photo_original
users__photo_small TEXT users.photo_small users.photo_small
users__photo_thumb TEXT users.photo_thumb users.photo_thumb
users__photo_thumb_small TEXT users.photo_thumb_small users.photo_thumb_small
users__photo_tiny TEXT users.photo_tiny users.photo_tiny
users__time_zone_identifier TEXT users.time_zone_identifier users.time_zone_identifier
users__title TEXT users.title users.title
users__url TEXT users.url users.url
users__utc_hours_diff NUMERIC users.utc_hours_diff users.utc_hours_diff

Monday workspaces fields

The workspaces report of the Monday connector includes 12 fields.

ID Type Name Description
workspaces__account_product OBJECT workspaces.account_product workspaces.account_product
workspaces__created_at TEXT workspaces.created_at workspaces.created_at
workspaces__description TEXT workspaces.description workspaces.description
workspaces__id TEXT workspaces.id workspaces.id
workspaces__kind TEXT workspaces.kind workspaces.kind
workspaces__name TEXT workspaces.name workspaces.name
workspaces__owners_subscribers OBJECT workspaces.owners_subscribers workspaces.owners_subscribers
workspaces__settings OBJECT workspaces.settings workspaces.settings
workspaces__state TEXT workspaces.state workspaces.state
workspaces__team_owners_subscribers OBJECT workspaces.team_owners_subscribers workspaces.team_owners_subscribers
workspaces__teams_subscribers OBJECT workspaces.teams_subscribers workspaces.teams_subscribers
workspaces__users_subscribers OBJECT workspaces.users_subscribers workspaces.users_subscribers

Monday other fields

The Monday connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20