PersonsEmails
Returns all email addresses associated with persons, including the label, value, and whether each address is the primary contact address.
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 |
| PersonId | = |
| FilterId | = |
| OwnerId | = |
| DealId | = |
| OrgId | = |
For example, the following queries are processed server-side:
SELECT * FROM PersonsEmails WHERE PersonId = 14
SELECT * FROM PersonsEmails WHERE OwnerId = 2
SELECT * FROM PersonsEmails WHERE DealId = 1
SELECT * FROM PersonsEmails WHERE OrgId = 1
Columns
| Name | Type | References | Description |
| PersonId | Integer |
Persons.Id | The unique identifier of the parent person record. |
| Label | String | The category label for the email address, such as work, home, or other. | |
| Value | String | The email address. | |
| Primary | Boolean | Indicates whether this is the primary email address for the 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 | |
| FilterId | Integer | Filter Id. | |
| OwnerId | Integer | Owner Id. | |
| DealId | Integer | The id of the deal corresponding to the activity | |
| OrgId | Integer | The id of the organisation corresponding to the activity. |