PersonsUpdatesParticipants
Returns the participants of activity update events associated with a specified person, including each participant's person ID and whether they are the primary participant.
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 | = |
| AllChanges | = |
| Items | =,IN |
For example, the following queries are processed server-side:
SELECT * FROM PersonsUpdatesParticipants WHERE PersonId = 10
SELECT * FROM PersonsUpdatesParticipants WHERE PersonId = 10 AND AllChanges = 1
SELECT * FROM PersonsUpdatesParticipants WHERE PersonId = 10 AND Items IN ('activity', 'plannedActivity')
Columns
| Name | Type | References | Description |
| PersonId [KEY] | Integer | Unique identifier of the person whose activity update participants are returned. | |
| PrimaryFlag | Boolean | Indicates whether this participant is the primary participant of the activity. |
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. |