WorkspaceTeams
Retrieves the list of teams subscribed to a specific workspace.
Table-Specific Information
SELECT
The 本製品 uses the Monday API to process some of the filters. The 本製品 processes other filters client-side within the 本製品.
- WorkspaceId supports the '=','IN' comparison operators.
- Kind supports the '=','IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM WorkspaceTeams WHERE WorkspaceId = '3820334'
SELECT * FROM WorkspaceTeams 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 columns can be used to create a new record:
Id, WorkspaceId, Kind
INSERT INTO WorkspaceTeams (Id,WorkspaceId,Kind) VALUES ('961021','3820334','subscriber')
INSERT INTO WorkspaceTeams (Id,WorkspaceId,Kind) VALUES ('961021','3820334','owner')
DELETE
You can delete entries by specifying the following columns:
Id, WorkspaceId
DELETE FROM WorkspaceTeams WHERE Id = '961021' AND WorkspaceId = '3820334'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique identifier for the team, used to distinguish each team within the system. This ID is referenced in other tables or operations to identify the specific team. | |
| WorkspaceId [KEY] | String | True |
The unique identifier for the workspace to which the team belongs. It is used to associate the team with a specific workspace for collaboration or access control purposes. | |
| Kind | String | True |
Defines the team’s role within the workspace. The role can be 'subscriber' or 'owner', where owners have additional permissions compared to subscribers. This column is useful for filtering and managing access levels. 使用できる値は次のとおりです。owner, subscriber |