OrganizationsMailMessages
Returns mail messages associated with a specified organization, including message metadata, flags, and recipient lists.
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 |
| OrgId | = |
For example, the following query is processed server-side:
SELECT * FROM OrganizationsMailMessages WHERE OrgId = 246
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the mail message. | |
| OrgId | Integer | The identifier of the organization this mail message is associated with. | |
| AccountId | String | The identifier of the email account that sent or received this message. | |
| AddTime | Datetime | The date and time when the mail message was added to Pipedrive. | |
| Bcc | String | The BCC recipients of the mail message, returned as a JSON array. | |
| BodyUrl | String | The URL to retrieve the full body content of the mail message. | |
| Cc | String | The CC recipients of the mail message, returned as a JSON array. | |
| CompanyId | Integer | The identifier of the Pipedrive company account that owns this mail message. | |
| DeletedFlag | Boolean | Indicates whether the mail message has been deleted within Pipedrive. | |
| Draft | String | The draft status value of the mail message. | |
| DraftFlag | Boolean | Indicates whether the mail message is saved as a draft. | |
| ExternalDeletedFlag | Boolean | Indicates whether the mail message has been deleted in the external email provider. | |
| From | String | The sender of the mail message, returned as a JSON array. | |
| AttachmentsFlag | Boolean | Indicates whether the mail message has any file attachments. | |
| BodyFlag | Boolean | Indicates whether the mail message has a body content. | |
| InlineAttachmentsFlag | Boolean | Indicates whether the mail message has inline (embedded) attachments. | |
| RealAttachmentsFlag | Boolean | Indicates whether the mail message has real (non-inline) file attachments. | |
| ItemType | String | The type of item this mail message is associated with (for example, deal or person). | |
| TrackingEnabledFlag | Boolean | Indicates whether link tracking is enabled for this mail message. | |
| ThreadId | Integer | The identifier of the mail thread this message belongs to. | |
| TrackingStatus | String | The open or click tracking status for this mail message. | |
| MessageTime | String | The date and time when the mail message was sent or received. | |
| MessageId | String | The unique mail user agent (MUA) message identifier assigned by the email client. | |
| NylasId | String | The identifier assigned to this message by the Nylas email synchronization service. | |
| ReadFlag | Boolean | Indicates whether the mail message has been read. | |
| S3Bucket | String | The Amazon S3 bucket name where the message body is stored. | |
| S3BucketPath | String | The path within the Amazon S3 bucket where the message body is stored. | |
| SentFlag | Boolean | Indicates whether the mail message was sent (as opposed to received). | |
| SentFromPipedriveFlag | Boolean | Indicates whether the mail message was sent directly from within Pipedrive. | |
| SmartBccFlag | Boolean | Indicates whether this mail message was captured via Pipedrive's Smart BCC feature. | |
| Snippet | String | A short text preview of the mail message body. | |
| Subject | String | The subject line of the mail message. | |
| SyncedFlag | Boolean | Indicates whether the mail message has been synchronized from an external email provider. | |
| TemplateId | String | The identifier of the email template used to compose this mail message, if any. | |
| Timestamp | Datetime | The timestamp of when the mail message was recorded in the system. | |
| To | String | The direct recipients of the mail message, returned as a JSON array. | |
| UpdateTime | Datetime | The date and time when the mail message record was last updated. | |
| UserId | Integer | The identifier of the user associated with this mail message. | |
| WriteFlag | Boolean | Indicates whether the current user has write access to this mail message. | |
| Object | String | The type of the response object returned by the Pipedrive API. |