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 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 add-in.
- Id supports the '=' operator.
- CreatedAt supports the '=,<,>,<=,>=' operator.
- CreatedBy supports the '=' operator.
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 is required for INSERTs.
INSERT INTO FileManagerFolders (Name) VALUES ('myNewFolder'')
Columns
| Name | Type | ReadOnly | 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. |