Get a board's subscribers.

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.

• BoardId supports the '=','IN' comparison operators.
• Kind supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM BoardUsers WHERE BoardId='5525287714'
SELECT * FROM BoardUsers WHERE Kind='owner'

INSERT

The following inputs can be used in INSERT statements:

Id, BoardId, Kind

INSERT INTO BoardUsers (Id,BoardId,Kind) VALUES ('51688059','5546871560','subscriber')

DELETE

You can delete entries by specifying the Id and BoardId.

DELETE FROM BoardUsers WHERE Id='51688059' AND BoardId='5546871560'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False	Users.Id	The board owner's unique identifier.
BoardId [KEY]	String	False	Boards.Id	The unique identifier of the board.
Kind	String	False		The user's role: subscriber or owner. All owners are by default also subscribers. This column can be used to filter non-owners. 使用できる値は次のとおりです。owner