DealsParticipantsPersonEmail
Returns the email addresses from the person_id field of each deal participant record.
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 |
| DealsParticipantsId | = |
For example, the following queries are processed server-side:
SELECT * FROM DealsParticipantsPersonEmail
SELECT * FROM DealsParticipantsPersonEmail WHERE DealsParticipantsId = 2
Columns
| Name | Type | References | Description |
| DealsParticipantsId [KEY] | Integer | Identifier of the deal participant record. | |
| Label | String | Category label for the email address, for example work or home. | |
| Value | String | The email address of the deal participant's linked person record. | |
| Primary | Boolean | Indicates whether this is the primary email address for the person. |