PersonsUpdatesAttendees
Returns the attendees of activity update events associated with a specified person, including each attendee's name, email address, organizer status, and attendance status.
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 PersonsUpdatesAttendees WHERE PersonId = 246
SELECT * FROM PersonsUpdatesAttendees WHERE PersonId = 10 AND AllChanges = 1
SELECT * FROM PersonsUpdatesAttendees WHERE PersonId = 10 AND Items IN ('activity', 'plannedActivity')
Columns
| Name | Type | References | Description |
| PersonId [KEY] | Integer |
Persons.Id | Unique identifier of the person whose activity update attendees are returned. |
| EmailAddress | String | Email address of the activity attendee. | |
| IsOrganizer | Integer | Indicates whether the attendee is the organizer of the activity. A value of 1 means the attendee organized the activity. | |
| Name | String | Full name of the activity attendee. | |
| Status | String | Attendance status of the attendee for the activity, such as accepted or declined. | |
| UserId | String |
Users.Id | Unique identifier of the Pipedrive user corresponding to this attendee, if the attendee is a registered user. |
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. |