Templates
Get details of reusable templates for building emails.
Select
The add-in will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- Id supports the '=,IN,>=,<=,>,<' operators.
- CreatedAt supports the '=,>=,<=,>,<' operators.
- Name supports the '=' operator.
- UpdatedAt supports the '=,>=,<=,>,<' operators.
SELECT * FROM Templates WHERE Id = 1 SELECT * FROM Templates WHERE Id IN (1, 2) SELECT * FROM Templates WHERE Id >= 1 SELECT * FROM Templates WHERE Id <= 1 SELECT * FROM Templates WHERE Id > 1 SELECT * FROM Templates WHERE Id < 2 SELECT * FROM Templates WHERE CreatedAt <= '2022-02-25 01:02:02.0' SELECT * FROM Templates WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0' SELECT * FROM Templates WHERE CreatedAt >= '2022-02-25 01:02:02.0' SELECT * FROM Templates WHERE CreatedAt = '2022-02-25 01:02:02.0' SELECT * FROM Templates WHERE CreatedAt < '2022-02-25 01:02:02.0' SELECT * FROM Templates WHERE CreatedAt > '2022-02-25 01:02:02.0' SELECT * FROM Templates WHERE UpdatedAt = '2022-02-25 01:02:02.0' SELECT * FROM Templates WHERE Name = 'test'
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Id of Template. |
| Archived | Boolean | Boolean value indicating if the template has been archived. |
| ArchivedAt | Datetime | The date and time the template was archived. |
| BccRecipients | String | A list of default person and email address pairs to receive this template in the bcc field. |
| BodyHtml | String | The body HTML of the template. |
| BodyText | String | The body text of the template. |
| BounceCount | Integer | The total count of bounced mailings during this template. |
| CcRecipients | String | A list of default person and email address pairs to receive this template in the cc field. |
| ClickCount | Integer | The total count of clicked mailings from this template. |
| ClonedFromId | String | Cloned from Id. |
| ContainsCustomHtml | Boolean | Boolean value indicating if the template contains custom HTML. |
| CreatedAt | Datetime | The date and time the template was created. |
| DeliverCount | Integer | The total count of delivered mailings from this template. |
| FailureCount | Integer | The total count of failed mailings from this template. |
| LastUsedAt | Datetime | The last time the template was used. |
| Name | String | The name of the template. |
| NegativeReplyCount | Integer | The total count of negative reply mailings from this template. |
| NeutralReplyCount | Integer | The total count of neutral reply mailings from this template. |
| OpenCount | Integer | The total count of opened mailings from this template. |
| OptOutCount | Integer | The total count of opted out mailings from this template. |
| PositiveReplyCount | Integer | The total count of positive reply mailings from this template. |
| ReplyCount | Integer | The total count of replied mailings from this template. |
| ScheduleCount | Integer | The total count of scheduled mailings from this template. |
| ShareType | String | The share type must be one of.
The allowed values are read_only, private, shared. |
| Subject | String | The subject line for the email to be sent. |
| Tags | String | A list of tag values associated with the template. |
| ToRecipients | String | A list of default person and email address pairs to receive this template in the To field. |
| TrackLinks | Boolean | Boolean value indicating if link tracking is enabled for the template. |
| TrackOpens | Boolean | Boolean value indicating if open tracking is enabled for the template. |
| UpdatedAt | Datetime | The date and time the template was last updated. |
| LinksSelf | String | Links self. |
| ContentCategoryMembershipsId | Integer | Content category memberships Id. |
| ContentCategoryMembershipsLinks | String | Content category memberships links. |
| CreatorId | Integer | The creator Id of the template. |
| CreatorType | String | The creator type of the template. |
| OwnerId | Integer | The Owner Id of the template. |
| OwnerType | String | The Owner type of the template. |
| RecipientsId | Integer | The Recipients Id. |
| RecipientsLinks | String | The Recipients links. |
| UpdaterId | Integer | The Updater Id of the template. |
| UpdaterType | String | The Updater type of the template. |
| Type | String | Type. |