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