OrganizationsUpdatesAttendees
Returns the attendees of activity update events associated with a specified organization, 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 |
| OrgId | = |
| AllChanges | = |
| Items | =,IN |
For example, the following queries are processed server-side:
SELECT * FROM OrganizationsUpdatesAttendees WHERE OrgId = 246
SELECT * FROM OrganizationsUpdatesAttendees WHERE OrgId = 10 AND AllChanges = 1
SELECT * FROM OrganizationsUpdatesAttendees WHERE OrgId = 10 AND Items IN ('activity', 'plannedActivity')
Columns
| Name | Type | References | Description |
| OrgId [KEY] | Integer | Unique identifier of the organization whose activity update attendees are returned. | |
| EmailAddress | String | Email address of the activity attendee. | |
| IsOrganizer | Boolean | Indicates whether the attendee is the organizer of the activity. | |
| Name | String | Full name of the activity attendee. | |
| PersonId | Integer |
Persons.Id | Unique identifier of the Pipedrive person record corresponding to this attendee, if applicable. |
| 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, 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. |