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