JDBC Driver for Marketo

Build 22.0.8462

Files

Query Files for a Marketo organization.

Table Specific Information

Select

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'

Columns

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

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