OrganizationsUpdatesParticipants
Returns the participants of activity update events associated with a specified organization, 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 |
| OrgId | = |
| AllChanges | = |
| Items | =,IN |
For example, the following queries are processed server-side:
SELECT * FROM OrganizationsUpdatesParticipants WHERE OrgId = 246
SELECT * FROM OrganizationsUpdatesParticipants WHERE OrgId = 10 AND AllChanges = 1
SELECT * FROM OrganizationsUpdatesParticipants WHERE OrgId = 10 AND Items IN ('activity', 'plannedActivity')
Columns
| Name | Type | References | Description |
| OrgId [KEY] | Integer | Unique identifier of the organization whose activity update participants are returned. | |
| PersonId | Integer | Unique identifier of the person who is a participant in the activity. | |
| 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, doneActivity, change, note, deal, file, dealChange, personChange, organizationChange, follower, dealFollower, personFollower, organizationFollower, participant, comment, lead, leadChange, mailMessage, draftMailMessage, sentMailMessage, mailMessageWithAttachment, invoice, document, marketing_campaign_stat, marketing_status_change. |