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.
For example, the following queries are processed server-side:
SELECT * FROM Folders WHERE Id = '12622355'
SELECT * FROM Folders WHERE WorkspaceId = '3578971'
INSERT
The following columns can be used to create a new record:
ParentId, WorkspaceId, Color, Name
INSERT INTO Folders (WorkspaceId,Name,Color) VALUES ('3578971','TestFolder','BRIGHT_BLUE')
UPDATE
The following columns can be updated:
ParentId, WorkspaceId, Color, Name
The following pseudo-columns can be used to update a record:
AccountProductId, PositionIsAfter, PositionObjectId, PositionObjectType
DELETE
You can delete entries by specifying the following column:
Id
DELETE FROM Folders WHERE Id='12678064'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A unique identifier for the folder, used to reference the folder in the system or database. | |
| OwnerId | String | True |
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 | True |
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 | True |
The timestamp of when the folder was created, which helps track the folder's age and historical changes. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AccountProductId | String |
The unique identifier of the product to move the folder to. |
| PositionIsAfter | Bool |
Specifies where to position the target folder relative to the reference object. |
| PositionObjectId | String |
The unique identifier of the reference object that the target folder should be positioned relative to. |
| PositionObjectType | String |
The type of the reference object. |