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
A FolderId is required to retrieve data from this table. If none is specified in the WHERE clause, the first one available for your account will be used.
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 [KEY] | 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. |