Power BI Connector for Salesforce Marketing Cloud Account Engagement

Build 25.0.9454

LandingPages

Retrieving a collection of landing pages

Table Specific Information

Select

The connector will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.

  • Id supports '=', '<', '<=', '>', '>=', 'IN'.
  • IsDeleted supports '='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.
  • UpdatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM LandingPages WHERE Id = 50
SELECT * FROM LandingPages WHERE IsDeleted = 'true'
SELECT * FROM LandingPages WHERE CreatedAt > '01/01/2022'

GetDeleted

To retrieve LandingPages that are in the recycle bin in Pardot the following operation is supported:

GETDELETED FROM LandingPages

Columns

Name Type ReadOnly References Description
Id [KEY] Int64 True

ID of the object.

Name String False

Name of the object for identification in Pardot.

SalesforceId String True

ID of the Salesforce object representing this object.

IsDeleted Boolean True

True if the object is in the recycle bin in Pardot.

CreatedById Int64 True

ID of the user who created this object.

CreatedAt Datetime True

Creation time of the object.

UpdatedAt Datetime True

Last update time of the object.

UpdatedById Int64 True

ID of the user who last updated this object.

CampaignId Int64 False

Pardot Campaign related to this object.

FormId Int64 False

ID of the form related to this object.

LayoutTemplateId Int64 False

ID of the layout template related to this object.

Title String False

The landing page's title.

Description String False

The landing page's meta description. Used for SEO.

IsDoNotIndex Boolean False

True if the landing page is hidden from search engine indexing.

LayoutType String True

Specifies where the landing page was created. Possible values are Layout Template, Landing Page Builder, Legacy Page Builder, Salesforce Builder.

ScriptFragment String False

Script specified for the landing page. Available only on read requests.

LayoutCss LayoutCss True

CSS code for the layout template. Available only on read requests.

LayoutCssGenerated String True

Generated CSS code for the layout template. Available only on read requests.

LayoutTableBorder Int True

Specifies the layout table border width.

RedirectLocation String False

The redirect URL used if the prospect is redirected instead of showing the thank you content.

IsUseRedirectLocation Boolean True

True if the prospect is redirected instead of showing the form thank you content.

BitlyIsPersonalized Boolean True

True if the object has a bitly URL that is personalized.

BitlyShortUrl String True

Bitly URL if present.

Url String True

Link for the landing page.

VanityUrl String True

Vanity URL if present.

VanityUrlPath String False

The unique path for the asset, used to create the vanity URL.

TrackerDomainId Int64 False

The ID of the tracker domain associated with this object.

FolderId Int64 False

ID of the folder containing this object.

ArchiveDate Date False

The landing page's archive date('yyyy-mm-dd').

Content String False

The editable content if using a stock template. This field isn’t queryable.

OpeningGeneralContent String False

If using a layout template without pardot-region attributes, this value is displayed in the %%form-opening-general-content%% tag. This field isn’t queryable.

RegionContent String False

If using a layout template that contains pardot-region attributes, the values here override the default values in the layout template. This field isn’t queryable.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454