JDBC Driver for Salesforce Pardot

Build 22.0.8462

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,

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462