Get a collection of boards.

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. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data.

• 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		The unique identifier of the board.
CreatorId	String	False	Users.Id	The user's unique identifier.
Name	String	False		The board's name.
ItemTerminology	String	False		The Board's item nickname, one of a predefined set of values, or a custom user value.
ItemsCount	Int	False		The number of items on the board.
TopGroupId	String	False	Groups.Id	The group's unique identifier.
Description	String	False		The board's description.
UpdatedAt	Datetime	False		The last time the board was updated at.
Type	String	False		The board object type.
Url	String	False		The board's URL.
BoardKind	String	False		The board's kind (public / private / share). 使用できる値は次のとおりです。public, private, share
BoardFolderId	String	False	Folders.Id	The board's folder unique identifier.
Communication	String	False		Get the board communication value - typically meeting ID.
Permissions	String	False		The board's permissions.
TagsIds	String	False	Tags.Id	A comma separated list of the tags' unique identifiers.
State	String	False		The board's state (all / active / archived / deleted).
WorkspaceId	String	False	Workspaces.Id	The board's workspace unique identifier (null for main workspace).

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
TemplateId	String	Optional board template id.
BoardOwnerIds	String	Optional, comma-seperated list of board owner user ids.
BoardOwnerTeamIds	String	Optional, comma-seperated list of board owner team ids.
BoardSubscriberIds	String	Optional, comma-seperated list of board subscriber ids.
BoardSubscriberTeamIds	String	Optional, comma-seperated list of subscriber team ids.
Empty	Bool	Optional flag to create an empty board (without any default items).