PersonsMailMessages
Returns all mail messages associated with a specific person in Pipedrive, including message metadata, recipients, tracking status, and storage 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 |
| PersonId | = |
For example, the following query is processed server-side:
SELECT * FROM PersonsMailMessages WHERE PersonId = 246
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Unique identifier of the mail message. | |
| PersonId | Integer |
Persons.Id | Identifier of the person whose mail messages are returned. This field is required to query the table. |
| AccountId | String | Identifier of the mail account through which the message was sent or received. | |
| AddTime | Datetime | Date and time when the mail message was added to Pipedrive. | |
| Bcc | String | BCC recipients of the mail message. | |
| BodyUrl | String | URL pointing to the full body content of the mail message. | |
| Cc | String | CC recipients of the mail message. | |
| CompanyId | Integer | Identifier of the company account to which the mail message belongs. | |
| DeletedFlag | Boolean | Indicates whether the mail message has been deleted in Pipedrive. | |
| Draft | String | Draft status of the message, indicating whether it is saved as a draft. | |
| DraftFlag | Boolean | Indicates whether the mail message is saved as a draft and has not been sent. | |
| ExternalDeletedFlag | Boolean | Indicates whether the mail message has been deleted in the external mail system. | |
| From | String | Sender of the mail message. | |
| AttachmentsFlag | Boolean | Indicates whether the mail message has one or more attachments. | |
| BodyFlag | Boolean | Indicates whether the mail message contains a body. | |
| InlineAttachmentsFlag | Boolean | Indicates whether the mail message contains inline attachments embedded in the body. | |
| RealAttachmentsFlag | Boolean | Indicates whether the mail message has downloadable file attachments, as distinct from inline images. | |
| ItemType | String | Type of the item, indicating the object kind such as mail message. | |
| TrackingEnabledFlag | Boolean | Indicates whether link tracking is enabled for this mail message. | |
| ThreadId | Integer | Identifier of the mail thread to which this message belongs. | |
| TrackingStatus | String | Current tracking status of the mail message, indicating whether it has been opened. | |
| MessageTime | String | Date and time when the mail message was originally sent or received. | |
| MessageId | String | Message identifier from the mail user agent, corresponding to the Message-ID header. | |
| NylasId | String | Identifier of the message in the Nylas email synchronization service. | |
| ReadFlag | Boolean | Indicates whether the mail message has been read. | |
| S3Bucket | String | Name of the Amazon S3 bucket where the mail message body is stored. | |
| S3BucketPath | String | Path within the Amazon S3 bucket where the mail message body is stored. | |
| SentFlag | Boolean | Indicates whether the mail message has been sent. | |
| SentFromPipedriveFlag | Boolean | Indicates whether the mail message was sent directly from within Pipedrive. | |
| SmartBccFlag | Boolean | Indicates whether the message was captured in Pipedrive via the Smart BCC feature. | |
| Snippet | String | Short preview of the mail message body content. | |
| Subject | String | Subject line of the mail message. | |
| SyncedFlag | Boolean | Indicates whether the mail message has been synchronized with the external mail service. | |
| TemplateId | String | Identifier of the mail template used to compose the message. | |
| Timestamp | Datetime | Timestamp of when the mail message was last modified or indexed. | |
| To | String | Primary recipients of the mail message. | |
| UpdateTime | Datetime | Date and time when the mail message record was last updated. | |
| UserId | Integer | Identifier of the user associated with the mail message. | |
| WriteFlag | Boolean | Indicates whether the current user has write access to the mail message. | |
| Object | String | Type of the parent object to which the mail messages are associated. |