TransactionalMessages
Retrieves a paginated list of transactional messages that are not successfully sent in Salesforce Marketing Cloud. Results are ordered from the oldest to the newest message. This view provides visibility into message delivery issues and supports troubleshooting for transactional send processes.
Table Specific Information
Select
Select all TransactionalMessages:
SELECT * FROM TransactionalMessages
Columns
| Name | Type | References | Description |
| LastEventId | Integer | Specifies the unique identifier (Id) of the most recent event from which the response should begin. This Id allows you to retrieve transactional message events starting from a specific point in the event stream. | |
| StatusCode | Integer | Specifies the numeric code that represents the reason that a transactional send did not complete. These codes map to the Email Send error codes and help identify delivery failures, validation issues, or provider errors. | |
| StatusMessage | String | Specifies the descriptive message that explains why the transactional send did not complete. This message supplements the StatusCode value and provides human-readable context for diagnosing the issue. | |
| EventCategoryType | String | Specifies the type of transactional send event. Common values include 'EmailSent' (for messages that are successfully handed off to the email provider), 'EmailNotSent' (for messages that failed with a specific reason), and 'EmailQueued' (for messages that are awaiting processing). | |
| Timestamp | String | Specifies the date and time when the event occurred, expressed in Central Standard Time (CST) without daylight saving adjustments. This timestamp indicates when the system recorded the event. | |
| DefinitionKey | String | Specifies the unique Id of the transactional send definition that is associated with the event. This Id links the event back to the definition that provided the message content and configuration. | |
| EventId | Integer | Specifies the numeric Id of the event within the transactional messaging event stream. This Id helps identify and sequence events for tracking and reporting purposes. | |
| MessageKey | String | Specifies the unique identifier used to track the status of the message throughout the transactional send process. This key is unique per message instance and appears in status and tracking queries. | |
| ContactKey | String | Specifies the contact key that identifies the subscriber that is associated with the transactional message. This key maps the event to the subscriber's profile and activity history in Salesforce Marketing Cloud. | |
| To | String | Specifies the channel address of the recipient. For email messages, this value is the recipient's email address. For Short Message Service (SMS) messages, this value is the recipient's mobile phone number. |