LandingPages

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

Table Specific Information

Select

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

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

SELECT * FROM LandingPages WHERE Status = 'draft'

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

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

SELECT * FROM LandingPages WHERE Id = 1234

SELECT * FROM LandingPages WHERE Name = 'Agenda'

INSERT

To create a new LandingPage, specify at least the Name, FolderId, FolderType and Template column.

INSERT INTO LandingPages (CustomHeadHTML, Description, FacebookOgTags, FolderId, FolderType, Keywords, MobileEnabled, Name, FormPrefill, Robots, Template, Title, URL, Workspace) VALUES ('<!DOCTYPE html>\n<html>\n<body>\n<h1>My First Heading</h1>\n<p>My first paragraph.</p>\n</body></html>', 'Testing  Insert operation', '', 1184, 'Program', '', false, 'Test Insert', false, 'index, nofollow', 1, 'Insert Operation', 'http://na-ab23.marketo.com/lp/119-IEY-862/LPtest_08.html', 'CRH')

Update

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

UPDATE LandingPages SET CustomHeadHTML = '<!DOCTYPE html>\n<html>\n<body>\n<h1>My First Heading</h1>\n<p>My first paragraph.</p>\n</body></html>', Description = 'Testing Update', FacebookOgTags = '', Keywords = '', MobileEnabled = false, Name = 'Test Update', Robots = 'index, nofollow', Title = 'Update Operation', URL = 'http://na-ab23.marketo.com/lp/119-IEY-862/LPtest_08.html' WHERE Id = 1103

Delete

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

DELETE FROM LandingPages WHERE Id = 1996
DELETE FROM LandingPages 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.
ComputedUrl	String	True		Computed Url of the asset.
CreatedAt	Datetime	True		Datetime the asset was created.
CustomHeadHTML	String	False		Any custom HTML to embed in the tag of the page.
Description	String	False		Description of the asset.
FacebookOgTags	String	False		Any OpenGraph meta tags to apply to the page.
FolderId	Integer	False	True	Id of the folder.
FolderType	String	False	True	Type of folder. The allowed values are Folder, Program.
FolderName	String	False	False	Name of folder.
FormPrefill	Boolean	False		Boolean to toggle whether forms embedded in the page will prefill. Default false. The default value is false.
Keywords	String	False		Keywords
MobileEnabled	Boolean	False		Whether the page has mobile viewing enabled. Free-form pages only. Default false. The default value is false.
Robots	String	False		Robots directives to apply to the pages meta tags
Status	String	True	True	Status filter for draft or approved versions. The allowed values are approved, draft.
Template	Integer	False		Id of the template used.
Title	String	False		Title element of the landing page.
UpdatedAt	Datetime	True		Datetime the asset was most recently updated.
URL	String	False		Url of the asset in the Marketo UI. You have to send the URL path of the page while creating or updating.
Workspace	String	False		Name of the workspace.