Folders
Searches for folder structures within HubSpot's file manager, excluding hidden and archived folders.
View Specific Information
SELECT
When selecting Folders, they can be filtered by columns marked below as 'Filterable'. For those columns, except ParentFolderId column that supports even the IN Operator, the supported server-side operator is =.
SELECT * FROM Folders; SELECT * FROM Folders WHERE Id = '162408509011';
Columns
| Name | Type | References | Filterable | Description |
| Id [KEY] | Long | True | Unique identifier of the folder. | |
| Name | String | True | The name assigned to the folder. | |
| Path | String | False | The full path of the folder in the file manager directory structure. | |
| ParentFolderId | Long | True | The ID of the folder's parent directory, if applicable. | |
| CreatedAt | Datetime | True | The date and time when the folder was created. | |
| UpdatedAt | Datetime | True | The timestamp of the most recent update to the folder. | |
| Archived | Bool | False | Indicates whether the folder has been deleted or archived. | |
| ArchivedAt | Datetime | False | The date and time when the folder was archived or deleted. |