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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description | |
Folder | String | The type of folder to fetch. |