Power BI Connector for Salesforce Marketing Cloud Account Engagement

Build 23.0.8839


Retrieve and modify list memberships.

Table Specific Information


The connector will use the Salesforce Marketing Cloud Account Engagement 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'


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


Name Type ReadOnly References Description
Id [KEY] Int64 True

Pardot ID for this list membership.

ListId Int64 True


Pardot ID of the list for this membership.

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