Lists

Query Static Lists for a Marketo organization from the Leads API.

This table contains the same records as StaticLists, however it has different columns and server-side filters that might be of use since the tables are retrieved from differnt API endpoints.

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 Lists WHERE Id=1556
	SELECT * FROM Lists WHERE Id IN (1556, 1057)
	SELECT * FROM Lists WHERE Name='test0319'
	SELECT * FROM Lists WHERE ProgramName='ImportTest0407'
	SELECT * FROM Lists WHERE WorkspaceName='Default' AND Id=1014

Columns


Name	Type	Operators	Description
Id [KEY]	Int	=,IN	Id of the static list.
Name	String	=,IN	Name of the static list.
Description	String		Description of the static list.
ProgramName	String	=,IN	Name of the program.
WorkspaceId	Int		WorkspaceId of the static list.
WorkspaceName	String	=,IN	Name of the workspace the static list is part of.
CreatedAt	Datetime		Datetime the static list was created.
UpdatedAt	Datetime		Datetime the static list was most recently updated.

Excel Add-In for Marketo

Lists

Select

Columns