Fetches the list of users subscribed to a specific workspace.

Table-Specific Information

SELECT

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

• WorkspaceId supports the '=' comparison operator.
• Kind supports the '=' comparison operator.

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 inputs (Id, WorkspaceId, Kind) can be used in INSERT statements:

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 Id and 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	False		The unique identifier assigned to each user, used to distinguish between different users within the system.
WorkspaceId [KEY]	String	False		The unique identifier for the workspace to which the user belongs, linking the user to a specific workspace or project.
Kind	String	False		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.