MailThreadMessages
Returns all the mail messages inside a specified mail thread..
Select
The add-in will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- Id supports the '=' operator.
- MailThreadId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM MailThreadMessages WHERE MailThreadId = 145
Columns
| Name | Type | Description |
| Id [KEY] | Integer | ID of the Mail Thread Messages. |
| MailThreadId | Integer | ID of the Mail Thread. |
| To | String | To. |
| From | String | From. |
| Cc | String | Cc. |
| Bcc | String | Bcc. |
| BodyUrl | String | Body url. |
| AccountId | String | Account Id. |
| UserId | Integer | User Id. |
| Subject | String | Subject. |
| Snippet | String | Snippet. |
| MailTrackingStatus | String | Mail Tracking status. |
| MailLinkTrackingEnabledFlag | Integer | MailLinkTrackingEnabledFlag. |
| ReadFlag | Integer | Readflag. |
| Draft | String | Draft. |
| DraftFlag | Integer | Draft flag. |
| SyncedFlag | Integer | Synced flag. |
| DeletedFlag | Integer | Deleted flag. |
| HasBodyFlag | Integer | Has body flag. |
| SentFlag | Integer | Sent flag. |
| SentFromPipeDriveFlag | Integer | SentFromPipeDriveFlag. |
| SmartBccFlag | Integer | SmartBccFlag. |
| MessageTime | String | MessageTime. |
| AddTime | String | AddTime. |
| UpdateTime | String | UpdateTime. |
| HasAttachmentsFlag | Integer | HasAttachmentsFlag. |
| HasInlineAttachmentsFlag | Integer | HasInlineAttachmentsFlag. |
| HasRealAttachmentsFlag | Integer | HasRealAttachmentsFlag. |