ODBC Driver for Salesforce Marketing Cloud Account Engagement

Build 23.0.8839

Forms

Retrieve forms.

Table Specific Information

Select

The 本製品 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 本製品.

  • Id supports '=', '<', '<=', '>', '>='.
  • IsDeleted supports '='.

For example, the following queries are processed server side:

SELECT * FROM Forms WHERE Id <= 17
SELECT * FROM Forms WHERE IsDeleted = 'true'

GetDeleted

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

GETDELETED FROM Forms 

Columns

Name Type ReadOnly References Description
Id [KEY] Int64 True

Pardot ID for this form.

Name String True

Form's name.

CampaignId Int64 True

Campaigns.Id

Pardot ID of the campaign associated with this form.

EmbedCode String True

The code used to embed the form on your webpage.

SalesforceId String True

The alpha-numeric Id of the Salesforce Org.

LayoutTemplateId Int64 True

The ID of the layout template associated with this object

SubmitButtonText String True

The label used for the submit button

BeforeFormContent String True

The HTML text displayed above the form

AfterFormContent String True

The HTML text displayed below the form

ThankYouContent String True

The HTML text displayed after the form is submitted

ThankYouCode String True

Thank you code is typically Javascript used to call other systems like Google Conversion Tracking

IsAlwaysDisplay Boolean True

Always display form after submission. Disable the 10 minute waiting period after submitting a form

RedirectLocation String True

Redirect to this URL instead of showing the

IsUseRedirectLocation Boolean True

When redirect location is valid and enabled.

FontSize String True

Possible values: default, 8pt, 10pt, 12pt, 14pt , 18pt, 24pt, 36pt.

FontFamily String True

Possible values: default,

FontColor String True

6 digit number in hexadecimal format such as #123456

LabelAlignment String True

Possible values: default, above, left

RadioAlignment String True

Possible values: default, horizontal, stacked

CheckboxAlignment String True

Possible values: default, horizontal, stacked

RequiredCharacter String True

Possible values: default , *

IsCookieless String True

Kiosk/Data Entry Mode: Do not cookie browser as submitted prospect

ShowNotProspect Boolean True

Include

IsCaptchaEnabled Boolean True

Enable explicit bot protecting using reCAPTCHA

IsDeleted Boolean True

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

TrackerDomainId Int64 True

The ID of the tracker domain associated with this object.

FolderId Int64 True

ID of the folder containing this object.

CreatedAt Datetime False

The timestamp of when this object was created.

UpdatedAt Datetime False

The timestamp of when this object was last updated.

CreatedById Int64 True

ID of the individual who created this object.

UpdatedById Int64 True

ID of the individual who last updated this object.

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