Forms
Retrieve forms.
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 '=', '<', '<=', '>', '>='.
- 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. |