Monday Tables

The Monday integration uses the following tables

Tables

MondayAccountProducts

Stores monday.com account product records representing the specific products (e.g., "core", "crm", "service") enabled on a monday.com account, including their default workspace assignment.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
ProductIDstringUnique identifier of the account product (e.g., core, crm, project_management, service).
MondayAccountIDstringIdentifier of the monday.com account this product is associated with.
KindstringProduct kind classification indicating the type of monday.com product (e.g., core, crm, marketing, software, service, whiteboard).
DefaultWorkspaceIDstringIdentifier of the default workspace associated with this account product.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayAccounts

Contains monday.com account records including plan details, member counts, branding, regional settings, and trial status for each integrated account.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
AccountIDstringUnique monday.com-generated identifier for the account.
NamestringDisplay name of the monday.com account.
SlugstringURL-safe slug identifier for the account, used in monday.com subdomain URLs.
LogostringURL of the account's logo image.
CountryCodestringISO 3166-1 alpha-2 country code of the account's primary location (e.g., US, GB, DE).
FirstDayOfTheWeekstringDay configured as the first day of the week for the account (e.g., sunday, monday, saturday).
TierstringPricing tier of the account (e.g., free, basic, standard, pro, enterprise).
ActiveMembersCountintegerNumber of currently active members in the monday.com account.
IsDuringTrialbooleanIndicates whether the account is currently in a trial period.
IsTrialExpiredbooleanIndicates whether the account's trial period has expired.
ShowTimelineWeekendsbooleanIndicates whether weekends are displayed in timeline views for the account.

MondayAssets

Stores file and attachment asset records uploaded to monday.com items and updates, including file metadata, size, and public access URLs.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
AssetIDstringUnique monday.com-generated identifier for the asset (file or attachment).
NamestringDisplay name of the asset, typically the original file name.
FileExtensionstringFile extension of the asset (e.g., pdf, png, docx, xlsx).
FileSizeintegerSize of the asset file in bytes.
OriginalGeometrystringOriginal dimensions of the asset image, expressed as a width-by-height string (e.g., 1920x1080).
PublicURLstringPublicly accessible URL to download or view the asset.
URLstringInternal monday.com URL for the asset.
URLThumbnailstringURL of a thumbnail preview image for the asset.
CreatedAtdatetimeTimestamp indicating when the asset was uploaded.
UploadedByIDstringIdentifier of the monday.com user who uploaded the asset.
ItemIDstringIdentifier of the item the asset is attached to, if applicable.
UpdateIDstringIdentifier of the update the asset is attached to, if applicable.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayAuditEventCatalogue

Records the catalogue of available audit event types in monday.com, including event names, descriptions, and metadata field definitions.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
NamestringName of the audit event type as defined in the monday.com audit log catalogue.
DescriptionstringDescription of the audit event type explaining what action or change it represents.
MetadataDetailsSerializedstringSerialized metadata field definitions describing the additional detail fields available for this audit event type.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayAuditLogs

Contains monday.com audit log entries capturing account-level security events such as user sign-ins, invitations, and administrative actions with user identity and IP context.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
IDintegerUnique identifier of the audit log entry.
TimestampstringTimestamp when the audited action occurred.
EventstringName of the audit event that occurred (e.g., user_signed_in, board_deleted, user_invited).
UserAgentstringHTTP user agent string of the browser or client used when the audited action occurred.
IPAddressstringIP address from which the audited action was performed.
UserIDstringIdentifier of the monday.com user who performed the audited action.
UserNamestringDisplay name of the user who performed the audited action.
UserEmailstringEmail address of the user who performed the audited action.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayBoardActivityLogs

