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