SSIS Components for Salesforce Marketing Cloud Account Engagement

Build 24.0.9060

LandingPages

Retrieving a collection of landing pages

Table Specific Information

Select

The component 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 component.

  • 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 References Description
Id [KEY] Int64 ID of the object.
Name String Name of the object for identification in Pardot.
SalesforceId String ID of the Salesforce object representing this object.
IsDeleted Boolean True if the object is in the recycle bin in Pardot.
CreatedById Int64 ID of the user who created this object.
CreatedAt Datetime Creation time of the object.
UpdatedAt Datetime Last update time of the object.
UpdatedById Int64 ID of the user who last updated this object.
CampaignId Int64 Pardot Campaign related to this object.
FormId Int64 ID of the form related to this object.
LayoutTemplateId Int64 ID of the layout template related to this object.
Title String The landing page's title.
Description String The landing page's meta description. Used for SEO.
IsDoNotIndex Boolean True if the landing page is hidden from search engine indexing.
LayoutType String Specifies where the landing page was created. Possible values are Layout Template, Landing Page Builder, Legacy Page Builder, Salesforce Builder.
ScriptFragment String Script specified for the landing page. Available only on read requests.
LayoutCss LayoutCss CSS code for the layout template. Available only on read requests.
LayoutCssGenerated String Generated CSS code for the layout template. Available only on read requests.
LayoutTableBorder Int Specifies the layout table border width.
RedirectLocation String The redirect URL used if the prospect is redirected instead of showing the thank you content.
IsUseRedirectLocation Boolean True if the prospect is redirected instead of showing the form thank you content.
BitlyIsPersonalized Boolean True if the object has a bitly URL that is personalized.
BitlyShortUrl String Bitly URL if present.
Url String Link for the landing page.
VanityUrl String Vanity URL if present.
VanityUrlPath String The unique path for the asset, used to create the vanity URL.
TrackerDomainId Int64 The ID of the tracker domain associated with this object.
FolderId Int64 The ID of the folder associated with this object.

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