JDBC Driver for Salesforce Pardot

Build 22.0.8462

EmailTemplates

Retrieve email templates.

Table Specific Information

Select

By default only templates connected to OneToOneEmails will be returned.

The driver will use the Salesforce Pardot API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.

  • Id supports '='.

For example, the following queries are processed server side:

SELECT * FROM EmailTemplates WHERE Id = 22

Columns

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462