Power BI Connector for Salesforce Marketing Cloud Account Engagement

Build 23.0.8839


Retrieve email templates.

Table Specific Information


By default only templates connected to OneToOneEmails will be returned.

The connector will use the Salesforce Marketing Cloud Account Engagement 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 '='.

For example, the following queries are processed server side:

SELECT * FROM EmailTemplates WHERE Id = 22


Name Type References Description
Id Int64 Identifier.
EmailType Integer Email type.
Error Integer Error.
HtmlMessage String Html content.
IsAutoResponderEmail Integer Whether it is an auto responder email.
IsDripEmail Integer Whether it is a drip email.
IsListEmail Integer Whether it is a lsit email.
IsOneToOneEmail Integer Whether it is a one to one email.
Name String Name
SendOptionsReplyToAddressAggregate String Reply to addresses.
SendOptionsSendFromDataAggregate String Send from information.
Subject String Email subject.
TextMessage String Email text.
TrackedHtmlMessage String Tracked html message.
TrackedTextMessage String Tracked text message.
Type Integer Email type.

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