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 | References | 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. |