SmartLists

Query Smart Lists for a Marketo organization.

Select

Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.

	SELECT * FROM SmartLists WHERE Id='1093'
	SELECT * FROM SmartLists WHERE Name='LeadSmartListTest'
	SELECT * FROM SmartLists WHERE FolderId=7
	SELECT * FROM SmartLists WHERE ProgramId=6116
	SELECT * FROM SmartLists WHERE SmartCampaignId=1043
	SELECT * FROM SmartLists WHERE UpdatedAt = '2021-02-02T08:26:01Z'
	SELECT * FROM SmartLists WHERE UpdatedAt > '2021-02-02T08:26:01Z'
	SELECT * FROM SmartLists WHERE UpdatedAt >= '2021-02-02T08:26:01Z'
	SELECT * FROM SmartLists WHERE UpdatedAt <' 2022-06-08T06:17:24Z'
	SELECT * FROM SmartLists WHERE UpdatedAt <=' 2022-06-08T06:17:24Z'

Delete

	DELETE FROM SmartLists WHERE Id=3991
	DELETE FROM SmartLists WHERE ID IN (3560, 1266, 3999)
	DELETE FROM SmartLists WHERE Name='TestProgram Opportunities'
	DELETE FROM SmartLists WHERE Name IN ('test_from_ui', 'JET - email tests')

Columns


Name	Type	ReadOnly	Operators	Description
Id [KEY]	Int	False	=	Id of the smart list.
Name	String	False	=	Name of the smart list.
Description	String	False		Description of the smart list.
URL	String	False		The URL of the smart list in the Marketo UI
WorkspaceName	String	False		Name of the workspace the smart list is part of.
FolderId	Int	False	=	The unique, Marketo-assigned identifier of the parent folder/program.
FolderType	String	False	=	The type of folder (Folder,Program)
CreatedAt	Datetime	False		Datetime the smart list was created.
UpdatedAt	Datetime	False	=,>,<,>=,<=	Datetime the smart list was most recently updated.
SmartCampaignId	Int	False	=	Mirror column that can be used only as a filter. Will retrieve SmartLists related to the given SmartCampaignId.
ProgramId	Int	False	=	Mirror column that can be used only as a filter. Will retrieve SmartLists related to the given email ProgramId.

Excel Add-In for Marketo

SmartLists

Select

Delete

Columns