DealsParticipantsPhone
Returns the phone numbers associated with the person field of each deal participant.
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 DealsParticipantsPhone
SELECT * FROM DealsParticipantsPhone 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 person contact. | |
| Primary | Boolean | Indicates whether this is the primary phone number for the person. |