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 provider 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 provider.
| 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. |