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

The following inputs can be used in INSERT statements:

Id, WorkspaceId, Kind

INSERT INTO WorkspaceUsers (Id,WorkspaceId,Kind) VALUES ('51688059','3820334','subscriber')

DELETE

You can delete entries by specifying the Id and WorkspaceId.

DELETE FROM WorkspaceUsers WHERE Id = '51688059' AND WorkspaceId = '3820334'

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.