Stores activity log events that occurred on monday.com boards, capturing entity-level changes such as item creation, column value updates, and group modifications.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
IDintegerAuto-incremented primary key for the board activity log record.
EventIDstringUnique identifier of the activity log event as assigned by monday.com.
EventstringType of activity event that occurred on the board (e.g., create_item, change_column_value, archive_group).
EntitystringEntity type affected by the activity event (e.g., board, item, column, group).
DatastringJSON-encoded data payload containing the details of the activity event, including before and after values.
CreatedAtdatetimeTimestamp indicating when the board activity event occurred.
MondayUserIDstringIdentifier of the monday.com user who triggered the activity event.
AccountIDstringIdentifier of the monday.com account the board belongs to.
MondayBoardIDstringIdentifier of the board on which the activity event occurred.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayBoardColumns

Contains column definitions for monday.com boards, including column type, title, description, archived state, and display width.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayBoardIDstringIdentifier of the board this column belongs to.
ColumnIDstringUnique identifier of the column within the board.
TitlestringDisplay title of the column as shown on the board.
TypestringColumn type determining the kind of data it holds (e.g., status, text, date, people, numbers, checkbox).
DescriptionstringOptional description of the column's purpose or usage.
ArchivedbooleanIndicates whether the column has been archived and is no longer visible on the board.
WidthintegerDisplay width of the column in pixels as configured on the board.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayBoardGroups

Stores group definitions within monday.com boards, including title, color, position, and archived or deleted state.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayBoardIDstringIdentifier of the board this group belongs to.
GroupIDstringUnique identifier of the group within the board.
TitlestringDisplay title of the group as shown on the board.
ColorstringHex color code or color name assigned to the group for visual identification.
PositionstringNumeric or string position of the group within the board, determining its display order.
ArchivedbooleanIndicates whether the group has been archived and is no longer visible on the board.
DeletedbooleanIndicates whether the group has been permanently deleted.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayBoardOwners

Records individual user ownership assignments for monday.com boards, linking board IDs to their owning users.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayBoardIDstringIdentifier of the board this owner is associated with.
MondayUserIDstringIdentifier of the monday.com user record for the board owner.
MondayUserUserIDstringmonday.com user ID of the board owner.
MondayUserConfigIDintegerConfiguration identifier of the board owner's user record.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayBoards

Primary table of monday.com boards, capturing full board metadata including name, kind, state, permissions, item count, workspace association, and metadata settings.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
BoardIDstringUnique monday.com-generated identifier for the board.
NamestringDisplay name of the board.
DescriptionstringOptional description of the board's purpose or content.
StatestringCurrent state of the board (e.g., active, archived, deleted).
BoardKindstringAccess type of the board (e.g., public, private, share).
BoardFolderIDstringIdentifier of the folder the board is stored in, if applicable.
ItemTerminologystringCustom label used to refer to items on the board (e.g., Task, Lead, Ticket).
ItemsCountintegerTotal number of items currently on the board.
PermissionsstringPermission level applied to the board (e.g., everyone, collaborators, assignee).
TypestringInternal type classification of the board (e.g., board, sub_items_board, document).
UpdatedAtdatetimeTimestamp indicating when the board was last updated.

MondayBoardSubscribers

Records individual user subscriptions to monday.com boards, linking board IDs to their subscribed users.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayBoardIDstringIdentifier of the board this subscriber is associated with.
MondayUserIDstringIdentifier of the monday.com user record for the board subscriber.
MondayUserUserIDstringmonday.com user ID of the board subscriber.
MondayUserConfigIDintegerConfiguration identifier of the subscriber's user record.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayBoardTeamOwners

Records team ownership assignments for monday.com boards, linking board IDs to the teams that own them.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayBoardIDstringIdentifier of the board this team owner is associated with.
MondayTeamIDstringIdentifier of the monday.com team record for the board team owner.
MondayTeamTeamIDstringmonday.com team ID of the board team owner.
MondayTeamConfigIDintegerConfiguration identifier of the board team owner's team record.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayBoardTeamSubscribers

