Files
Provides metadata about files stored in HubSpot's file manager, enabling file management and auditing.
Table Specific Information
Files represent any files you have uploaded with HubSpot to your content optimization system.
SELECT
When selecting files, they can only be filtered by the Id, Name, AltKey, IsArchived, CreatedAt, DeletedAt, Extension, FolderId, and Type. Name can be used with the LIKE comparison. Type can be used with both = and <>. CreatedAt and DeletedAt can be used with the > and < comparisons but cannot form a range. For example:
SELECT * FROM Files WHERE CreatedAt >= '1/1/2014' SELECT * FROM Files WHERE DeletedAt <= '1/1/2014' SELECT * FROM Files WHERE Type <> 'IMG' SELECT * FROM Files WHERE Name LIKE 'filename'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Unique identifier assigned to the file. | |
| Name | String | Internal name used to reference the file within HubSpot. | |
| FriendlyUrl | String | Public URL for accessing the file directly via a web browser for viewing or download. | |
| AltKey | String | Alternative key used to generate a URL without including the file ID, useful for preserving relative paths when uploading collections of files. | |
| AltUrl | String | Alternative URL of the file, generated without the auto-generated file ID using the alternative key. | |
| IsArchived | Boolean | Boolean indicating whether the file is archived and hidden from the dashboard but still publicly accessible. | |
| CreatedAt | Datetime | Timestamp showing when the file was initially created. | |
| DeletedAt | Datetime | Timestamp showing when the file was deleted, if applicable. | |
| Extension | String | File extension indicating the file type, such as .jpg or .pdf. | |
| FolderId | Long |
Folders.Id | Identifier of the folder containing the file. |
| RSUploadedAt | Datetime | Timestamp showing when the file was uploaded via Remote Server (RS). | |
| S3UploadedAt | Datetime | Timestamp showing when the file was uploaded via Amazon S3. | |
| Size | Long | File size in bytes. | |
| IsSynced | Boolean | Boolean indicating whether the file is a call-to-action (CTA) image synced with HubSpot. | |
| Title | String | Title or display name of the file. | |
| Type | String | String enumeration representing the type of file, such as document or image.
The allowed values are IMG, TEXT, DOCUMENT, OTHER. | |
| UpdatedAt | Datetime | Timestamp showing when the file was last updated. | |
| Version | Double | Version number of the file. | |
| Height | Integer | Height in pixels of the image file. Applicable to image files only. | |
| Width | Integer | Width in pixels of the image file. Applicable to image files only. | |
| ExtraUrlParameters | String | Optional input-only property for specifying additional query parameters when retrieving file data. Format: 'param1=value1, param2=value2, param3=value3'. |