MailMessages
Returns data about a specific mail message.
Columns
| Name | Type | Description |
| Id [KEY] | Integer | ID of the Mail Threads. |
| PartiesTo | String | To. |
| PartiesFrom | String | From. |
| DraftParties | String | Draft Parties. |
| Folders | String | Folders. |
| AccountId | String | Account Id. |
| UserId | Integer | User Id. |
| Version | Integer | Version. |
| Subject | String | Subject. |
| Snippet | String | Snippet. |
| SnippetDraft | String | SnippetDraft. |
| SnippetSent | String | SnippetSent. |
| HasAttachmentsFlag | Integer | HasAttachmentsFlag. |
| HasInlineAttachmentsFlag | Integer | HasInlineAttachmentsFlag. |
| HasRealAttachmentsFlag | Integer | HasRealAttachmentsFlag. |
| HasDraftFlag | Integer | HasDraftFlag. |
| HasSentFlag | Integer | HasSentFlag. |
| ArchivedFlag | Integer | ArchivedFlag. |
| DeletedFlag | Integer | DeletedFlag. |
| SyncedFlag | Integer | SyncedFlag. |
| ExternalDeletedFlag | Integer | ExternalDeletedFlag. |
| SmartBccFlag | Integer | SmartBccFlag. |
| FirstMessageToMeFlag | Integer | FirstMessageToMeFlag. |
| MailLinkTrackingEnabledFlag | Integer | MailLinkTrackingEnabledFlag. |
| LastMessageTimestamp | String | LastMessageTimestamp. |
| FirstMessageTimestamp | String | FirstMessageTimestamp. |
| LastMessageSentTimestamp | String | LastMessageSentTimestamp. |
| LastMessageReceivedTimestamp | String | LastMessageReceivedTimestamp. |
| AddTime | String | AddTime. |
| UpdateTime | String | UpdateTime. |
| DealId | Integer | DealId. |
| DealStatus | Integer | DealStatus. |
| AllMessagesSentFlag | Integer | AllMessagesSentFlag. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Folder | String | The type of folder to fetch. |