Teams
Get a collection of teams.
View-Specific Information
SELECT
The add-in uses the Monday API to process some of the filters. The add-in processes other filters client-side within the add-in.
- Id supports the '=','IN' comparison operators.
SELECT * FROM Teams WHERE Id = '565332'
SELECT * FROM Teams WHERE Id IN ('565332, 565333')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The unique identifier for the team, used to reference the team across the system. This ID ensures that each team can be distinguished and managed independently. | |
| Name | String | False |
The name of the team, which can be used to identify the team in user interfaces, reports, or other parts of the system. | |
| PictureUrl | String | False |
The URL link to the team's picture or logo, used for displaying visual representations of the team in the application or on web pages. | |
| IsGuestTeam | Boolean | False |
Whether the team is a guest team. |
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 |
| ParentTeamId | String |
Optional, the id of the parent team. |
| TeamSubscriberIds | String |
Optional, comma-separated list of team subscriber ids. |
| AllowEmptyTeam | Boolean |
Optional flag to create an empty team (without any subscribers). |