ADO.NET Provider for Salesforce Pardot

Build 21.0.8137


Retrieve and modify custom fields.

Table Specific Information


The provider 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 provider.

  • 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'


The following attributes are required when performing an insert: FieldId, Name.

INSERT INTO CustomFields(FieldId, Name) VALUES(100, 'Example')


Name Type ReadOnly References Description
Id [KEY] Integer 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 Integer 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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137