JDBC Driver for Marketo

Build 22.0.8462

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

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 must specify the ID field.

DELETE FROM LandingPageTemplates WHERE Id = 1312

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462