FileManagerFolderFiles
Lists files organized within specific folders in the Mailchimp File Manager.
Table Specific Information
Select
The add-in will use 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 add-in.
- FolderId supports the '=' operator.
SELECT * FROM FileManagerFolderFiles; SELECT * FROM FileManagerFolderFiles where FolderId=1002;
Columns
| Name | Type | 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. |