Get a team's users.

Table-Specific Information

SELECT

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

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

For example, the following queries are processed server-side:

  SELECT * FROM TeamUsers WHERE TeamId = 'Val1'
  SELECT * FROM TeamUsers WHERE Kind = 'member'

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 columns can be used to create a new record:

Id, TeamId

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

UPDATE

The following column can be updated:

Kind

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 following columns:

Id, TeamId

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

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True	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	True	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.