Records team subscriptions to monday.com boards, linking board IDs to the teams subscribed to them.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayBoardIDstringIdentifier of the board this team subscriber is associated with.
MondayTeamIDstringIdentifier of the monday.com team record for the board team subscriber.
MondayTeamTeamIDstringmonday.com team ID of the board team subscriber.
MondayTeamConfigIDintegerConfiguration identifier of the board team subscriber's team record.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayBoardViews

Stores board view configurations for monday.com boards, including view type, display settings, and applied filters.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
ViewIDstringUnique identifier of the board view.
MondayBoardIDstringIdentifier of the board this view belongs to.
NamestringDisplay name of the board view.
TypestringType of the board view (e.g., table, kanban, timeline, calendar, gantt, chart, map).
SettingsStringstringJSON-encoded settings string containing the view's configuration and display options.
ViewSpecificDataStringstringJSON-encoded string containing view-specific data such as filters or groupings applied to the view.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayDepartments

Contains monday.com department records used for organizing users and managing seat allocations within enterprise accounts.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
DepartmentIDstringUnique monday.com-generated identifier for the department.
NamestringDisplay name of the department.
AssignedSeatsintegerNumber of seats currently assigned to members of this department.
ReservedSeatsintegerNumber of seats reserved for this department in the account's seat allocation.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayFolders

Stores folder records used to organize boards within monday.com workspaces, including color, creation date, and parent folder hierarchy.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
FolderIDstringUnique monday.com-generated identifier for the folder.
NamestringDisplay name of the folder.
ColorstringColor assigned to the folder for visual identification in the monday.com sidebar.
CreatedAtdatetimeTimestamp indicating when the folder was created.
ParentFolderIDstringIdentifier of the parent folder, if this folder is nested within another folder.
MondayWorkspaceIDstringIdentifier of the workspace this folder belongs to.
MondayWorkspaceConfigIDintegerConfiguration identifier of the workspace record this folder belongs to.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayIntegrations

Integration summary table listing all monday.com integration configurations with creation, modification, and enablement metadata.

NameTypeDescription
IDintegerAuto-incremented primary key for the monday.com integration configuration record.
NamestringDisplay name of the monday.com integration configuration.
IsEnabledbooleanIndicates whether the integration configuration is currently active and enabled.
CreatedDatedatetimeTimestamp indicating when the integration configuration was created.
ModifiedDatedatetimeTimestamp indicating when the integration configuration was last modified.
CreatedBystringUsername or identifier of the user who created the integration configuration.
ModifiedBystringUsername or identifier of the user who last modified the integration configuration.
IntegrationIDintegerNumeric identifier linking this record to the associated monday.com integration instance.

MondayItemColumnValues

Contains the column value records for monday.com items, storing both the raw JSON value and the human-readable text representation for each column.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayItemIDstringIdentifier of the item this column value belongs to.
ColumnIDstringIdentifier of the column this value corresponds to.
TypestringColumn type of this value (e.g., status, text, date, people, numbers, checkbox).
TextstringHuman-readable text representation of the column value.
ValuestringRaw JSON-encoded value of the column, containing the structured data as stored by monday.com.
ColumnTitlestringDisplay title of the column this value belongs to.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayItems

Primary table of monday.com items (rows) on boards, including name, state, board and group assignment, parent item reference for subitems, and creator details.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
ItemIDstringUnique monday.com-generated identifier for the item.
NamestringDisplay name of the item as shown on the board.
StatestringCurrent state of the item (e.g., active, archived, deleted).
EmailstringEmail address associated with the item, if populated via a people or email column.
URLstringPublic URL to access the item in the monday.com web interface.
CreatedAtdatetimeTimestamp indicating when the item was created.
UpdatedAtdatetimeTimestamp indicating when the item was last updated.
RelativeLinkstringRelative URL path for the item within the monday.com web interface.
MondayBoardIDstringIdentifier of the board this item belongs to.
GroupIDstringIdentifier of the group within the board that the item belongs to.
ParentItemIDstringIdentifier of the parent item if this item is a subitem.
CreatorIDstringIdentifier of the monday.com user who created the item.
DescriptionMarkdownstringMarkdown-formatted description of the item.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayItemSubscribers

