SSIS Components for Mailchimp

Build 24.0.9062

FileManagerFiles

A listing of all avaialable images and files within an account's gallery.

テーブル固有の情報

FileManagerFiles ではSELECT、INSERT、UPDATE、およびDELETE がサポートされています。

Select


SELECT * FROM FileManagerFiles

Insert

INSERT には、Name、FolderId、およびFileData を指定する必要があります。

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062