MailAliases

Returns alternative email names for a mailbox.

Select

The component 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 component.

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

For example, the following queries are 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'

Columns


Name	Type	Description
Id [KEY]	Integer	Id of mail alias.
CanSend	Boolean	Indicates whether 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.
Type	String	The type of the mail alias.

SSIS Components for Outreach

MailAliases

Select

Columns