Cmdlets for Salesforce Marketing Cloud Account Engagement

Build 24.0.9062

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.

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