MailAliases

Alternative email name for a mailbox.

Select

The adapter will use the API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.

Id supports the '=,IN,>=,<=,>,<' operators.
CreatedAt supports the '=,>=,<=,>,<' operators.
UpdatedAt supports the '=,>=,<=,>,<' operators.
UserId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM MailAliases WHERE Id = 1

SELECT * FROM MailAliases WHERE Id IN (1,2)

SELECT * FROM MailAliases WHERE Id >= 1

SELECT * FROM MailAliases WHERE Id <= 1

SELECT * FROM MailAliases WHERE Id > 1

SELECT * FROM MailAliases WHERE Id < 2

SELECT * FROM MailAliases WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM MailAliases WHERE UserId = 1

Columns

Name	Type	Description
Id [KEY]	Integer	Id of mail alias.
CanSend	Boolean	Whether or not this alias can send email.
CreatedAt	Datetime	The date the alias was created.
Email	String	The email alias.
UpdatedAt	Datetime	The date the alias was last updated.
UserId	Integer	User's Id.
Type	String	Type.

TDV Adapter for Outreach

MailAliases

Select

Columns