OrganizationsMailMessages
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.
- OrgId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM OrganizationsMailMessages WHERE OrgId = 246
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Org id. | |
| OrgId | Integer | Activities 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 | External DeletedFlag. | |
| 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. |