MuleSoft Connector for Salesforce Pardot

Build 21.0.7930

CustomFields

Retrieve and modify custom fields.

Table Specific Information

Select

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

  • 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 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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930