Query Static 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 StaticLists WHERE Id='1556'
	SELECT * FROM StaticLists WHERE Name='Anti-Smart List'
	SELECT * FROM StaticLists WHERE FolderId='12'
	SELECT * FROM StaticLists WHERE FolderType='Folder'
	SELECT * FROM StaticLists WHERE FolderId='6113' AND FolderType='Program'
	SELECT * FROM StaticLists WHERE UpdatedAt = '2024-01-17T14:31:26.000'
	SELECT * FROM StaticLists WHERE UpdatedAt > '2023-06-07T08:00:01.000'
	SELECT * FROM StaticLists WHERE UpdatedAt >= '2023-06-07T08:00:01.000'
	SELECT * FROM StaticLists WHERE UpdatedAt < '2023-06-07T08:00:01.000'
	SELECT * FROM StaticLists WHERE UpdatedAt <= '2023-06-07T08:00:01.000'
	SELECT * FROM StaticLists WHERE UpdatedAt >= '2022-09-01T14:08:37.000' AND UpdatedAt < '2023-10-06T10:43:02.000'

Insert

	INSERT INTO StaticLists (Name, FolderId, FolderType, Description) VALUES ('test insert StaticLists', '6152', 'Program', 'Test Insert Description')

Update

	UPDATE StaticLists Set Name = 'UpdatedStaticList', Description = 'CData StaticList' WHERE Id = 1570

Delete

	DELETE FROM StaticLists WHERE Id=1561
	DELETE FROM StaticLists WHERE Name='test'
	DELETE FROM StaticLists WHERE ID IN (1563, 1564, 1565, 111)
	DELETE FROM StaticLists WHERE Name IN ('test46AU1gBBg1', 'asd', 'testsDxzV3BAqn')

Columns