JDBC Driver for Mailchimp

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462