MailThreadsTo
Returns recipient party details for mail threads, including the email address, linked person, and linked organization for each thread recipient.
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 |
| Id | = |
| Folder | = |
For example, the following query is processed server-side:
SELECT * FROM MailThreadsTo WHERE Folder = 'inbox'
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Unique identifier of the mail thread. | |
| Name | String | Display name of the recipient of the mail thread. | |
| LatestSent | Boolean | Indicates whether the most recent message in the thread was sent to this recipient. | |
| EmailAddress | String | Email address of the recipient of the mail thread. | |
| MessageTime | String | Timestamp of the message addressed to this recipient within the thread. | |
| LinkedPersonId | Integer | Identifier of the Pipedrive person record linked to the recipient. | |
| LinkedPersonName | String | Name of the Pipedrive person record linked to the recipient. | |
| LinkedOrganizationId | String | Identifier of the Pipedrive organization record linked to the recipient. | |
| MailMessagePartyId | Integer | Identifier of the mail message party record representing the recipient. |
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 | |
| Folder | String | The type of folder to fetch. |