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 can specify the ID or Name field.

DELETE FROM SmartLists WHERE Id = 1142
DELETE FROM SmartLists WHERE Name in ('Test1', 'Test2')

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.