FileManagerFolders
Lists folders available in the File Manager for organizing images and files.
Table-Specific Information
SELECT, INSERT, UPDATE, and DELETE are supported for FileManagerFolders.
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 | = |
| CreatedAt | =, <, >, <=, >= |
| CreatedBy | = |
SELECT * FROM FileManagerFolders WHERE Id = '1245'
SELECT * FROM FileManagerFolders WHERE CreatedAt = '2024-02-07 00:00:37.0'
SELECT * FROM FileManagerFolders WHERE CreatedAt >= '2024-02-07 00:00:37.0'
SELECT * FROM FileManagerFolders WHERE CreatedAt <= '2024-02-07 00:00:37.0'
SELECT * FROM FileManagerFolders WHERE CreatedAt > '2024-02-07 00:00:37.0'
SELECT * FROM FileManagerFolders WHERE CreatedAt < '2024-02-07 00:00:37.0'
SELECT * FROM FileManagerFolders WHERE CreatedBy = 'abcd'
Insert
The Name column is required for INSERT operations.
INSERT INTO FileManagerFolders (Name) VALUES ('myNewFolder')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The unique identifier assigned to the folder within Mailchimp's File Manager, used to organize and manage groups of files programmatically. | |
| Name | String | False |
The display name of the folder as it appears in the Mailchimp File Manager, typically used to categorize files by campaign, asset type, or project. | |
| FileCount | Integer | True |
The total number of files currently stored in this folder, providing a quick overview of its content volume. | |
| CreatedAt | Datetime | True |
The date and time when the folder was created in the File Manager, stored in ISO 8601 format for audit and version tracking. | |
| CreatedBy | String | True |
The username or account identifier of the Mailchimp user who created the folder, allowing visibility into content ownership and management activity. |