FileManagerFiles
Provides a catalog of all files and images stored in the account's File Manager, including metadata and size.
Table Specific Information
SELECT, INSERT, UPDATE, and DELETE are supported for FileManagerFiles.
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.
- Id supports the '=' operator.
- CreatedAt supports the '=,<,>,<=,>=' operator.
- CreatedBy supports the '=' operator.
- Type supports the '=' operator.
SELECT * FROM FileManagerFiles WHERE Id = '1245' SELECT * FROM FileManagerFiles WHERE CreatedAt = '2024-02-07 00:00:37.0' SELECT * FROM FileManagerFiles WHERE CreatedAt >= '2024-02-07 00:00:37.0' SELECT * FROM FileManagerFiles WHERE CreatedAt <= '2024-02-07 00:00:37.0' SELECT * FROM FileManagerFiles WHERE CreatedAt > '2024-02-07 00:00:37.0' SELECT * FROM FileManagerFiles WHERE CreatedAt < '2024-02-07 00:00:37.0' SELECT * FROM FileManagerFiles WHERE CreatedBy = 'abcd' SELECT * FROM FileManagerFiles WHERE Type = 'file'
Insert
The Name, FolderId, and FileData are required for INSERTs.
INSERT INTO FileManagerFiles (Name, FolderID, FileData) VALUES ('myNewFolder', 'myFolderID', 'myBase64EncodedFileData')
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
The unique identifier assigned to the file in Mailchimp's File Manager, used to reference or manage the file programmatically. |
| FolderId | Integer | False |
The unique identifier of the folder where the file is stored within the File Manager hierarchy, helping organize assets by category or campaign use. |
| Type | String | True |
Specifies the type of file stored in the gallery, such as 'image' or 'file', which determines how the file can be previewed or used in campaigns. |
| Name | String | False |
The human-readable name of the file as displayed in the Mailchimp File Manager or when attaching files to campaigns or templates. |
| FullSizeUrl | String | True |
The direct URL to the full-size version of the file, which can be used for downloading or embedding the file in campaigns or web pages. |
| ThumbnailUrl | String | True |
The URL of a smaller, thumbnail-sized preview image that allows quick visual identification of the file within the Mailchimp interface. |
| Size | Integer | True |
The total file size in bytes, useful for understanding storage usage or for filtering large files when managing assets. |
| CreatedAt | Datetime | True |
The exact date and time when the file was uploaded or added to the File Manager, stored in ISO 8601 format for accurate audit tracking. |
| CreatedBy | String | True |
The username or identifier of the Mailchimp user who uploaded the file, allowing traceability of asset ownership or contribution. |
| Width | Integer | True |
The width of the image file in pixels, available for image-type files to support layout or responsive design adjustments. |
| Height | Integer | True |
The height of the image file in pixels, available for image-type files to support display consistency and optimization. |
| FileData | String | False |
When uploading a new file, this field contains the file's binary data encoded in Base64 format. It is required for INSERT operations and enables programmatic uploads through the API. |