DealsParticipantsPersonPhone
Returns the phone numbers 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 DealsParticipantsPersonPhone
SELECT * FROM DealsParticipantsPersonPhone WHERE DealsParticipantsId = 2
Columns
| Name | Type | References | Description |
| DealsParticipantsId [KEY] | Integer | Identifier of the deal participant record. | |
| Label | String | Category label for the phone number, for example work or mobile. | |
| Value | String | The phone number of the deal participant's linked person record. | |
| Primary | Boolean | Indicates whether this is the primary phone number for the person. |