JDBC Driver for Salesforce Pardot

Build 22.0.8462

Forms

Retrieve forms.

Table Specific Information

Select

The driver will use the Salesforce Pardot API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

  • 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 References Description
Id [KEY] Int64 Pardot ID for this form.
Name String Form's name.
CampaignId Int64

Campaigns.Id

Pardot ID of the campaign associated with this form.
EmbedCode String The code used to embed the form on your webpage.
SalesforceId String The alpha-numeric Id of the Salesforce Org.
LayoutTemplateId Int64 The ID of the layout template associated with this object
SubmitButtonText String The label used for the submit button
BeforeFormContent String The HTML text displayed above the form
AfterFormContent String The HTML text displayed below the form
ThankYouContent String The HTML text displayed after the form is submitted
ThankYouCode String Thank you code is typically Javascript used to call other systems like Google Conversion Tracking
IsAlwaysDisplay Boolean Always display form after submission. Disable the 10 minute waiting period after submitting a form
RedirectLocation String Redirect to this URL instead of showing the
IsUseRedirectLocation Boolean When redirect location is valid and enabled.
FontSize String Possible values: default, 8pt, 10pt, 12pt, 14pt , 18pt, 24pt, 36pt.
FontFamily String Possible values: default,
FontColor String 6 digit number in hexadecimal format such as #123456
LabelAlignment String Possible values: default, above, left
RadioAlignment String Possible values: default, horizontal, stacked
CheckboxAlignment String Possible values: default, horizontal, stacked
RequiredCharacter String Possible values: default , *
IsCookieless String Kiosk/Data Entry Mode: Do not cookie browser as submitted prospect
ShowNotProspect Boolean Include
IsCaptchaEnabled Boolean Enable explicit bot protecting using reCAPTCHA
IsDeleted Boolean True if the object is in the recycle bin in Pardot.
TrackerDomainId Int64 The ID of the tracker domain associated with this object.
FolderId Int64 ID of the folder containing this object.
CreatedAt Datetime The timestamp of when this object was created.
UpdatedAt Datetime The timestamp of when this object was last updated.
CreatedById Int64 ID of the individual who created this object.
UpdatedById Int64 ID of the individual who last updated this object.

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