Get a team's users.

Table-Specific Information

SELECT

The cmdlet uses the Monday API to process some of the filters. The cmdlet processes other filters client-side within the cmdlet.

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

For example, the following queries are processed server side:

SELECT * FROM TeamUsers WHERE TeamId = '3578971'
SELECT * FROM TeamUsers WHERE Kind = 'owner'

INSERT

Note: API limitations may cause affected row counts or generated keys to be reported inaccurately when attempting to create relationships between entities that are already related.

The following inputs can be used in INSERT statements:

Id, TeamId

INSERT INTO TeamUsers (Id, TeamId) VALUES ('57410919', '1127299')

DELETE

Note: API limitations may cause affected row counts to be reported inaccurately when attempting to delete relationships between entities that are not related.

You can delete entries by specifying the Id and TeamId.

DELETE FROM TeamUsers WHERE Id = '51688059' AND TeamId = '3820334'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False	Users.Id	A unique identifier for the user within the system, used to differentiate and reference individual users across various processes and tables.
TeamId [KEY]	String	False	Teams.Id	A unique identifier for the team to which the user is assigned, enabling team-based filtering and operations within the platform.
Kind	String	False		The user's role. All owners are by default also members. This column can be used to filter non-owners. The allowed values are member, owner.