MessageContent
Returns the full content of a message, including sender, recipient, subject, and HTML or plain-text body.
View-Specific Information
Select
The driver uses the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.
| Column | Supported Operators |
| Id | = |
SELECT * FROM MessageContent WHERE Id = 'abc123'
Columns
| Name | Type | Description |
| Id [KEY] | String | The message's unique id. |
| FromEMail | String | The email address of the sender. |
| FromName | String | The alias of the sender, if any. |
| ToEMail | String | The email address of the recipient. |
| ToName | String | The alias of the recipient, if any. |
| Subject | String | The message's subject line. |
| HtmlContent | String | The HTML part of the message, if any. |
| TextContent | String | The text part of the message, if any. |
| Tags | String | List of tags on this message. |
| Attachments | String | An array of any attachments that can be found in the message. |
| Ts | Datetime | The Unix timestamp from when this message was sent. |
| Headers | String | The key-value pairs of the custom MIME headers for the message. |