EmailTemplates

Create, update, delete, and query email templates to be used for emails

Table Specific Information

You can query the Email Templates table using any criteria in the WHERE clause. The adapter will use the Suite CRM API to filter the results.

SELECT * FROM "Email Templates" WHERE Name = 'test'

Create an Email Template by specifying any writable column.

INSERT INTO "Email Templates" (Id, Name) VALUES ('id', 'Energy')

You can update any Email Template column that is writable, by specifying the Id.

UPDATE "Email Templates" SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123'

Delete an Email Template by specifying the Id.

DELETE FROM "Email Templates" WHERE Id = '10003'

Name	Type	ReadOnly	Description
SecurityGroups	String	True	The security group associated with the record.
Id [KEY]	String	False	The unique identifier of the email template.
DateEntered	Datetime	False	The date the record was created.
DateModified	Datetime	False	The date the record was last modified.
ModifiedUserId	String	False	The Id of the user who last modified the record.
CreatedBy	String	False	The Id of the user who created the record.
Published	String	False	The published status of the record.
Name	String	False	The name of the email template.
Description	String	False	The description for the email template.
Subject	String	False	The subject of the resulting email.
Body	String	False	Plaintext body of the resulting email.
BodyHtml	String	False
Deleted	Bool	False	The record deletion indicator.
AssignedUserId	String	False	The Id of the user assigned to the record.
AssignedUserName	String	True	The user name of the user assigned to the record.
AssignedUserLink	String	True	Link to the user which the record has been assigned to
TextOnly	Bool	False	Whether the email template is to be sent in text only.
Type	String	False	The type of the email template.