Excel Add-In for Marketo

Build 23.0.8839

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.

使用できる値は次のとおりです。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.

デフォルト値はfalseです。

Keywords String False

Keywords

MobileEnabled Boolean False

Whether the page has mobile viewing enabled. Free-form pages only. Default false.

デフォルト値はfalseです。

Robots String False

Robots directives to apply to the pages meta tags

Status String True True

Status filter for draft or approved versions.

使用できる値は次のとおりです。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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839