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.
• ArchivedAt supports the '=,>=,<=,>,<' operators.
• ClickCount supports the '=,IN,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• DeliverCount supports the '=,IN,>=,<=,>,<' operators.
• LastUsedAt supports the '=,>=,<=,>,<' operators.
• Name supports the '=,IN' operators.
• OpenCount supports the '=,IN,>=,<=,>,<' operators.
• ReplyCount supports the '=,IN,>=,<=,>,<' operators.
• ShareType supports the '=,IN' operators.
• 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'

SELECT * FROM Templates WHERE ShareType = 'read_only'

Columns