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
SELECT * FROM FileManagerFiles
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. |