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