Records individual user subscriptions to monday.com items, linking item IDs to their subscribed users.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayItemIDstringIdentifier of the item this subscriber is associated with.
MondayUserIDstringIdentifier of the monday.com user record for the item subscriber.
MondayUserUserIDstringmonday.com user ID of the item subscriber.
MondayUserConfigIDintegerConfiguration identifier of the subscriber's user record.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayTeamMemberships

Stores membership records associating monday.com users with the teams they belong to.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayTeamIDstringIdentifier of the monday.com team this membership record belongs to.
MondayUserIDstringIdentifier of the monday.com user who is a member of the team.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayTeamOwners

Records individual user ownership assignments for monday.com teams, linking team IDs to their owning users.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayTeamIDstringIdentifier of the monday.com team this owner is associated with.
MondayUserIDstringIdentifier of the monday.com user record for the team owner.
MondayUserUserIDstringmonday.com user ID of the team owner.
MondayUserConfigIDintegerConfiguration identifier of the team owner's user record.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayTeams

Contains monday.com team records used to group users for board and workspace assignment, including team name and profile picture.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
TeamIDstringUnique monday.com-generated identifier for the team.
NamestringDisplay name of the team.
PictureURLstringURL of the team's profile picture or avatar.
IsGuestbooleanIndicates whether the team consists of guest users rather than full account members.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayUpdateLikes

Stores like and reaction records on monday.com updates, capturing reaction type, creator, and timestamps.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
LikeIDstringUnique identifier of the like or reaction on the update.
MondayUpdateIDstringIdentifier of the update this like or reaction is associated with.
ReactionTypestringType of reaction applied to the update (e.g., like, thumbsup, heart).
CreatedAtdatetimeTimestamp indicating when the like or reaction was created.
UpdatedAtdatetimeTimestamp indicating when the like or reaction was last updated.
CreatorIDstringIdentifier of the monday.com user who created the like or reaction.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayUpdateReplies

Contains reply records posted in response to monday.com updates, including HTML and plain-text body content and author details.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
ReplyIDstringUnique identifier of the reply.
MondayUpdateIDstringIdentifier of the update this reply is associated with.
BodystringHTML-formatted body content of the reply.
TextBodystringPlain-text body content of the reply, stripped of HTML formatting.
CreatedAtdatetimeTimestamp indicating when the reply was created.
UpdatedAtdatetimeTimestamp indicating when the reply was last updated.
CreatorIDstringIdentifier of the monday.com user who authored the reply.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayUpdates

Stores monday.com update (comment) records posted on items, including HTML and plain-text body content, edit timestamps, and pin status.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
UpdateIDstringUnique monday.com-generated identifier for the update.
BodystringHTML-formatted body content of the update.
TextBodystringPlain-text body content of the update, stripped of HTML formatting.
CreatedAtdatetimeTimestamp indicating when the update was created.
UpdatedAtdatetimeTimestamp indicating when the update was last modified.
EditedAtdatetimeTimestamp indicating when the update was last edited by its author.
MondayItemIDstringIdentifier of the item this update is associated with.
CreatorIDstringIdentifier of the monday.com user who authored the update.
PinnedToTopSerializedstringSerialized data indicating whether and how the update is pinned to the top of the item's updates feed.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayUpdateViewers

Records view events for monday.com updates, tracking which users viewed each update and through which medium.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayUpdateIDstringIdentifier of the update this viewer record is associated with.
MondayUserIDstringIdentifier of the monday.com user who viewed the update.
MediumstringMedium or channel through which the update was viewed (e.g., web, mobile, email).
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayUserActivityLogs

