Files

Query Files for a Marketo organization.

Table Specific Information

Note: All filterable columns must be specified using the '=' operator.

Retrieves a list of Files for the target instance

SELECT * FROM Files

Retrieve the File for the given Id.

SELECT * FROM Files WHERE Id = '2012'

Name	Type	Filterable	Description
Id [KEY]	Integer	True	Id of the file.
Name	String	True	Name of the file.
CreatedAt	Datetime		Datetime when the file was created
Description	String		Description of the file
FolderId	Integer	True	Id of the folder
FolderName	String		The Name of the folder
FolderType	String	True	The Type of folder The allowed values are Folder, Program.
MimeType	String		MIME type of the file
Size	Integer		Size of the file in bytes
UpdatedAt	Datetime		Datetime when the file was most recently updated
Url	String		Publically accessible URL of the file
FileName	String		The filename for the file to insert.
File	String		Multipart file. Content of the file
InsertOnly	Boolean		Whether the calls hould fail if there is already an existing file with the same name