CustomFields
Retrieve custom fields metadata.
Table Specific Information
Select
The driver will use the Salesforce Pardot API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.
- 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 | References | Description |
| Id [KEY] | Int64 | Pardot ID for this custom field. | |
| Name | String | Custom field's name. | |
| FieldId | String | API ID for custom field. | |
| Type | String | The type of field. | |
| CreatedAt | Datetime | Time custom field was created in Pardot. | |
| UpdatedAt | Datetime | Last time custom field was updated. | |
| CreatedById | Int64 | ID of the individual who created this object. | |
| UpdatedById | Int64 | ID of the individual who last updated this object. | |
| IsRecordMultipleResponses | Boolean | If true, this custom field will record multiple responses. | |
| IsUseValues | Boolean | If true, this custom field will use predefined values. | |
| SalesforceId | String | The alpha-numeric Id of the Salesforce Org. | |
| IsRequired | String | True if the custom field is required. | |
| isAnalyticsSynced | Boolean | 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, |