Files
Query files for a Marketo organization.
CreateFile can be used to upload a file.
UpdateFile can be used to update the file content.
Select
Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.
SELECT * FROM Files WHERE id='421'
SELECT * FROM Files WHERE Name='CData.png'
SELECT * FROM Files WHERE FolderId='34'
SELECT * FROM Files WHERE FolderId='34' AND ParentType='Folder'
Columns
| Name | Type | Operators | Description |
| Id [KEY] | Int | = | The unique, Marketo-assigned identifier of the file. |
| Name | String | = | The name of the file. |
| Description | String | Description of the file. | |
| FolderId | Int | = | The unique, Marketo-assigned identifier of the folder. |
| FolderName | String | The Name of the folder | |
| FolderType | String | The type of folder (Folder,Program) | |
| MimeType | String | MIME type of the file | |
| Size | Int | Size of the file in bytes | |
| URL | String | The explicit URL of the asset in the designated instance. | |
| CreatedAt | Datetime | The date and time the folder was created. | |
| UpdatedAt | Datetime | The date and time the folder was last updated. | |
| ParentType | String | = | Mirror column used as server side filter for the type of the parent folder. Will be ignored when filtering by Id or Name. |