Events

Get details of application events, capturing details around the initiator, recipient.

Select

The 本製品 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 本製品.

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

For example, the following query is processed server side:

SELECT * FROM Events WHERE Id = 1

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

SELECT * FROM Events WHERE Id >= 1

SELECT * FROM Events WHERE Id <= 1

SELECT * FROM Events WHERE Id > 1

SELECT * FROM Events WHERE Id < 2

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

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

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

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

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

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

SELECT * FROM Events WHERE EventAt <= '2022-02-25 01:02:02.0'

Columns


Name	Type	Description
Id [KEY]	Integer	Id of Email Address.
Body	String	The event body.
CreatedAt	Datetime	The date and time the event was created.
EventAt	Datetime	The date and time the event occurred.
ExternalUrl	String	The external URL associated with this event.
Name	String	The name of the event that took place.
Payload	String	The transmitted data for the event.
RequestCity	String	The city where the request that created the event was made.
RequestDevice	String	The type of device on which the request that created the event was made.
RequestHost	String	Name of the host from which the request was made.
RequestProxied	Boolean	A boolean value indicating whether or not the request was proxied.
RequestRegion	String	Name of the region from which the request was made.
LinksSelf	String	Link self.
MailingId	Integer	Mailing Id.
ProspectId	Integer	Prospect's Id.
ProspectType	String	Prospect's type.
UserId	Integer	User's Id.
Type	String	Type.

SSIS Components for Outreach

Events

Select

Columns