LandingPageTemplates

Create, update, delete and query LandingPageTemplates for a Marketo organization.

Table Specific Information

Select

Note: All filterable columns must be specified using the '=' operator.

Retrieve a list of accessible landing page templates from the target instance, filterable by Name, Status and folder.

SELECT * FROM LandingPageTemplates WHERE Status = 'draft'

SELECT * FROM LandingPageTemplates WHERE FolderId = 1184 AND FolderType = 'Program'

Retrieve the landing page template record for the given name or a target Id.

SELECT * FROM LandingPageTemplates WHERE Id = 1234

SELECT * FROM LandingPageTemplates WHERE Name = 'Agenda'

INSERT

To create a new LandingPageTemplate, specify at least the Name, FolderId, FolderType and TemplateType column.

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

Update

Any field that is not read-only can be updated.

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

Delete

To delete a LandingPageTemplate you can specify the ID or Name field.

DELETE FROM LandingPageTemplates WHERE Id = 1312
DELETE FROM LandingPageTemplates WHERE Name in ('Test1', 'Test2')

Columns


Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Integer	True	True	Id of the asset.
Name	String	False	True	Name of the asset.
CreatedAt	Datetime	True		Datetime the asset was created.
Description	String	False		Description of the asset.
EnableMunchkin	Boolean	False		Whether to enable munchkin on the derived pages. Defaults to true. The default value is true.
FolderId	Integer	False	True	Id of the folder.
FolderType	String	False	True	Type of folder. The allowed values are Folder, Program.
FolderName	String	False		Name of folder.
Status	String	True	True	Status filter for draft or approved versions. The allowed values are draft, approved.
TemplateType	String	False		Type of template to create 'guided' or 'freeForm' The allowed values are guided, freeForm. The default value is freeForm.
UpdatedAt	Datetime	True		Datetime the asset was most recently updated.
Url	String	True		Url of the asset in the Marketo UI.
Workspace	String	True		Name of the workspace.