DealsMailMessages
Get details of Deal mail Messages.
Select
The add-in 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 add-in.
- Id supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM DealsMailMessages WHERE Id = 246
Columns
| Name | Type | Description |
| Id [KEY] | Integer | id. |
| AccountId | String | AccountId. |
| AddTime | Datetime | addTime. |
| Bcc | String | Bcc. |
| BodyUrl | String | bodyUrl. |
| Cc | String | cc. |
| CompanyId | Integer | companyId. |
| DeletedFlag | Integer | DeletedFlag. |
| Draft | String | Draft. |
| DraftFlag | Integer | DraftFlag. |
| ExternalDeletedFlag | Integer | ExternalDeletedFlag. |
| From | String | From. |
| AttachmentsFlag | Integer | AttachmentsFlag. |
| BodyFlag | Integer | BodyFlag. |
| InlineAttachmentsFlag | Integer | InlineAttachmentsFlag. |
| RealAttachmentsFlag | Integer | RealAttachmentsFlag. |
| ItemType | String | ItemType. |
| TrackingEnabledFlag | Integer | TrackingEnabledFlag. |
| ThreadId | Integer | ThreadId. |
| TrackingStatus | String | TrackingStatus. |
| MessageTime | String | MessageTime. |
| MessageId | String | MessageId. |
| NylasId | String | NylasId. |
| ReadFlag | Integer | ReadFlag. |
| S3Bucket | String | S3Bucket. |
| S3BucketPath | String | S3BucketPath. |
| SentFlag | Integer | SentFlag. |
| SentFromPipedriveFlag | Integer | SentFromPipedriveFlag. |
| SmartBccFlag | Integer | SmartBccFlag. |
| Snippet | String | Snippet. |
| Subject | String | Subject. |
| SyncedFlag | Integer | SyncedFlag. |
| TemplateId | String | TemplateId. |
| Timestamp | Datetime | Timestamp. |
| To | String | To. |
| UpdateTime | Datetime | UpdateTime. |
| UserId | Integer | UserId. |
| WriteFlag | Boolean | writeFlag. |
| Object | String | Object. |