OrganizationsMailMessagesTo
Returns the direct recipients for mail messages associated with a specified organization.
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 OrganizationsMailMessagesTo WHERE OrgId = 246
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the mail message party record. | |
| OrgId | Integer | The identifier of the organization whose mail message direct recipients are returned. | |
| EmailAddress | String | The email address of the direct recipient. | |
| PersonId | String | The identifier of the Pipedrive person record linked to this recipient. | |
| PersonName | String | The name of the Pipedrive person record linked to this recipient. | |
| MessagePartyId | Integer | The unique identifier for this recipient's entry in the mail message party list. | |
| Name | String | The display name of the direct recipient. |