Folders
Retrieves a collection of folders within workspaces. Excludes folders in closed workspaces unless you are subscribed to them.
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.
- 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
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
The following inputs can be used in UPDATE statements:
ParentId, Color, Name
UPDATE Folders SET Color = 'SUNSET', Name = 'UpdatedName' WHERE Id = '12678064'
DELETE
You can delete entries by specifying the Id.
DELETE FROM Folders WHERE Id='12678064'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
A unique identifier for the folder, used to reference the folder in the system or database. | |
| OwnerId | String | False |
Users.Id |
The unique identifier of the user who owns the folder, linking it to the user profile responsible for the folder. |
| ParentId | String | False |
The unique identifier of the folder's parent, allowing for hierarchical folder structures. This helps in organizing folders within a larger directory structure. | |
| SubFolderIds | String | False |
A list of unique identifiers for the subfolders contained within the current folder, enabling a nested folder structure. | |
| WorkspaceId | String | False |
Workspaces.Id |
The unique identifier of the workspace that the folder belongs to, helping to associate the folder with a specific project or team environment. |
| Color | String | False |
The color assigned to the folder for visual identification or categorization, often used to visually differentiate between folders in the user interface. The allowed values are DONE_GREEN, BRIGHT_GREEN, WORKING_ORANGE, DARK_ORANGE, SUNSET, STUCK_RED, DARK_RED, SOFIA_PINK, LIPSTICK, PURPLE, DARK_PURPLE, INDIGO, BRIGHT_BLUE, AQUAMARINE, CHILI_BLUE, NULL. | |
| Name | String | False |
The name given to the folder, typically representing its content or purpose, and displayed in the system for easy identification. | |
| CreatedAt | Datetime | False |
The timestamp of when the folder was created, which helps track the folder's age and historical changes. |