LandingPageTemplates
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
| Name | Type | ReadOnly | Operators | Description |
| Id [KEY] | Int | True | = |
The unique, Marketo-assigned identifier of the landing page template. |
| Status [KEY] | String | True | = |
Status of the landing page template, draft or approved versions. |
| Name | String | False | = |
The name of the landing page template. |
| Description | String | False |
The description of the landing page template. | |
| EnableMunchkin | Bool | False |
Whether to enable munchkin on the derived pages. Defaults to true. | |
| TemplateType | String | False |
Type of template to create 'guided' or 'freeForm' | |
| URL | String | True |
The URL of the landing page in the Marketo UI. | |
| WorkspaceName | String | True |
Workspace name of the asset. | |
| 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 template was created. | |
| UpdatedAt | Datetime | True |
Datetime the landing page template was most recently updated. |