MailThreadMessages
Returns all the mail messages inside a specified mail thread..
Select
The connector 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 connector.
- 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. |