ADO.NET Provider for Salesforce Pardot

Build 21.0.8137

EmailTemplates

Query email templates.

Table Specific Information

Select

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

  • Id supports '=', '<', '<=', '>', '>='.
  • IsOneToOneEmail supports '='.
  • IsDeleted supports '='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.
  • UpdatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM EmailTemplates WHERE Id = 50
SELECT * FROM EmailTemplates WHERE UpdatedAt > '01/01/2022'
SELECT * FROM EmailTemplates WHERE CreatedAt > '01/01/2022'

GetDeleted

To retrieve email templates that are in the recycle bin in Pardot the following operation is supported:

GETDELETED FROM EmailTemplates

Columns

Name Type References Description
Id [KEY] Integer ID of the email.
Name String Name of the object for identification in Pardot.
Subject String Subject line for the email template.
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.
IsOneToOneEmail Boolean If True, the template is available for one-to-one emails.
IsAutoResponderEmail Boolean If True, the template is available for autoresponder emails.
IsDripEmail Boolean If True, the template is available for Engagement Programs.
IsListEmail Boolean If True, the template is available for list emails.
TrackerDomainId Integer ID of the tracker domain used for the list email.
FolderId Integer ID of the folder containing this object.
Type String 'html', 'text', and 'htmlAndText' values.
CampaignId Integer Pardot campaign related to this object.
IsDeleted Boolean True if the object is in the recycle bin in Pardot.
CreatedById Integer ID of the individual who created this object.
UpdatedById Integer 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.
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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137