FileManagerFolderFiles
Lists files organized within specific folders in the Mailchimp File Manager.
Table Specific Information
Select
The connector 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 connector.
- 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. |