Tableau Connector for Salesforce Pardot

Build 21.0.7930

ListMemberships

Retrieve and modify list memberships.

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

For example, the following queries are processed server side:

SELECT * FROM ListMemberships WHERE Id = 26
SELECT * FROM ListMemberships WHERE ListId = 44
SELECT * FROM ListMemberships WHERE CreatedAt > '01/01/2019'

Insert

The following attributes are required when performing an insert: ListId, ProspectId.

INSERT INTO ListMemberships(ListId, ProspectId) VALUES(20104, 3457990)

Get Deleted

To retrieve deleted records, a GETDELETED statement can be executed. The GETDELETED statement supports the same server side filters that are supported by the SELECT statement (except ID when using the equality(=) operator), but does not perform any client side filtering.

GETDELETED FROM ListMemberships WHERE ID = 231

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Pardot ID for this list membership.

ListId Integer True

Pardot ID of the list for this membership.

ProspectId Integer True

Pardot ID of the prospect for this membership.

OptedOut Integer False

If value is 1, the prospect is unsubscribed from receiving emails from this list.

CreatedAt Datetime True

Time that this membership was created in Pardot.

UpdatedAt Datetime True

Last time that this membership was updated.

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