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