MuleSoft Connector for Salesforce Pardot

Build 21.0.7930

Lists

Retrieve and modify lists.

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 '=', '<', '<=', '>', '>='.
  • Name supports '='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.
  • UpdatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM Lists WHERE Id = 25
SELECT * FROM Lists WHERE Name = 'Customers'
SELECT * FROM Lists WHERE CreatedAt > '2019-07-08 11:15:14'

Insert

This table does not have any required attributes when performing an insert.

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Pardot ID of this list.

Name String False

List's name (internal to Pardot).

IsPublic Boolean False

If true, list will show on EPC pages to prospects.

IsDynamic Boolean True

If true, list has prospects dynamically added to it via a set of chosen rules.

Title String False

List's title (visible to subscribers).

Description String False

List's description.

IsCrmVisible Boolean False

If true, list will be visible in CRM to add or remove from.

CreatedAt Datetime True

Time list was created in Pardot.

UpdatedAt Datetime True

Last time list was updated.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930