JDBC Driver for Salesforce Pardot

Build 22.0.8462

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.

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