FileManagerFolderFiles
Lists files organized within specific folders in the Mailchimp File Manager.
View-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| FolderId | = |
SELECT * FROM FileManagerFolderFiles
SELECT * FROM FileManagerFolderFiles WHERE FolderId = '1002'
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier assigned to the file within Mailchimp's File Manager, used to locate and manage the file programmatically. | |
| FolderId [KEY] | Integer | The unique identifier of the folder where the file is stored, allowing grouping of assets such as images, documents, and templates for easier organization. | |
| CreatedAt | Datetime | The date and time when the file was uploaded or created in the File Manager, recorded in ISO 8601 format for auditing and version tracking. | |
| CreatedBy | String | The username or identifier of the Mailchimp account user who uploaded or added the file, helping track content ownership and contributions. | |
| FullSizeUrl | String | The direct URL to access or download the full-size version of the file, typically used when embedding assets in campaigns or templates. | |
| Height | Integer | The height of the file in pixels, available for image files to support responsive design and layout control. | |
| Name | String | The display name of the file as it appears in the File Manager interface and when referenced in campaigns or automations. | |
| Size | Integer | The size of the file in bytes, representing the storage space used by this individual file. | |
| ThumbnailUrl | String | The URL for the thumbnail preview of the file, used in the File Manager and editor interfaces to visually identify assets. | |
| Type | String | Specifies the file type, such as 'image', 'document', or 'video', determining how the file can be previewed or embedded in campaigns. | |
| Width | Integer | The width of the file in pixels, available for image files to assist with media placement and optimization. | |
| TotalFileSize | Decimal | The cumulative size of all files stored in the File Manager, expressed in bytes, providing insight into total storage utilization for the account. |