Boards
Retrieves a collection of boards, including their details and associated data.
Table-Specific Information
SELECT
The connector uses the Monday API to process some of the filters. The connector processes other filters client-side within the connector.
- Id supports the '=','IN' comparison operators.
- BoardKind supports the '=' comparison operator.
- State supports the '=' comparison operator.
- WorkspaceId supports the '=','IN' comparison operators.
SELECT * FROM Boards WHERE Id = '2182296646'
SELECT * FROM Boards WHERE Id IN ('2307103055', '2182296646', '2181960030')
SELECT * FROM Boards WHERE Id IN ('2307103055', '2182296646', '2181960030') AND BoardKind = 'public'
SELECT * FROM Boards WHERE BoardKind = 'public'
INSERT
The following inputs can be used in INSERT statements:
Name, Description, BoardKind, BoardFolderId, WorkspaceId, TemplateId, BoardOwnerIds, BoardOwnerTeamIds, BoardSubscriberIds, BoardSubscriberTeamIds, Empty
INSERT INTO Boards (WorkspaceId,BoardKind,Name,Description,BoardFolderId,BoardOwnerIds,BoardSubscriberTeamIds,Empty) VALUES ('3820334','public','NewBoard','A newly created board.','12689416','51688059,51085546','960990',true)
UPDATE
The following inputs can be used in UPDATE statements (note that due to API limitations only one column's value can be updated per statement):
Name, Description, Communication, State, BoardAttributes
UPDATE Boards SET Name = 'AnotherName' WHERE Id = '5549166043'
UPDATE Boards SET State = 'archived' WHERE Id = '5549166043'
DELETE
You can delete entries by specifying the Id.
DELETE FROM Boards WHERE Id = '5549166043'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
A unique identifier for the board, used to distinguish it from other boards in the system. | |
| CreatorId | String | False |
Users.Id |
The unique identifier of the user who created the board. |
| Name | String | False |
The name of the board, representing its primary label or title. | |
| ItemTerminology | String | False |
Defines the terminology used for items on the board. Can be a predefined term or a custom value provided by the user. | |
| ItemsCount | Int | False |
The total number of items currently present on the board. | |
| TopGroupId | String | False |
Groups.Id |
The unique identifier of the top-level group associated with this board. |
| Description | String | False |
A detailed description or summary of the board's purpose or content. | |
| UpdatedAt | Datetime | False |
The timestamp indicating when the board was last updated. | |
| Type | String | False |
Specifies the type of board object, such as a task board or project board. | |
| Url | String | False |
The direct URL link to access the board. | |
| BoardKind | String | False |
Indicates the kind of board, such as public, private, or shared, determining its visibility and access. The allowed values are public, private, share. | |
| BoardFolderId | String | False |
Folders.Id |
A unique identifier for the board's folder within the system. |
| Communication | String | False |
Specifies the communication identifier associated with the board, typically a meeting ID or collaboration reference. | |
| Permissions | String | False |
Defines the permissions or access controls assigned to the board. | |
| TagsIds | String | False |
Tags.Id |
A comma-separated list of unique identifiers for the tags associated with the board. |
| State | String | False |
Indicates the current state of the board, such as 'all', 'active', 'archived', or 'deleted'. | |
| WorkspaceId | String | False |
Workspaces.Id |
The unique identifier of the workspace containing the board. A null value indicates the board belongs to the main workspace. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| TemplateId | String |
Specifies the unique identifier of an optional template used to create the board. |
| BoardOwnerIds | String |
An optional, comma-separated list of user IDs representing the owners of the board. |
| BoardOwnerTeamIds | String |
An optional, comma-separated list of team IDs representing the owner teams of the board. |
| BoardSubscriberIds | String |
An optional, comma-separated list of user IDs representing subscribers to the board. |
| BoardSubscriberTeamIds | String |
An optional, comma-separated list of team IDs representing subscriber teams to the board. |
| Empty | Bool |
An optional flag indicating whether to create an empty board without any default items. |