FileManagerFiles
A listing of all avaialable images and files within an account's gallery.
Table Specific Information
SELECT, INSERT, UPDATE, and DELETE are supported for FileManagerFiles.
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.
- Type supports the '=' operator.
SELECT * FROM FileManagerFiles WHERE Id = '1245' SELECT * FROM FileManagerFiles WHERE CreatedAt = '2024-02-07 00:00:37.0' SELECT * FROM FileManagerFiles WHERE CreatedAt >= '2024-02-07 00:00:37.0' SELECT * FROM FileManagerFiles WHERE CreatedAt <= '2024-02-07 00:00:37.0' SELECT * FROM FileManagerFiles WHERE CreatedAt > '2024-02-07 00:00:37.0' SELECT * FROM FileManagerFiles WHERE CreatedAt < '2024-02-07 00:00:37.0' SELECT * FROM FileManagerFiles WHERE CreatedBy = 'abcd' SELECT * FROM FileManagerFiles WHERE Type = 'file'
Insert
The Name, FolderId, and FileData are required for INSERTs.
INSERT INTO FileManagerFiles (Name, FolderID, FileData) VALUES ('myNewFolder', 'myFolderID', 'myBase64EncodedFileData')
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
The unique id given to the file. |
| FolderId | Integer | False |
The id of the folder. |
| Type | String | True |
The type of file in the gallery: Image or file. |
| Name | String | False |
The name of the file. |
| FullSizeUrl | String | True |
The url of the full-size file. |
| ThumbnailUrl | String | True |
The url of the thumbnail preview. |
| Size | Integer | True |
The size of the file in bytes. |
| CreatedAt | Datetime | True |
The date and time a file was added to the gallery. |
| CreatedBy | String | True |
The username of the profile that uploaded the file. |
| Width | Integer | True |
The width of the image. |
| Height | Integer | True |
The height of an image. |
| FileData | String | False |
When adding a new file, the base64-encoded file. Required for INSERT statement. |