Get the users subscribed to the workspace.

View-Specific Information

SELECT

The 本製品 uses the Monday API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data.

• 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

INSERT statements are mapped to the 'add_users_to_workspace' GraphQL mutation.

The following inputs can be used in INSERT statements:

Id, WorkspaceId, Kind

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

DELETE

DELETE statements are mapped to the 'delete_users_from_workspace' GraphQL mutation.

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 user's unique identifier.
WorkspaceId [KEY]	String	False		The workspace's unique identifier.
Kind	String	False		The user's role: subscriber or owner. All owners are by default also subscribers. This column can be used to filter non-owners.