Create, update, delete and query Landing Page Templates for a Marketo organization.

Note: This table uses the draft/approved versioning API. By default both versions are retrieved/modified. To interact with a specific version use the filter Status='draft' or Status='approved'.

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. The Name and Id filters will be processed server-side only if Status='approved'.

For example, the following queries are processed server-side:

	SELECT * FROM LandingPageTemplates WHERE Status='approved'
	SELECT * FROM LandingPageTemplates WHERE FolderId=19
	SELECT * FROM LandingPageTemplates WHERE Name='Test Insert 1' AND Status='approved'
	SELECT * FROM LandingPageTemplates WHERE Id=3 AND Status='approved'

Insert

	INSERT INTO LandingPageTemplates (Name, TemplateType, Description, EnableMunchkin, FolderId, FolderType)
	VALUES ('Test Insert 1', 'guided', 'Testing Insert', true, 19, 'Folder')

Update

	UPDATE LandingPageTemplates SET Description='Testing Update', EnableMunchkin=false, Name='Test Update' WHERE Id=1

Delete

	DELETE FROM LandingPageTemplates WHERE Id=2 AND Status='approved'
	DELETE FROM LandingPageTemplates WHERE Name='Test Insert 1'

Columns