ODBC Driver for Marketo

Build 23.0.8839

Folders

Create, update, delete, and query Folders for a Marketo organization.

Table Specific Information

Select

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

Retrieve all folders within two levels of the folder hierarchy.

SELECT * FROM Folders

Retrieve all folders under a specific root folder.

SELECT * FROM Folders WHERE RootFolderId = 38 AND MaxDepth = 5

Insert

To create a new Folder, specify at least the Name, ParentId and ParentType column.

INSERT INTO Folders (Name, ParentId, ParentType) VALUES ('New_Folder_Marketo_CData_Driver', 38, 'Folder')

Update

Any field that is not read-only can be updated.

UPDATE Folders SET Description = 'Updated Folder', IsArchive = true WHERE Id = 1996

Delete

To delete a folder you can specify the ID or Name field. Deletions can be made against single folders if they are empty, meaning that they contain no assets or subfolders. If a folder is of type Program, or has the isSystem field set to true, it cannot be deleted.

DELETE FROM Folders WHERE Id = 1996
DELETE FROM Folders WHERE Name in ('Marketo1','Marketo2')

Columns

Name Type ReadOnly Filterable Description
Id [KEY] Integer True True

The unique, Marketo-assigned identifier of the folder.

Name String False True

The name of the folder.

Description String False

The description of the folder.

Type String True

The type of the folder.

CreatedAt Datetime True

The date and time the folder was created.

UpdatedAt Datetime True

The date and time the folder was last updated.

ParentId Integer False

The Id of the parent folder.

ParentType String False

The type of the parent folder.

Path String True

The path of a folder shows its hierarchy in the folder tree, similar to a Unix-style path.

WorkSpace String True True

The name of the smart campaign workspace.

URL String True

The explicit URL of the asset in the designated instance.

IsSystem Boolean True

Whether or not the folder is a system folder.

IsArchive Boolean False

Whether or not the folder is archived.

AccessZoneId Integer True

The access zone id

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
RootFolderId Integer

The parent folder ID under which the query will be performed.

RootFolderType String

The parent folder type under which the query will be performed.

The allowed values are Folder, Program.

The default value is Folder.

MaxDepth Integer

Maximum folder depth to traverse.

The default value is 2.

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