MailMessages
Returns data about a specific mail message.
Columns
| Name | Type | References | 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. |