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 add-in uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.
| Column | Supported Operators |
| Id | = |
| Type | = |
| CreatedAt | =, <, >, <=, >= |
| CreatedBy | = |
SELECT * FROM FileManagerFiles WHERE Id = '1245'
SELECT * FROM FileManagerFiles WHERE Type = 'file'
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'
Additionally the Name, Size, and CreatedAt columns can be used in the ORDER BY clause, as follows:
SELECT * FROM FileManagerFiles ORDER BY Name DESC
SELECT * FROM FileManagerFiles ORDER BY Size ASC
SELECT * FROM FileManagerFiles ORDER BY CreatedAt DESC
Insert
The Name, FolderId, and FileData columns are required for INSERT operations.
INSERT INTO FileManagerFiles (Name, FolderID, FileData) VALUES ('myNewFolder', 'myFolderID', 'myBase64EncodedFileData')
Columns
| Name | Type | ReadOnly | References | 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. |