JDBC Driver for SuiteCRM

Build 22.0.8462

EmailTemplates

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

Table Specific Information

Select

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

SELECT * FROM [Email Templates] WHERE Name = 'test'

Insert

Create an Email Template by specifying any writable column.

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

Update

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

Delete an Email Template by specifying the Id.

DELETE FROM [Email Templates] WHERE Id = '10003'

Columns

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462