DealsMailMessages
Returns mail messages linked to a specific deal, including message metadata, tracking flags, and recipient details.
View-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| DealId | = |
For example, the following query is processed server-side:
SELECT * FROM DealsMailMessages WHERE DealId = 246
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the mail message. | |
| AccountId | String | The identifier of the mail account associated with this message. | |
| AddTime | Datetime | The date and time when this mail message was added to Pipedrive. | |
| Bcc | String | The list of BCC recipients for this mail message. | |
| BodyUrl | String | The URL from which the full message body can be retrieved. | |
| Cc | String | The list of CC recipients for this mail message. | |
| CompanyId | Integer | The identifier of the Pipedrive company account associated with this message. | |
| DeletedFlag | Integer | Indicates whether this mail message has been deleted. A value of 1 means the message is deleted. | |
| Draft | String | The draft status identifier for this mail message. | |
| DraftFlag | Integer | Indicates whether this mail message is a draft. A value of 1 means the message has not been sent. | |
| ExternalDeletedFlag | Integer | Indicates whether this mail message was deleted in the external mail provider. A value of 1 means it was deleted externally. | |
| From | String | The list of senders of this mail message. | |
| AttachmentsFlag | Integer | Indicates whether this mail message has file attachments. A value of 1 means attachments are present. | |
| BodyFlag | Integer | Indicates whether this mail message has a body. A value of 1 means a message body is available. | |
| InlineAttachmentsFlag | Integer | Indicates whether this mail message contains inline attachments such as embedded images. A value of 1 means inline attachments are present. | |
| RealAttachmentsFlag | Integer | Indicates whether this mail message contains downloadable file attachments, excluding inline content. A value of 1 means real attachments are present. | |
| ItemType | String | The type of item this mail message record represents within the Pipedrive activity feed. | |
| TrackingEnabledFlag | Integer | Indicates whether link tracking is enabled for this mail message. A value of 1 means link clicks are tracked. | |
| ThreadId | Integer | The identifier of the mail thread this message belongs to. | |
| TrackingStatus | String | The current open and click tracking status of this mail message. | |
| MessageTime | String | The timestamp of the mail message as reported by the mail provider. | |
| MessageId | String | The unique message identifier assigned by the mail user agent. | |
| NylasId | String | The identifier assigned to this message by the Nylas mail synchronization service. | |
| ReadFlag | Integer | Indicates whether this mail message has been read. A value of 1 means the message has been opened. | |
| S3Bucket | String | The name of the Amazon S3 bucket where the message body is stored. | |
| S3BucketPath | String | The path within the S3 bucket where the message body is stored. | |
| SentFlag | Integer | Indicates whether this mail message has been sent. A value of 1 means the message was sent. | |
| SentFromPipedriveFlag | Integer | Indicates whether this mail message was sent directly through Pipedrive. A value of 1 means it was sent from the Pipedrive interface. | |
| SmartBccFlag | Integer | Indicates whether Smart BCC was used to link this message to Pipedrive. A value of 1 means the message was captured via Smart BCC. | |
| Snippet | String | A short preview excerpt from the body of the mail message. | |
| Subject | String | The subject line of the mail message. | |
| SyncedFlag | Integer | Indicates whether this mail message has been synchronized with the external mail provider. A value of 1 means the message is synchronized. | |
| TemplateId | String | The identifier of the email template used to compose this message, if applicable. | |
| Timestamp | Datetime | The date and time when this mail message record was last updated in Pipedrive. | |
| To | String | The list of primary recipients of this mail message. | |
| UpdateTime | Datetime | The date and time when this mail message record was last modified. | |
| UserId | Integer | The unique identifier of the Pipedrive user associated with this mail message. | |
| WriteFlag | Boolean | Indicates whether the current user has write access to this mail message. | |
| Object | String | The object type identifier returned by the Pipedrive API for this record. | |
| DealId | Integer |
Deals.Id | The unique identifier of the deal this mail message is linked to. |