DealsMailMessagesTo
Returns the primary recipients for mail messages linked to a specific deal.
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 |
| DealId | = |
For example, the following query is processed server-side:
SELECT * FROM DealsMailMessagesTo WHERE DealId = 246
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the recipient record. | |
| EmailAddress | String | The email address of the primary recipient. | |
| PersonId | String | The unique identifier of the Pipedrive person record linked to this recipient. | |
| PersonName | String | The full name of the Pipedrive person record linked to this recipient. | |
| MessagePartyId | Integer | The unique identifier of the mail message party record for this recipient. | |
| Name | String | The display name of the primary recipient. | |
| DealId | Integer |
Deals.Id | The unique identifier of the deal whose mail message recipients are returned. |