FILES
- Last Updated: March 4, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- HubSpot 8.0
- Documentation
Endpoint
https://api.hubapi.com/filemanager/api/v2/files
Columns
The FILES table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| ID* | BigInt |
| ALTKEY | VarChar(130) |
| ALTURL | VarChar(172) |
| CREATEDAT | Timestamp(3) |
| DELETEDAT | Timestamp(3) |
| EXTENSION | VarChar(64) |
| FILE_HASH | VarChar(64) |
| FOLDERID | BigInt |
| FRIENDLYURL | VarChar(174) |
| HEIGHT | Integer |
| ICONFRIENDLYURL | VarChar(187) |
| ICONIMAGENAME | VarChar(64) |
| ICONS3URL | VarChar(186) |
| ISARCHIVED | Boolean |
| MEDIUMFRIENDLYURL | VarChar(190) |
| MEDIUMIMAGENAME | VarChar(64) |
| MEDIUMS3URL | VarChar(189) |
| META_ALLOWS_ANONYMOUS_ACCESS | Boolean |
| META_URL_SCHEME | VarChar(64) |
| NAME | VarChar(64) |
| PORTAL_ID | Integer |
| S3_URL | VarChar(172) |
| SIZE | Integer |
| THUMBFRIENDLYURL | VarChar(189) |
| THUMBIMAGENAME | VarChar(64) |
| THUMBS3URL | VarChar(187) |
| TITLE | VarChar(64) |
| TYPE | VarChar(64) |
| UPDATEDAT | Timestamp(3) |
| URL | VarChar(174) |
| WIDTH | Integer |