Folders
Retrieves folder structures in HubSpot's file manager, useful for organizing and accessing stored files.
Table Specific Information
Folders represent any folders you can upload files to in your content optimization system within HubSpot.
SELECT
When selecting folders, they can only be filtered by the Id, DeletedAt, Name, and ParentFolderId. Name can be used with the LIKE comparison. DeletedAt can be used with the > and < comparisons but cannot form a range. For example:
SELECT * FROM Folders WHERE DeletedAt >= '1/1/2014' AND DeletedAt <= '10/1/2014' SELECT * FROM Folders WHERE Name LIKE 'foldername' SELECT * FROM Folders WHERE Id = '123456798'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Unique identifier assigned to the folder. | |
| Category | Integer | Integer value representing the category classification of the folder. | |
| CreatedAt | Datetime | Timestamp showing when the folder was initially created. | |
| DeletedAt | Datetime | Timestamp showing when the folder was deleted, if applicable. | |
| FullPath | String | Full directory path to the folder within the HubSpot file system. | |
| Name | String | Name assigned to the folder. | |
| ParentFolderId | Long |
Folders.Id | Unique identifier of the parent folder, if the folder is nested within another folder. |
| UpdatedAt | Datetime | Timestamp showing when the folder was last updated. | |
| ExtraUrlParameters | String | Optional input-only property for specifying additional query parameters when retrieving folder data. Format: 'param1=value1, param2=value2, param3=value3'. |