ListEmail
A list email is a single email sent to a recipient list.
テーブル固有の情報
Select
本製品 はSalesforce Marketing Cloud Account Engagement API を使用して、以下のカラムと演算子で構築されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドで本製品 内部で処理されます。
- Id は '='、'<'、'<='、'>'、'>=' をサポートしています。
- IsDeleted は'=' をサポートしています。
- CreatedAt は '='、'<'、'<='、'>'、'>=' をサポートしています。
- UpdatedAt は '='、'<'、'<='、'>'、'>=' をサポートしています。
- SentAt は '='、'<'、'<='、'>'、'>=' をサポートしています。
例えば、次のクエリはサーバーサイドで処理されます。
SELECT * FROM ListEmail WHERE Id = 50 SELECT * FROM ListEmail WHERE SentAt > '01/01/2022' SELECT * FROM ListEmail WHERE CreatedAt > '01/01/2022'
GetDeleted
Pardot のごみ箱にあるリストメールを取得する場合、次の操作がサポートされています。
GETDELETED FROM ListEmail
Columns
Name | Type | References | Description |
Id [KEY] | Int64 | ID of the email. | |
Name | String | Name of the object for identification in Pardot. | |
Subject | String | The email subject. | |
TextMessage | String | The text content of the email. This field is retrieved only when filtering with email id. | |
HtmlMessage | String | The HTML content of the email. This field is retrieved only when filtering with email id. | |
CampaignId | Int64 | Pardot campaign related to this object. | |
IsPaused | Boolean | True if the email send is paused. | |
IsSent | Boolean | True if the email has been sent. | |
IsDeleted | Boolean | True if the object is in the recycle bin in Pardot. | |
CreatedById | Int64 | ID of the individual who created this object. | |
UpdatedById | Int64 | ID of the individual who last updated this object. | |
CreatedAt | Datetime | The timestamp of when this object was created. | |
UpdatedAt | Datetime | The timestamp of when this object was last updated. | |
ClientType | String | Value is 'Builder' if the email was sent via the Lightning Email Builder. Value is 'Web' if it was sent via the legacy Pardot email builder. | |
SentAt | Datetime | Time the email was sent. | |
OperationalEmail | Boolean | True if the email is operational. | |
EmailTemplateId | Int64 | ID of the email template used for the list email. | |
TrackerDomainId | Int64 | ID of the tracker domain used for the list email. | |
SenderOptionsType | String | The sending user type(s). | |
SenderOptionsAddress | String | The sending email address(s). | |
SenderOptionsName | String | The name(s) of the sender. | |
SenderOptionsUserId | String | The user ID(s) of the sender. | |
ReplyToOptionsType | String | The reply to user type(s). | |
ReplyToOptionsAddress | String | The sending email address(s). | |
ReplyToOptionsUserId | String | The user ID(s) of the sender. |