ListEmailRecipients

RecipientLists used by an email

Retrieve a Single Email Recipient

To retrieve a single email recipient, specify its ID:

SELECT * FROM ListEmailRecipients WHERE Id = '55555555'

To retrieve multiple email recipient, issue a nested SELECT statement to the ListEmail table.

SELECT * FROM ListEmailRecipients WHERE ListEmailId IN (SELECT Id FROM ListEmail)


Name	Type	References	Description
Id [KEY]	Int64		ID of the RecipientList.
ListEmailId [KEY]	Int64		The ListEmail id
ListEmailName	String		ListEmail's name (internal to Pardot).
ListEmailCampaignId	Int64		Pardot ListEmail campaign related to this object. Uses null if not specified on create.
Name	String		List's name (internal to Pardot).
FolderId	Int64		ID of the folder containing this object.
IsDynamic	Boolean		True if the list is dynamic.
IsPublic	Boolean		True if the list is public.
Title	String		Title of the list object.
Description	String		List's description.