ADO.NET Provider for Salesforce Pardot

Build 21.0.8137


Retrieve and modify list memberships.

Table Specific Information


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

  • 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] 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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137