FileManagerFolders
A listing of all avaialable folders within an account's gallery.
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 id given to the folder. |
| Name | String | False |
The name of the folder. |
| FileCount | Integer | True |
The number of files within the folder. |
| CreatedAt | Datetime | True |
The date and time a file was added to the gallery. |
| CreatedBy | String | True |
The username of the profile that created the folder. |