Custom SMS templates.

Table Specific Information

Required Scopes

TO query this table, Scope must include okta.templates.read. To edit this table, it must include okta.templates.manage.

Select

The add-in uses the Okta API to process WHERE clause conditions built with the following columns and operators.

• Id supports the '=' operator

All other filters are processed client-side within the add-in.

For example, the following query is processed server-side:

SELECT * FROM SmsTemplates WHERE Id='6NQUJ5yR3bpgEiYmq8IC'

Insert

At minimum the Name is required to insert into this table.

A sample Insert is given below.

INSERT INTO SmsTemplates (Name, Type, Template) VALUES ('myNewTemp', 'SMS_VERIFY_CODE', '${org.name}: your verification code is ${code}')

Update

A sample Update is given below.

UPDATE SmsTemplates SET Template = 'new template' WHERE Id = '6NQUJ5yR3bpgEiYmq8IC'

Delete

A sample Delete is given below.

DELETE FROM SmsTemplates WHERE Id = '6NQUJ5yR3bpgEiYmq8IC'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	Id of the template
Name	String	False	Human-readable name of the template
Type	String	False	Type of the template
Template	String	False	Text of the template, including any macros
Created	Datetime	True	When the item was created
LastUpdated	Datetime	True	When the item was last updated
Translations	String	False	Translations of the template