email_templates

Creates, updates, deletes, gets or lists an email_templates resource.

Overview

Name	email_templates
Type	Resource
Id	aws.pinpoint.email_templates

Fields

The following fields are returned by SELECT queries:

get_email_template

Name	Datatype	Description
arn	string	The Amazon Resource Name (ARN) of the message template.
creation_date	string	The date, in ISO 8601 format, when the message template was created.
default_substitutions	string	The JSON object that specifies the default values that are used for message variables in the message template. This object is a set of key-value pairs. Each key defines a message variable in the template. The corresponding value defines the default value for that variable.
headers	array	The list of MessageHeaders for the email. You can have up to 15 Headers.
html_part	string	The message body, in HTML format, that's used in email messages that are based on the message template.
last_modified_date	string	The date, in ISO 8601 format, when the message template was last modified.
recommender_id	string	The unique identifier for the recommender model that's used by the message template.
subject	string	The subject line, or title, that's used in email messages that are based on the message template.
template_description	string	The custom description of the message template.
template_name	string	The name of the message template.
template_type	string	The type of channel that the message template is designed for. For an email template, this value is EMAIL. (EMAIL, SMS, VOICE, PUSH, INAPP)
text_part	string	The message body, in plain text format, that's used in email messages that are based on the message template.
version	string	The unique identifier, as an integer, for the active version of the message template, or the version of the template that you specified by using the version parameter in your request.
tags	object	A string-to-string map of key-value pairs that identifies the tags that are associated with the message template. Each tag consists of a required tag key and an associated tag value.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_email_template	select	template-name, region	version	Retrieves the content and settings of a message template for messages that are sent through the email channel.
create_email_template	insert	template-name, region, EmailTemplateRequest		Creates a message template for messages that are sent through the email channel.
update_email_template	update	template-name, region, EmailTemplateRequest	create-new-version, version	Updates an existing message template for messages that are sent through the email channel.
delete_email_template	delete	template-name, region	version	Deletes a message template for messages that were sent through the email channel.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)
template-name	string	The name of the message template. A template name must start with an alphanumeric character and can contain a maximum of 128 characters. The characters can be alphanumeric characters, underscores (_), or hyphens (-). Template names are case sensitive.
create-new-version	boolean	Specifies whether to save the updates as a new version of the message template. Valid values are: true, save the updates as a new version; and, false, save the updates to (overwrite) the latest existing version of the template. If you don't specify a value for this parameter, Amazon Pinpoint saves the updates to (overwrites) the latest existing version of the template. If you specify a value of true for this parameter, don't specify a value for the version parameter. Otherwise, an error will occur.
version	string	The unique identifier for the version of the message template to update, retrieve information about, or delete. To retrieve identifiers and other information for all the versions of a template, use the Template Versions resource. If specified, this value must match the identifier for an existing template version. If specified for an update operation, this value must match the identifier for the latest existing version of the template. This restriction helps ensure that race conditions don't occur. If you don't specify a value for this parameter, Amazon Pinpoint does the following: For a get operation, retrieves information about the active version of the template. For an update operation, saves the updates to (overwrites) the latest existing version of the template, if the create-new-version parameter isn't used or is set to false. For a delete operation, deletes the template, including all versions of the template.

SELECT examples

get_email_template

Retrieves the content and settings of a message template for messages that are sent through the email channel.

SELECT
arn,
creation_date,
default_substitutions,
headers,
html_part,
last_modified_date,
recommender_id,
subject,
template_description,
template_name,
template_type,
text_part,
version,
tags
FROM aws.pinpoint.email_templates
WHERE `template-name` = '{{ template-name }}' -- required
AND region = '{{ region }}' -- required
AND version = '{{ version }}'
;

INSERT examples

create_email_template

Creates a message template for messages that are sent through the email channel.

INSERT INTO aws.pinpoint.email_templates (
EmailTemplateRequest,
`template-name`,
region
)
SELECT 
'{{ EmailTemplateRequest }}' /* required */,
'{{ template-name }}',
'{{ region }}'
RETURNING
create_template_message_body
;

Manifest

# Description fields are for documentation purposes
- name: email_templates
props:
  - name: template-name
    value: "{{ template-name }}"
    description: Required parameter for the email_templates resource.
  - name: region
    value: "{{ region }}"
    description: Required parameter for the email_templates resource.
  - name: EmailTemplateRequest
    description: |
      Specifies the content and settings for a message template that can be used in messages that are sent through the email channel.
    value:
      DefaultSubstitutions: "{{ DefaultSubstitutions }}"
      HtmlPart: "{{ HtmlPart }}"
      RecommenderId: "{{ RecommenderId }}"
      Subject: "{{ Subject }}"
      Headers:
        - Name: "{{ Name }}"
          Value: "{{ Value }}"
      tags: "{{ tags }}"
      TemplateDescription: "{{ TemplateDescription }}"
      TextPart: "{{ TextPart }}"

UPDATE examples

update_email_template

Updates an existing message template for messages that are sent through the email channel.

UPDATE aws.pinpoint.email_templates
SET 
EmailTemplateRequest = '{{ EmailTemplateRequest }}'
WHERE 
`template-name` = '{{ template-name }}' --required
AND region = '{{ region }}' --required
AND EmailTemplateRequest = '{{ EmailTemplateRequest }}' --required
AND `create-new-version` = {{ create-new-version}}
AND version = '{{ version}}'
RETURNING
message_body;

DELETE examples

delete_email_template

Deletes a message template for messages that were sent through the email channel.

DELETE FROM aws.pinpoint.email_templates
WHERE `template-name` = '{{ template-name }}' --required
AND region = '{{ region }}' --required
AND version = '{{ version }}'
;