CustomFields
Retrieve and modify custom fields.
Table Specific Information
Select
The driver will use the Salesforce Pardot API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
- Id supports '=', '<', '<=', '>', '>='.
- CreatedAt supports '=', '<', '<=', '>', '>='.
For example, the following queries are processed server side:
SELECT * FROM CustomFields WHERE Id = 50 SELECT * FROM CustomFields WHERE CreatedAt > '01/01/2019'
Insert
The following attributes are required when performing an insert: FieldId, Name.
INSERT INTO CustomFields(FieldId, Name) VALUES(100, 'Example')
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 |
type of field. | |
| TypeId | Int64 | True |
Pardot ID for custom field's type. | |
| CreatedAt | Datetime | True |
Time custom field was created in Pardot. | |
| UpdatedAt | Datetime | True |
Last time custom field was updated. | |
| IsRecordMultipleResponses | Boolean | False |
If true, this custom field will record multiple responses. | |
| CrmId | String | False |
The CRM ID of the field you would like to map to this custom field. | |
| IsUseValues | Boolean | False |
If true, this custom field will use predefined values. |