Folders
Get a collection of folders. Note that this won't return folders from closed workspaces to which you are not subscribed.
View-Specific Information
SELECT
The component uses the Monday API to process some of the filters. The component processes other filters client-side within the component. 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.
- WorkspaceId supports the '=','IN' comparison operators.
SELECT * FROM Folders WHERE Id = '12622355'
SELECT * FROM Folders WHERE WorkspaceId = '3578971'
INSERT
INSERT statements are mapped to the 'create_folder' GraphQL mutation.
The following inputs can be used in INSERT statements:
ParentId, WorkspaceId, Color, Name
INSERT INTO Folders (WorkspaceId,Name,Color) VALUES ('3578971','TestFolder','BRIGHT_BLUE')
UPDATE
UPDATE statements are mapped to the 'update_folder' GraphQL mutation.
The following inputs can be used in UPDATE statements:
Id, ParentId, Color, Name
UPDATE Folders SET Color='SUNSET',Name='UpdatedName' WHERE Id='12678064'
DELETE
DELETE statements are mapped to the 'delete_folder' GraphQL mutation.
You can delete entries by specifying the Id.
DELETE FROM Folders WHERE Id='12678064'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
The folder's unique identifier. | |
OwnerId | String | False |
Users.Id |
The folder's user owner unique identifier. |
ParentId | String | False |
The unique identifiers of the folder's parent folder. | |
SubFolderIds | String | False |
The unique identifiers of the sub-folders inside the folder. | |
WorkspaceId | String | False |
Workspaces.Id |
The workspace's unique identifier. |
Color | String | False |
The folder's color. | |
Name | String | False |
The folder's name. | |
CreatedAt | Datetime | False |
The folder's creation date. |