ProductsDealsPersonEmail
Returns the email addresses of contact persons associated with deals that include the specified product.
View-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| ProductId | = |
| Status | = |
For example, the following queries are processed server-side:
SELECT * FROM ProductsDealsPersonEmail WHERE ProductId = 10
SELECT * FROM ProductsDealsPersonEmail WHERE ProductId = 10 AND status = 'open'
Columns
| Name | Type | References | Description |
| ProductId | Integer | The unique identifier of the product whose deal contact email addresses are returned. | |
| Label | String | The label identifying the type of email address, for example work or home. | |
| Primary | Boolean | Whether this is the primary email address for the contact person. | |
| Value | String | The email address of the contact person. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| Status | String | Only fetch deals with specific status.
The allowed values are open, won, lost, deleted, all_not_deleted. The default value is all_not_deleted. |