TransactionalMessages

Gets a paginated list of messages that were not sent, ordered from oldest to newest.

Table Specific Information

Select all TransactionalMessages:

SELECT * FROM TransactionalMessages


Name	Type	References	Description
LastEventId	Integer		The ID of the Event from which you want the response to start.
StatusCode	Integer		Integer value of the reason the send did not complete. Review Email Send Error Codes for more information.
StatusMessage	String		The reason the send did not complete. Review Email Send Error Codes for more information.
EventCategoryType	String		TransactionalSendEvent event type. EmailSent indicates that the email was sent to the email provider. EmailNotSent indicates that the email was not sent and includes the reason. EmailQueued indicates that the email has not yet been processed for sending.
Timestamp	String		Time the event occured in Central Standard Time (no daylight savings)
DefinitionKey	String		Unique identifier of the definition.
EventId	Integer		Numeric identifier of the event.
MessageKey	String		Unique identifier to track message send status.
ContactKey	String		Unique identifier for a subscriber in Marketing Cloud.
To	String		Channel address of the recipient. For email, it’s the recipient's email address. For SMS, it’s the recipient's mobile number.