OrganizationsUpdates
Returns the activity and change history for a specified organization, including details about activities, field changes, notes, files, and other timeline events associated with that organization.
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 OrganizationsUpdates WHERE OrgId = 246
SELECT * FROM OrganizationsUpdates WHERE OrgId = 10 AND AllChanges = 1
SELECT * FROM OrganizationsUpdates WHERE OrgId = 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. | |
| ActivityId | String | Unique identifier of the activity associated with this update event. | |
| AddTime | Datetime | Timestamp indicating when the update record was created. | |
| NewValueFormatted | String | Human-readable formatted representation of the new field value after a change. | |
| OldValueFormatted | String | Human-readable formatted representation of the previous field value before 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. | |
| IncludeContext | 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. | |
| User_agent | String | User agent string of the client that submitted the change, providing additional context about the change source. | |
| Cid | String | Correlation identifier used to group related change events within a single transaction. | |
| CompanyId | Integer | Unique identifier of the Pipedrive company account associated with this update. | |
| ConferenceMeetingClient | String | Name of the conferencing client used for the meeting, such as Zoom or Google Meet. | |
| ConferenceMeetingId | String | Unique identifier of the conference meeting within the conferencing platform. | |
| ConferenceMeetingUrl | 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. | |
| DealName | String | Name of the deal associated with this update. | |
| DealTitle | String | Title of the deal associated with this update. | |
| Description | String | Descriptive text for the update event, such as the body of a note or activity description. | |
| 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. | |
| FileCleanName | 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. | |
| FileName | String | Original file name of the file attached to this update. | |
| FileSize | Integer | Size of the attached file in bytes. | |
| FileType | String | MIME type or file format of the attached file. | |
| 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. | |
| InlineFlag | Boolean | Indicates whether the attached file is displayed inline within the update feed. | |
| 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. | |
| LastNotificationTime | Datetime | Timestamp of the most recent notification sent for this update. | |
| LastNotificationUserId | 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. | |
| LogId | String | Unique identifier of this log entry in the organization's activity feed. | |
| LogTime | Datetime | Timestamp indicating when this update was logged in the activity feed. | |
| MessageId | String | Unique identifier of the mail message associated with this update, if the update event is an email. | |
| TemplateId | String | Unique identifier of the mail template used to generate the email message associated with this update. | |
| MarkedAsDoneTime | Datetime | Timestamp indicating when the associated activity was marked as done. | |
| Name | String | Name of the object or record associated with this update event. | |
| 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. | |
| NotificationLanguageId | Integer | Identifier of the language used for notifications related to this update. | |
| OldValue | Integer | Raw previous value of the field before the change event. | |
| OrgId | Integer | Unique identifier of the organization whose updates are returned. | |
| OrgName | String | Name of the organization associated with this update. | |
| OwnerName | String | Full name of the owner of the organization at the time of the update. | |
| Participants | String | JSON-encoded list of participants associated with the activity update. | |
| PeopleName | String | Name of the person associated with this update event, if applicable. | |
| PersonDropboxBcc | String | BCC email address for the person dropbox, used to associate incoming emails with the person. | |
| PersonId | Integer | Unique identifier of the person associated with this update event. | |
| PersonName | String | Full name of the person associated with this update. | |
| ProductId | String | Unique identifier of the product associated with this update, if applicable. | |
| ProductName | String | Name of the product associated with this update. | |
| PublicDescription | String | Public-facing description of the activity associated with this update. | |
| RecActivityId | 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. | |
| RemoteId | String | Identifier of the corresponding record in the remote storage system, such as a cloud file storage service. | |
| RemoteLocation | String | Name or identifier of the remote storage location where the associated file is stored. | |
| S3Bucket | String | Name of the Amazon S3 bucket where the associated file is stored. | |
| 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. | |
| Url | String | URL associated with this update event, such as a link to a file or external resource. | |
| 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, 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. |