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 | References | Description |
| Id [KEY] | Integer | Id. | |
| PersonId | Integer |
Persons.Id | 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. |