MailThreadMessages
Returns all individual mail messages within a specified mail thread, including sender, recipient, and status details for each message.
View-Specific Information
SELECT
The provider uses 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 provider.
| Column | Supported Operators |
| Id | = |
| MailThreadId | = |
For example, the following query is processed server-side:
SELECT * FROM MailThreadMessages WHERE MailThreadId = 145
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Unique identifier of the mail message. | |
| MailThreadId | Integer | Identifier of the mail thread that contains this message. | |
| To | String | Recipients of the mail message. | |
| From | String | Senders of the mail message. | |
| Cc | String | Carbon copy recipients of the mail message. | |
| Bcc | String | Blind carbon copy recipients of the mail message. | |
| BodyUrl | String | URL pointing to the full body content of the mail message. | |
| AccountId | String | Identifier of the mail account from which this message was sent or received. | |
| UserId | Integer | Identifier of the Pipedrive user associated with this mail message. | |
| Subject | String | Subject line of the mail message. | |
| Snippet | String | Short preview text extracted from the body of the mail message. | |
| MailTrackingStatus | String | Open and click tracking status for the mail message, indicating whether the recipient has opened the message. | |
| MailLinkTrackingEnabledFlag | Integer | Indicates whether link tracking is enabled for this message. A value of 1 means link clicks are tracked. | |
| ReadFlag | Integer | Indicates whether the message has been read. A value of 1 means the message has been read. | |
| Draft | String | Draft status indicator for the message, representing the current draft state. | |
| DraftFlag | Integer | Indicates whether the message is a draft. A value of 1 means the message has not been sent. | |
| SyncedFlag | Integer | Indicates whether the message has been synchronized with the external mail provider. A value of 1 means the message is synced. | |
| DeletedFlag | Integer | Indicates whether the message has been deleted. A value of 1 means the message is marked as deleted. | |
| HasBodyFlag | Integer | Indicates whether the message has a retrievable body. A value of 1 means the body content is available. | |
| SentFlag | Integer | Indicates whether the message has been sent. A value of 1 means the message was successfully sent. | |
| SentFromPipeDriveFlag | Integer | Indicates whether the message was sent directly from the Pipedrive application. A value of 1 means Pipedrive was the sending application. | |
| SmartBccFlag | Integer | Indicates whether the message was captured in Pipedrive via Smart BCC. A value of 1 means Smart BCC was used. | |
| MessageTime | String | Date and time when the mail message was sent or received. | |
| AddTime | String | Date and time when the message record was added to Pipedrive. | |
| UpdateTime | String | Date and time when the message record was last updated. | |
| HasAttachmentsFlag | Integer | Indicates whether the message contains any attachments. A value of 1 means attachments are present. | |
| HasInlineAttachmentsFlag | Integer | Indicates whether the message contains inline attachments embedded in the body. A value of 1 means inline attachments are present. | |
| HasRealAttachmentsFlag | Integer | Indicates whether the message contains file attachments that are not inline. A value of 1 means real attachments are present. |