LandingPages
Create, update, delete and query Landing Pages 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.
For example, the following queries are processed server-side:
SELECT * FROM LandingPages WHERE status='approved'
SELECT * FROM LandingPages WHERE folderId=1001
SELECT * FROM LandingPages WHERE folderId=1001 AND status='draft'
SELECT * FROM LandingPages WHERE name='string'
Insert
INSERT INTO LandingPages (Name, CustomHeadHTML, Description, FacebookOgTags, FolderId, FolderType, Keywords, MobileEnabled, Robots, Template, Title)
VALUES ('test insert landing page', '<!DOCTYPE html>\\n<html>\\n<body>\\n<h1>My landing page</h1>\\n<p>My landing page content.</p>\\n</body></html>', 'Testing Insert operation', '', 1184, 'Program', '', true, 'index, nofollow', 1, 'Insert Operation')
Update
UPDATE LandingPages SET Description='Testing Update', FacebookOgTags='', Keywords='',
MobileEnabled=false, Name='Test Update', Robots='index, nofollow',Title='Updating Landing Page',
CustomHeadHTML='<!DOCTYPE html>\n<html>\n<body>\n<h1>Updating Landing Page</h1>\n<p>Editing Landing Page</p>\n</body></html>'
WHERE Id=1009
Delete
Note: Approved landing pages cannot be deleted. Use UnApproveAsset to revoke landing page approval.
DELETE FROM LandingPages WHERE Id=1003
DELETE FROM LandingPages WHERE Id=1003 WHERE status='draft'
Columns
Name | Type | ReadOnly | Operators | Description |
Id [KEY] | Int | True | = |
The unique, Marketo-assigned identifier of the landing page. |
Status [KEY] | String | True | = |
Status filter for draft or approved versions. |
Name | String | False | = |
The name of the landing page. |
Description | String | False |
The description of the landing page. | |
Title | String | False |
Title element of the landing page. | |
URL | String | True |
The URL of the landing page in the Marketo UI. | |
ComputedURL | String | True |
Computed URL of landing page. | |
WorkspaceName | String | False |
Workspace name of the asset. | |
Template | Int | False |
Id of the template used. | |
Robots | String | False |
Robots directives to apply to the pages meta tags | |
MobileEnabled | Bool | False |
Whether the page has mobile viewing enabled. Free-form pages only. Default false. | |
CustomHeadHTML | String | False |
Any custom HTML to embed in the tag of the page. | |
Keywords | String | False |
Keywords | |
FormPrefill | Bool | True |
Boolean to toggle whether forms embedded in the page will prefill. Default false. | |
FacebookOgTags | String | False |
Any OpenGraph meta tags to apply to the page. | |
FolderId | Int | False | = |
The unique, Marketo-assigned identifier of the parent folder/program. |
FolderName | String | True |
The name of the folder | |
FolderType | String | False | = |
The type of folder (Folder,Program) |
CreatedAt | Datetime | True |
Datetime the landing page was created. | |
UpdatedAt | Datetime | True |
Datetime the landing page was most recently updated. |