Files
Retrieves information about the available files in HubSpot.
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 | The unique id of the file. | |
| Name | String | The internal name of the file. | |
| FriendlyUrl | String | A full url to the file that can be used from a web browser to view or download the file. | |
| AltKey | String | An alternative file key. This is used for creationg the 'alt_url', which is a url for the file that does not include the file id. This is useful if you need to upload a collection of files where their relative location needs to preserved. | |
| AltUrl | String | The alternative file URL, without the auto-generated file id in it. This is generated by concatenating the alt_key to the base CDN url. | |
| IsArchived | Boolean | If True, the file will not show up in your dashboard, although the file will still be live. | |
| CreatedAt | Datetime | When the file was first created. | |
| DeletedAt | Datetime | When the file was deleted. | |
| Extension | String | The extension of the file. | |
| FolderId | Long |
Folders.Id | The id of the folder this file is in. |
| RSUploadedAt | Datetime | When the file was uploaded via RS. | |
| S3UploadedAt | Datetime | When the file was uploaded via S3. | |
| Size | Long | The size in bytes of the file. | |
| IsSynced | Boolean | A boolean indicating if this is a CTA image. | |
| Title | String | The title of the file. | |
| Type | String | A string enum for type of the file.
The allowed values are IMG, TEXT, DOCUMENT, OTHER. | |
| UpdatedAt | Datetime | When the file was last updated. | |
| Version | Double | The version of the file. | |
| Height | Integer | For images only, the height in pixels of the image. | |
| Width | Integer | For images only, the width in pixels of the image. | |
| 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'. |