CustomFields
Retrieve custom fields metadata.
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 '=', '<', '<=', '>', '>='.
- CreatedAt supports '=', '<', '<=', '>', '>='.
- UpdatedAt supports '=', '<', '<=', '>', '>='.
For example, the following queries are processed server side:
SELECT * FROM CustomFields WHERE Id = 50 SELECT * FROM CustomFields WHERE CreatedAt > '01/01/2022' SELECT * FROM CustomFields WHERE UpdatedAt < '01/01/2022'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Int64 | True |
Pardot ID for this custom field. | |
| Name | String | False |
Custom field's name. | |
| FieldId | String | True |
API ID for custom field. | |
| Type | String | False |
The type of field. | |
| CreatedAt | Datetime | True |
Time custom field was created in Pardot. | |
| UpdatedAt | Datetime | True |
Last time custom field was updated. | |
| CreatedById | Int64 | False |
ID of the individual who created this object. | |
| UpdatedById | Int64 | False |
ID of the individual who last updated this object. | |
| IsRecordMultipleResponses | Boolean | False |
If true, this custom field will record multiple responses. | |
| IsUseValues | Boolean | False |
If true, this custom field will use predefined values. | |
| SalesforceId | String | False |
The alpha-numeric Id of the Salesforce Org. | |
| IsRequired | String | False |
True if the custom field is required. | |
| isAnalyticsSynced | Boolean | False |
True if the object is synced to Analytics. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ValuesPrefill | String |
Write-Only field on create operation. Possible values: Countries, |