PersonsUpdates
Returns the activity and change history for a specified person, including details about activities, field changes, notes, files, and other timeline events associated with that person.
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 PersonsUpdates WHERE PersonId = 246
SELECT * FROM PersonsUpdates WHERE PersonId = 10 AND AllChanges = 1
SELECT * FROM PersonsUpdates WHERE PersonId = 10 AND Items IN ('activity', 'plannedActivity')
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Unique identifier of the update or activity record. | |
| ActiveFlag | Boolean | Indicates whether the associated item is currently active. | |
| AddTime | Datetime | Timestamp indicating when the update record was created. | |
| NewValueFormatted | String | Human-readable formatted representation of the new field value after a change. | |
| AssignedToUserId | Integer | Unique identifier of the user to whom the associated activity or item is assigned. | |
| Attendees | String | JSON-encoded list of attendees associated with the activity update. | |
| BusyFlag | Boolean | Indicates whether the activity is marked as busy, blocking time on the assignee's calendar. | |
| SyncIncludecontext | String | Calendar synchronization context setting that controls what context is included when syncing the activity to an external calendar. | |
| changeSource | String | Identifies the source that initiated the field change, such as an API call or the web application. | |
| UserAgent | String | User agent string of the client that submitted the change, providing additional context about the change source. | |
| CompanyId | Integer | Unique identifier of the Pipedrive company account associated with this update. | |
| MeetingClient | String | Name of the conferencing client used for the meeting, such as Zoom or Google Meet. | |
| MeetingId | String | Unique identifier of the conference meeting within the conferencing platform. | |
| MeetingUrl | String | URL link to join the conference meeting. | |
| CreatedByUserId | Integer | Unique identifier of the user who created the update or activity record. | |
| DealDropboxBcc | String | BCC email address for the deal dropbox, used to associate incoming emails with the deal. | |
| DealId | Integer | Unique identifier of the deal associated with this update, if applicable. | |
| DealTitle | String | Title of the deal associated with this update. | |
| Done | Boolean | Indicates whether the associated activity has been marked as done. | |
| DueDate | Date | Date on which the associated activity is due. | |
| DueTime | Time | Time at which the associated activity is due on its due date. | |
| Duration | Time | Duration of the associated activity in HH:MM format. | |
| FieldKey | String | Key of the field that was changed, used to identify which field the change event relates to. | |
| Fileclean_name | String | Sanitized display name of the file attached to this update. | |
| FileId | String | Unique identifier of the file attached to this update. | |
| FileUrl | String | Download or access URL for the file attached to this update. | |
| GcaleventId | String | Unique identifier of the corresponding event in Google Calendar, if the activity is synced. | |
| GoogleCalendarEtag | String | ETag value of the Google Calendar event, used for change detection during synchronization. | |
| GoogleCalendarId | String | Unique identifier of the Google Calendar to which the activity is synced. | |
| IsBulkUpdateFlag | String | Indicates whether this change was applied as part of a bulk update operation. | |
| ItemId | Integer | Unique identifier of the item referenced by this update event. | |
| NotificationTime | Datetime | Timestamp of the most recent notification sent for this update. | |
| NotificationUserId | Integer | Unique identifier of the user who received the most recent notification for this update. | |
| LeadId | String | Unique identifier of the lead associated with this update, if applicable. | |
| Location | String | Location of the associated activity, as entered by the user. | |
| AdminAreaLevel1 | String | First-level administrative area of the activity location, such as a state or province. | |
| AdminAreaLevel2 | String | Second-level administrative area of the activity location, such as a county or district. | |
| Country | String | Country of the activity location. | |
| FormattedAddress | String | Full formatted address of the activity location. | |
| Lat | Double | Latitude coordinate of the activity location. | |
| Locality | String | City or locality of the activity location. | |
| Long | Double | Longitude coordinate of the activity location. | |
| PostalCode | String | Postal or ZIP code of the activity location. | |
| Route | String | Street or route name of the activity location. | |
| StreetNumber | String | Street number of the activity location address. | |
| Sublocality | String | Sublocality or neighborhood of the activity location, such as a borough or district within a city. | |
| Subpremise | String | Subpremise of the activity location, such as an apartment or suite number. | |
| LogTime | Datetime | Timestamp indicating when this update was logged in the activity feed. | |
| MarkedAsDoneTime | Datetime | Timestamp indicating when the associated activity was marked as done. | |
| NewValue | String | Raw new value of the field after the change event. | |
| Note | String | Text content of the note associated with this update, if the update event is a note. | |
| LanguageId | Integer | Identifier of the language used for notifications related to this update. | |
| OldValue | String | Raw previous value of the field before the change event. | |
| OrgId | Integer | Organizations Id. | |
| OrgName | String | Organizations Name. | |
| OwnerName | String | Owner Name. | |
| Participants | String | JSON-encoded list of participants associated with the activity update. | |
| PersonDropboxBcc | String | Person Dropbox Bcc. | |
| PersonId | Integer |
Persons.Id | Persons Id. |
| PersonName | String | Full name of the person associated with this update. | |
| Publicdescription | String | Public-facing description of the activity associated with this update. | |
| RecMasterActivityId | String | Unique identifier of the master recurring activity from which this activity instance was generated. | |
| RecRule | String | Recurrence rule (RRULE) string defining the schedule for a recurring activity. | |
| RecRuleExtension | String | Extension data for the recurrence rule, used to store additional scheduling configuration. | |
| ReferenceId | Integer | Unique identifier of the referenced object associated with this update event. | |
| ReferenceType | String | Type of the object referenced by this update event, such as deal, person, or organization. | |
| Series | String | Series identifier for grouped or recurring update events. | |
| SourceTimezone | String | Timezone of the source system that originated the activity, used for accurate time interpretation. | |
| Subject | String | Subject or title of the activity associated with this update. | |
| Type | String | Type of the activity associated with this update, such as call, meeting, or task. | |
| UpdateTime | Datetime | Timestamp indicating when the update record was last modified. | |
| UpdateUserId | Integer | Unique identifier of the user who last modified the update record. | |
| UserId | Integer | Unique identifier of the user associated with this update event. | |
| Object | String | Type name of the Pipedrive object this update event relates to, such as activity or note. | |
| Timestamp | Datetime | Timestamp indicating when this update event occurred in the activity feed. |
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. |