FileManagerFolderFiles

List of files stored in Mailchimp file manager.

Table Specific Information

Select

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

FolderId supports the '=' operator.

For example:

SELECT * FROM FileManagerFolderFiles;
SELECT * FROM FileManagerFolderFiles where FolderId=1002;

Columns


Name	Type	Description
Id [KEY]	Integer	A unique identifier for the file.
FolderId [KEY]	Integer	The folder ID the file is stored in.
CreatedAt	Datetime	The date and time the file was created.
CreatedBy	String	The user who uploaded the file.
FullSizeUrl	String	The URL for the full-size file.
Height	Integer	The height of the file (if image).
Name	String	The name of the file.
Size	Integer	The size of the file in bytes.
ThumbnailUrl	String	The URL for the file's thumbnail.
Type	String	The file type.
Width	Integer	The width of the file (if image).
TotalFileSize	Decimal	The total size of all File Manager files in bytes.

ODBC Driver for Mailchimp

FileManagerFolderFiles

Table Specific Information

Select

Columns