Information Data Model
In the Information Data Model schema, the provider models the data entities and relationships with the Monday.com platform as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your Monday.com account are immediately reflected in the provider.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you may have access to in your Monday account.
Common tables include:
Table | Description |
Boards | Retrieves a collection of boards, including their details and associated data. |
BoardUsers | Retrieves a list of user subscribers for a specific board. |
BoardTeams | Fetches a list of team subscribers associated with a specific board. |
Columns | Retrieves the visible columns for a specific board, providing structural information. |
Groups | Retrieves the visible groups for a specified board, providing a structured view of grouped items. |
BoardViews | Retrieves a list of views configured for a specific board. |
Users | Retrieves details about users within the Monday platform. |
Updates | Fetches a collection of updates, including user comments, status changes, and other activity logs. |
Tags | Retrieves a collection of tags used to categorize and filter items across boards. |
Teams | Fetches metadata about teams in the Monday platform. |
Workspaces | Retrieves a collection of workspaces, including their names and details. |
Webhooks | Fetches a collection of webhooks, including their configuration and associated events. |
Folders | Retrieves a collection of folders within workspaces. Excludes folders in closed workspaces unless you are subscribed to them. |
Docs | Retrieves a collection of documents from workspaces, including their metadata. |
DocBlocks | Fetches content blocks within documents associated with workspaces. |
BoardDocs | Fetches a collection of documents associated with boards. Requires specifying an Id or ObjectId filter to identify the desired documents. |
BoardDocBlocks | Retrieves content blocks from documents associated with boards. Requires a DocId or DocObjectId filter to narrow results. |
WorkspaceUsers | Fetches the list of users subscribed to a specific workspace. |
WorkspaceTeams | Retrieves the list of teams subscribed to a specific workspace. |
CustomActivities | Retrieves metadata about custom activities in the Email and Activities timeline for enhanced activity tracking. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including duplicating items in a board, adding a file to a column value in a board, and sending a new notification to users.