DealsUpdatesTo
Returns the primary recipients for mail message updates in the activity feed of a specific deal.
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 |
| DealId | = |
| AllChanges | = |
| Items | =,IN |
For example, the following queries are processed server-side:
SELECT * FROM DealsUpdatesTo WHERE DealId = 3
SELECT * FROM DealsUpdatesTo WHERE DealId = 246 AND AllChanges = 1
SELECT * FROM DealsUpdatesTo WHERE DealId = 246 AND Items IN ('activity', 'call')
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the recipient record. | |
| DealId | Integer | The unique identifier of the deal whose mail message recipients are returned. | |
| EmailAddress | String | The email address of the primary recipient. | |
| PersonId | String | The unique identifier of the Pipedrive person record linked to this recipient. | |
| PersonName | String | The full name of the Pipedrive person record linked to this recipient. | |
| MessagePartyId | Integer | The unique identifier of the mail message party record for this recipient. | |
| Name | String | The display name of the primary 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 | |
| AllChanges | String | Whether to show custom field updates or not.
The allowed values are 1. | |
| Items | String | item specific updates.
The allowed values are call, activity, plannedActivity, change, note, deal, file, dealChange, personChange, organizationChange, follower, dealFollower, personFollower, organizationFollower, participant, comment, mailMessage, mailMessageWithAttachment, invoice, document, marketing_campaign_stat, marketing_status_change. |