JDBC Driver for Marketo

Build 22.0.8462

SmartLists

Query and delete SmartLists for a Marketo organization.

Table Specific Information

Select

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

Retrieve all smart lists

SELECT * FROM SmartLists

Retrieve a specific smart list

SELECT * FROM SmartLists WHERE Id=1142

Delete

To delete a smart list you must specify the ID field.

DELETE FROM SmartLists WHERE Id=1142

Columns

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

The Id of the smart list.

Name String True True

The name of the smart list.

CreatedAt Datetime True

The date and time the smart list was created.

Description String True

The description of the Smart list

UpdatedAt Datetime True

The date and time the smart list was last updated.

WorkSpace String True

The name of the workspace where the smart list is located.

Url String True

The url of the smart list.

FolderId Integer False

The Id of the folder.

FolderType String False

The type of folder.

The allowed values are Folder, Program.

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
EarliestUpdatedAt Datetime

Exclude smart list prior to this date.

LatestUpdatedAt Datetime

Exclude smart list after this date.

Folder String

JSON representation of parent folder, with members 'id', and 'type' which may be 'Folder' or 'Program'.

SmartCampaignId Integer

The Id of the smart campaign

ProgramId Integer

The Id of the Program

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