Files
Searches for files stored in HubSpot's file manager, excluding hidden and archived files.
View Specific Information
SELECT
When selecting Files, they can be filtered by columns marked below as 'Filterable'. For these columns, except for the ParentFolderId column (which also supports the IN operator), the only supported server-side operator is =.
SELECT * FROM Files; SELECT * FROM Files WHERE Id ='159487201435';
Columns
| Name | Type | References | Filterable | Description |
| Id [KEY] | Long | True | Unique identifier of the file. | |
| Name | String | True | The name assigned to the file. | |
| Extension | String | True | The file extension indicating its format, such as 'png' or 'pdf'. | |
| Access | String | False | Specifies the file's access level, such as public or private.
The allowed values are PUBLIC_INDEXABLE, PUBLIC_NOT_INDEXABLE, PRIVATE. | |
| CreatedAt | Datetime | False | The date and time when the file was first created in HubSpot. | |
| UpdatedAt | Datetime | False | The timestamp of the most recent update to the file. | |
| Archived | Bool | False | Indicates whether the file has been deleted or archived. | |
| ArchivedAt | Datetime | False | The date and time when the file was archived or deleted. | |
| Type | String | True | The type or category of the file, such as image, document, or video.
The allowed values are IMG, DOCUMENT, AUDIO, MOVIE, OTHER. | |
| IsUsableInContent | Bool | True | Whether this file is available for use when creating content such as emails or website pages. | |
| Encoding | String | True | The file's encoding type, if applicable. | |
| Size | Long | True | The file size measured in bytes. | |
| Height | Int | True | The height of the file content in pixels, applicable to images and videos. | |
| Width | Int | True | The width of the file content in pixels, applicable to images and videos. | |
| Path | String | False | The directory path of the file in HubSpot's file manager. | |
| ParentFolderId | Long | True | The ID of the folder where the file is stored. | |
| Url | String | True | The live URL of the file, reflecting domain settings for the account. | |
| DefaultHostingUrl | String | False | HubSpot's default hosting URL used to serve the file. | |
| AllowsAnonymousAccess | Bool | True | Indicates whether the file is accessible anonymously (public) or requires authentication (private). |