Forms
Retrieve forms.
テーブル固有の情報
Select
connector はSalesforce Marketing Cloud Account Engagement API を使用して、以下のカラムと演算子で構築されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドでconnector 内部で処理されます。
- Id は '='、'<'、'<='、'>'、'>=' をサポートしています。
- IsDeleted は'=' をサポートしています。
例えば、次のクエリはサーバーサイドで処理されます。
SELECT * FROM Forms WHERE Id <= 17 SELECT * FROM Forms WHERE IsDeleted = 'true'
GetDeleted
Pardot のごみ箱にあるフォームを取得する場合、次の操作がサポートされています。
GETDELETED FROM Forms
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Int64 | True |
Pardot ID for this form. | |
| Name | String | False |
Form's name. | |
| CampaignId | Int64 | False |
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 | False |
The ID of the layout template associated with this object | |
| SubmitButtonText | String | False |
The label used for the submit button | |
| BeforeFormContent | String | False |
The HTML text displayed above the form | |
| AfterFormContent | String | False |
The HTML text displayed below the form | |
| ThankYouContent | String | False |
The HTML text displayed after the form is submitted | |
| ThankYouCode | String | False |
Thank you code is typically Javascript used to call other systems like Google Conversion Tracking | |
| IsAlwaysDisplay | Boolean | False |
Always display form after submission. Disable the 10 minute waiting period after submitting a form | |
| RedirectLocation | String | False |
Redirect to this URL instead of showing the | |
| IsUseRedirectLocation | Boolean | True |
When redirect location is valid and enabled. | |
| FontSize | String | False |
Possible values: default, 8pt, 10pt, 12pt, 14pt , 18pt, 24pt, 36pt. | |
| FontFamily | String | False |
Possible values: default, | |
| FontColor | String | False |
6 digit number in hexadecimal format such as #123456 | |
| LabelAlignment | String | False |
Possible values: default, above, left | |
| RadioAlignment | String | False |
Possible values: default, horizontal, stacked | |
| CheckboxAlignment | String | False |
Possible values: default, horizontal, stacked | |
| RequiredCharacter | String | False |
Possible values: default , * | |
| IsCookieless | String | False |
Kiosk/Data Entry Mode: Do not cookie browser as submitted prospect | |
| ShowNotProspect | Boolean | False |
Include | |
| IsCaptchaEnabled | Boolean | False |
Enable explicit bot protecting using reCAPTCHA | |
| IsDeleted | Boolean | True |
True if the object is in the recycle bin in Pardot. | |
| TrackerDomainId | Int64 | False |
The ID of the tracker domain associated with this object. | |
| FolderId | Int64 | False |
ID of the folder containing this object. | |
| CreatedAt | Datetime | True |
The timestamp of when this object was created. | |
| UpdatedAt | Datetime | True |
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. |