Messages

Returns sent messages from the last two months, including delivery status, sender, recipient, and engagement details.

Columns


Name	Type	Description
Id [KEY]	String
Email	String
Sender	String
Subject	String
State	String	The allowed values are sent, bounced, rejected.
Template	String
SubAccount	String
ElasticsearchIndex	String
Version	String
DocumentId	String
Diag	String
RejectReason	String
RejectLastEventAt	String
Tags	String
BgtoolsCode	String
SMTPEvents	String
TimeStamp	Datetime
Resends	String
Ts	Long
BounceDescription	String
OpensDetail	String
ClicksDetail	String
Opens	Integer
Clicks	Integer

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.