WorkspaceUsers
Fetches the list of users subscribed to a specific workspace.
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.
- WorkspaceId supports the '=','IN' comparison operators.
- Kind supports the '=','IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM WorkspaceUsers WHERE WorkspaceId = '3578971'
SELECT * FROM WorkspaceUsers WHERE Kind = 'owner'
INSERT
This table supports BATCH INSERT. The following columns can be used to create a new record:
Id, WorkspaceId, Kind
INSERT INTO WorkspaceUsers (Id, WorkspaceId, Kind) VALUES ('51688059', '3820334', 'subscriber')
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.
DELETE
This table supports BATCH DELETE. You can delete entries by specifying the following columns:
Id, WorkspaceId
DELETE FROM WorkspaceUsers WHERE Id = '51688059' AND WorkspaceId = '3820334'
DELETE FROM WorkspaceUsers WHERE EXISTS SELECT Id, WorkspaceId FROM WorkspaceUsers#TEMP
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique identifier assigned to each user, used to distinguish between different users within the system. | |
| WorkspaceId [KEY] | String | True |
The unique identifier for the workspace to which the user belongs, linking the user to a specific workspace or project. | |
| Kind | String | True |
The role assigned to the user within the workspace, such as 'subscriber' or 'owner.' All users with the 'owner' role are automatically granted 'subscriber' privileges. This field can be used to filter or identify users with specific roles, like non-owners. The allowed values are owner, subscriber. |