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.

Last updated