CustomFields
Retrieve custom fields metadata.
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 '=', '<', '<=', '>', '>='.
- 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 | False |
User-defined ID for the custom field. | |
| Type | String | False |
The type of custom field. Possible values: Text, Radio Button, Checkbox, Dropdown, Textarea, Multi-Select, Hidden, Number, Date, CRM User | |
| CreatedAt | Datetime | True |
Time custom field was created in Pardot. | |
| UpdatedAt | Datetime | True |
Last time custom field was updated. | |
| CreatedById | Int64 | True |
ID of the individual who created this object. | |
| UpdatedById | Int64 | True |
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 | Boolean | False |
True if the custom field is required. | |
| isAnalyticsSynced | Boolean | True |
True if the object is synced to Analytics. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| ValuesPrefill | String |
Write-Only field on create operation. Possible values: Countries, Country Codes, US States, US State Codes, Canadian Provinces, Canadian Province Codes, US States and Canadian Provinces, US State and Canadian Province Codes, Japanese Prefectures, Japanese Prefecture Codes |