Retrieve and modify list memberships.
Table Specific Information
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'
The following attributes are required when performing an insert: ListId, ProspectId.
INSERT INTO ListMemberships(ListId, ProspectId) VALUES(20104, 3457990)
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
Pardot ID for this list membership.
Pardot ID of the list for this membership.
Pardot ID of the prospect for this membership.
If value is 1, the prospect is unsubscribed from receiving emails from this list.
Time that this membership was created in Pardot.
Last time that this membership was updated.