Workspaces
Get a collection of workspaces.
View-Specific Information
SELECT
The add-in uses the Monday API to process some of the filters. The add-in processes other filters client-side within the add-in. 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.
- Id supports the '=','IN' comparison operators.
- Kind supports the '=' comparison operator.
- State supports the '=' comparison operator.
SELECT * FROM Workspaces WHERE Id='3578971'
SELECT * FROM Workspaces WHERE Kind='open'
SELECT * FROM Workspaces WHERE State='active'
INSERT
INSERT statements are mapped to the 'create_workspace' GraphQL mutation.
The following inputs can be used in INSERT statements:
Description, Kind, Name
INSERT INTO Workspaces (Name,Kind,Description) VALUES ('New Workspace','open','This is my new workspace.')
UPDATE
UPDATE statements are mapped to the 'update_workspace' GraphQL mutation.
The following inputs can be used in INSERT statements:
Id, Description, Name, Kind
UPDATE Workspaces Set Description='testDescription', Name='testName', Kind='open' WHERE Id='3819431'
DELETE
DELETE statements are mapped to the 'delete_workspace' GraphQL mutation.
You can delete entries by specifying the Id.
DELETE FROM Workspaces WHERE Id='3819431'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
The workspace's unique identifier. | |
Description | String | False |
The workspace's description. | |
Kind | String | False |
The workspace's kind (open / closed). | |
Name | String | False |
The workspace's name. | |
State | String | False |
The workspace's state (all / active / archived / deleted). | |
CreatedAt | Datetime | False |
The workspace's creation date. | |
AccountProductId | String | False |
The account product id. | |
AccountProductKind | String | False |
The account product kind (core / marketing / crm / software / projectManagement / project_management / forms / whiteboard). | |
SettingsIconColor | String | False |
The icon color in hex value. Used as a background for the image. | |
SettingsIconImage | String | False |
The public image URL, which is temporary in the case of a file that was uploaded by the user, so you'll need to pull a new version at least once an hour. In case it is null, you can use the first letter of the workspace name. |