Folders
Retrieves information about the available folders in HubSpot.
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 | The id of the folder. | |
| Category | Integer | The category of the folder. | |
| CreatedAt | Datetime | When the folder was created. | |
| DeletedAt | Datetime | When the folder was deleted. | |
| FullPath | String | The full path to the folder. | |
| Name | String | The name of the folder. | |
| ParentFolderId | Long |
Folders.Id | The id of the parent folder for this folder if available. |
| UpdatedAt | Datetime | When the folder was last updated. | |
| ExtraUrlParameters | String | An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'. |