Contains activity log events attributed to specific monday.com users, capturing entity-level changes performed by each user across the account.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
IDintegerAuto-incremented primary key for the user activity log record.
EventIDstringUnique identifier of the user activity log event as assigned by monday.com.
EventstringType of activity event performed by the user (e.g., create_item, change_column_value, archive_board).
EntitystringEntity type affected by the user activity event (e.g., board, item, column, workspace).
DatastringJSON-encoded data payload containing the details of the user activity event.
CreatedAtdatetimeTimestamp indicating when the user activity event occurred.
MondayUserIDstringIdentifier of the monday.com user who performed the activity.
AccountIDstringIdentifier of the monday.com account in which the user activity occurred.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayUsers

Stores monday.com user account records including identity, contact details, profile photos, timezone, department, role, and out-of-office configuration.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
UserIDstringUnique monday.com-generated identifier for the user.
NamestringFull display name of the user.
EmailstringEmail address of the user.
StatusstringCurrent account status of the user (e.g., active, inactive, pending, suspended).
IsEmailConfirmedbooleanIndicates whether the user has confirmed their email address.
BecameActiveAtdatetimeTimestamp indicating when the user became active on the monday.com account.
LastActivitydatetimeTimestamp of the user's most recent activity on the monday.com platform.
CreatedAtdatetimeTimestamp indicating when the user account was created.
TitlestringJob title of the user as set in their monday.com profile.
LocationstringLocation of the user as set in their monday.com profile.
PhonestringPhone number of the user as set in their monday.com profile.

MondayWebhooks

Contains webhook registration records for monday.com boards, including the subscribed event type, target board, and serialized configuration settings.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
WebhookIDstringUnique monday.com-generated identifier for the webhook.
EventstringEvent type the webhook is subscribed to (e.g., create_item, change_column_value, create_update, item_archived).
MondayBoardIDstringIdentifier of the board this webhook is scoped to.
ConfigSerializedstringSerialized configuration settings for the webhook, including the target URL and any additional options.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayWorkspaces

Stores monday.com workspace records including kind, state, branding settings, and account product association.

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
WorkspaceIDstringUnique monday.com-generated identifier for the workspace.
NamestringDisplay name of the workspace.
DescriptionstringOptional description of the workspace's purpose or content.
KindstringType of workspace (e.g., open = accessible to all account members, closed = invite-only).
StatestringCurrent state of the workspace (e.g., active, archived, deleted).
CreatedAtdatetimeTimestamp indicating when the workspace was created.
IsDefaultWorkspacebooleanIndicates whether this is the account's default workspace.
AccountProductIDstringIdentifier of the account product this workspace belongs to.
SettingsIconColorstringHex color code of the icon color configured for the workspace.
SettingsIconImagestringURL or identifier of the icon image configured for the workspace.
SettingsSerializedstringSerialized workspace settings including additional configuration options.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayWorkspaceSubscribers

Records individual user subscriptions to monday.com workspaces, including membership kind (subscriber or owner).

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayWorkspaceIDstringIdentifier of the workspace this subscriber is associated with.
MondayUserIDstringIdentifier of the monday.com user record for the workspace subscriber.
KindstringMembership kind of the workspace subscriber (e.g., subscriber, owner).
MondayUserUserIDstringmonday.com user ID of the workspace subscriber.
MondayUserConfigIDintegerConfiguration identifier of the workspace subscriber's user record.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.

MondayWorkspaceTeamSubscribers

Records team subscriptions to monday.com workspaces, including membership kind (subscriber or owner).

NameTypeDescription
ConfigIDintegerUnique identifier linking the record to a specific monday.com integration configuration.
MondayWorkspaceIDstringIdentifier of the workspace this team subscriber is associated with.
MondayTeamIDstringIdentifier of the monday.com team record for the workspace team subscriber.
KindstringMembership kind of the workspace team subscription (e.g., subscriber, owner).
MondayTeamTeamIDstringmonday.com team ID of the workspace team subscriber.
MondayTeamConfigIDintegerConfiguration identifier of the workspace team subscriber's team record.
BatchDatedatetimeTimestamp indicating when the record was ingested or last refreshed by the integration.


Did this page help you?