SSIS Components for Salesforce Marketing Cloud Account Engagement

Build 23.0.8839


Retrieve custom fields metadata.

Table Specific Information


The component will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the component.

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


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

The type of field.

CreatedAt Datetime True

Time custom field was created in Pardot.

UpdatedAt Datetime True

Last time custom field was updated.

CreatedById Int64 False

ID of the individual who created this object.

UpdatedById Int64 False

ID of the individual who last updated this object.

IsRecordMultipleResponses Boolean False

If true, this custom field will record multiple responses.

IsUseValues Boolean False

If true, this custom field will use predefined values.

SalesforceId String False

The alpha-numeric Id of the Salesforce Org.

IsRequired String False

True if the custom field is required.

isAnalyticsSynced Boolean False

True if the object is synced to Analytics.


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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839