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.

For example, the following queries are processed server side:

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.

Tableau Connector for Monday