SSIS Components for Salesforce Marketing Cloud Account Engagement

Build 23.0.8839


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'

Retrieve Multiple Email Recipients

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839