Groups

Retrieves the visible groups for a specified board, providing a structured view of grouped items.

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.
BoardId supports the '=','IN' comparison operators.

For example, the following queries are processed server side:

SELECT * FROM Groups WHERE Id = 'topics'
SELECT * FROM Groups WHERE Id IN ('topics', 'group_title')
SELECT * FROM Groups WHERE BoardId IN ('2182296646', '21822966')
SELECT * FROM Groups WHERE BoardId = '2182296646' AND Id = 'topics'

INSERT

The following inputs can be used in INSERT statements:

BoardId, Title, RelativeTo, PositionRelativeMethod

INSERT INTO Groups (BoardId,Title,Color,RelativeTo,PositionRelativeMethod) VALUES ('5525287714','NewGroup','#9CD326','testgroup','after_at')

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):

Archived, Color, Title, RelativePositionAfter, RelativePositionBefore

UPDATE Groups SET Color = '#9CD326' WHERE BoardId = '5525287714' AND Id = 'newgroup'
UPDATE Groups SET Archived = 'true' WHERE BoardId='5525287714' AND Id = 'newgroup'

DELETE

You can delete entries by specifying the Id and BoardId.

DELETE FROM Groups WHERE BoardId = '5525287714' AND Id = 'testgroup'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The unique identifier assigned to the group within the system, ensuring that each group can be referenced distinctly.
BoardId [KEY]	String	False	Boards.Id	The unique identifier of the board to which the group belongs, linking the group to a specific board in the database.
BoardURL	String	False		The URL of the board associated with the group, providing a direct link for accessing the board in the web interface.
Archived	Bool	False		A flag indicating whether the group is archived. A value of true means the group is archived and no longer actively used.
Color	String	False		The color associated with the group, typically used for visual identification or categorization within the board. The allowed values are #037f4c, #fdab3d, #579bfc, #e2445c, #00c875, #c4c4c4, #0086c0, #a25ddc, #ffcb00, #9cd326, #7f5347, #bb3354, #808080, #784bd1, #ff642e, #ff158a, #66ccff, #ff5ac4, #cab641.
Deleted	Bool	False		A flag that indicates whether the group has been deleted. A value of true means the group has been removed from the system.
Position	String	False		A string representing the position of the group on the board, often used for ordering groups in a list or layout.
Title	String	False		The title or name of the group, which provides a human-readable identifier for the group within the board.

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
RelativeTo	String	Specifies the group relative to which the current group's position should be set. This helps in defining the ordering between groups.
PositionRelativeMethod	String	Describes the method used to determine the group's position relative to another group. Possible values include 'before_at' and 'after_at'. The allowed values are before_at, after_at.
RelativePositionAfter	String	Defines the position of the group relative to another group, specifically indicating that it should appear after the referenced group on the board.
RelativePositionBefore	String	Defines the position of the group relative to another group, specifying that it should appear before the referenced group on the board.

Power BI Connector for Monday