DealsUpdates
Returns the activity feed updates for a specific deal, including field changes, notes, emails, activities, and other deal events.
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 |
| DealId | = |
| AllChanges | = |
| Items | =, IN |
For example, the following queries are processed server-side:
SELECT * FROM DealsUpdates WHERE DealId = 3
SELECT * FROM DealsUpdates WHERE DealId = 246 AND AllChanges = 1
SELECT * FROM DealsUpdates WHERE DealId = 246 AND Items IN ('activity', 'call')
Columns
| Name | Type | References | Description |
| Id | Integer | The unique identifier of the update record. | |
| AccountId | String | The identifier of the mail account associated with this update. | |
| ActiveFlag | Boolean | Indicates whether this update record is active. | |
| AddTime | Datetime | The date and time when this update was recorded. | |
| AdditionalData | String | Additional metadata associated with this update record. | |
| AssignedToUserId | Integer | The unique identifier of the user to whom this update item is assigned. | |
| Attachments | String | The file attachments associated with this update record. | |
| Attendees | String | The attendees associated with an activity in this update record. | |
| Bcc | String | The BCC recipients for a mail message in this update record. | |
| BodyUrl | String | The URL from which the full message body can be retrieved for a mail message update. | |
| BusyFlag | Boolean | Indicates whether the assigned user is marked as busy during the activity in this update. | |
| IncludeContext | String | Indicates whether contextual deal information is included when this activity is synchronized to a calendar. | |
| Cc | String | The CC recipients for a mail message in this update record. | |
| ChangeSource | String | The source system or interface through which this change was made. | |
| UserAgent | String | The user agent string of the client that made this change. | |
| CompanyId | Integer | The identifier of the Pipedrive company account associated with this update. | |
| MeetingClient | String | The conferencing client used for a meeting activity in this update. | |
| MeetingId | String | The unique identifier of the conference meeting linked to this update. | |
| MeetingUrl | String | The join URL for the conference meeting linked to this update. | |
| CreatedByUserId | Integer | The unique identifier of the user who created this update record. | |
| DealDropboxBcc | String | The Smart BCC email address for linking emails directly to this deal. | |
| DealId | Integer | The unique identifier of the deal this update belongs to. | |
| DealTitle | String | The title of the deal this update belongs to. | |
| DeletedFlag | Integer | Indicates whether this update record has been deleted. A value of 1 means it is deleted. | |
| Done | Boolean | Indicates whether the activity in this update has been marked as completed. | |
| Draft | String | The draft status identifier for a mail message in this update. | |
| DraftFlag | Integer | Indicates whether a mail message in this update is a draft. A value of 1 means the message has not been sent. | |
| DueDate | Date | The due date of the activity in this update record. | |
| DueTime | Time | The due time of the activity in this update record. | |
| Duration | Time | The scheduled duration of the activity in this update record. | |
| ExternalDeletedFlag | Integer | Indicates whether this record was deleted in the external mail provider. A value of 1 means it was deleted externally. | |
| FieldKey | String | The API key of the deal field that was changed in this update. | |
| CleanName | String | The sanitized display name of the file attached to this update. | |
| FileId | String | The unique identifier of the file attached to this update. | |
| Url | String | The download URL of the file attached to this update. | |
| From | String | The senders of a mail message in this update record. | |
| GcalEventId | String | The Google Calendar event identifier for an activity synchronized to Google Calendar. | |
| GoogleCalendarEtag | String | The ETag value for the Google Calendar event associated with this activity. | |
| GoogleCalendarId | String | The identifier of the Google Calendar where the associated activity event is stored. | |
| AttachmentsFlag | Integer | Indicates whether a mail message in this update has file attachments. A value of 1 means attachments are present. | |
| BodyFlag | Integer | Indicates whether a mail message in this update has a message body. A value of 1 means a body is present. | |
| InlineAttachmentsFlag | Integer | Indicates whether a mail message in this update contains inline attachments such as embedded images. | |
| RealAttachmentsFlag | Integer | Indicates whether a mail message in this update contains downloadable file attachments, excluding inline content. | |
| IsBulkUpdateFlag | String | Indicates whether this change was applied as part of a bulk update operation. | |
| ItemId | Integer | The unique identifier of the item referenced by this update record. | |
| ItemType | String | The type of the item referenced by this update record, such as deal or activity. | |
| NotificationTime | Datetime | The date and time of the most recent notification sent for this update. | |
| NotificationUserId | Integer | The unique identifier of the user who last received a notification for this update. | |
| LeadId | String | The unique identifier of the lead associated with this update record, if applicable. | |
| Location | String | The location of the activity in this update record. | |
| AdminAreaLevel1 | String | The state or province component of the activity location address. | |
| AdminAreaLevel2 | String | The county or district component of the activity location address. | |
| Country | String | The country component of the activity location address. | |
| FormattedAddress | String | The full formatted address of the activity location. | |
| Lat | Double | The latitude coordinate of the activity location. | |
| Locality | String | The city or locality component of the activity location address. | |
| Long | Double | The longitude coordinate of the activity location. | |
| PostalCode | String | The postal code component of the activity location address. | |
| Route | String | The street or route component of the activity location address. | |
| StreetNumber | String | The street number component of the activity location address. | |
| Sublocality | String | The neighborhood or sublocality component of the activity location address. | |
| Subpremise | String | The suite or unit component of the activity location address. | |
| LogTime | Datetime | The date and time when this update event was logged in the deal's activity feed. | |
| TrackingEnabledFlag | Integer | Indicates whether link tracking is enabled for a mail message in this update. | |
| MailThreadId | Integer | The identifier of the mail thread associated with a mail message in this update. | |
| MailTrackingStatus | String | The open and click tracking status of a mail message in this update. | |
| MarkedAsDoneTime | Datetime | The date and time when the activity in this update was marked as completed. | |
| MessageTime | String | The timestamp of the mail message as reported by the mail provider. | |
| MuaMessageId | String | The unique message identifier assigned by the mail user agent. | |
| NewValue | String | The value of the field after the change recorded in this update. | |
| Note | String | The text content of a note recorded in this update. | |
| LanguageId | Integer | The identifier of the language used for notifications associated with this update. | |
| NylasId | String | The identifier assigned to a mail message in this update by the Nylas mail synchronization service. | |
| OldValue | Integer | The value of the field before the change recorded in this update. | |
| OrgId | Integer | The unique identifier of the organization associated with this update. | |
| OrgName | String | The name of the organization associated with this update. | |
| OwnerName | String | The name of the user who owns the item referenced by this update. | |
| Participants | String | The participants associated with an activity in this update record. | |
| PersonDropboxBcc | String | The Smart BCC email address for linking emails to the person associated with this update. | |
| PersonId | Integer | The unique identifier of the person associated with this update. | |
| PersonName | String | The name of the person associated with this update. | |
| PublicDescription | String | The publicly visible description of the activity type associated with this update. | |
| ReadFlag | Integer | Indicates whether a mail message in this update has been read. A value of 1 means the message has been opened. | |
| RecActivityId | String | The unique identifier of the master activity in a recurring series, if applicable. | |
| RecRule | String | The recurrence rule defining the schedule for a recurring activity in this update. | |
| RecRuleExtension | String | Additional recurrence rule parameters that extend the base recurrence rule. | |
| ReferenceId | Integer | The unique identifier of the object referenced by this update, such as a note or file. | |
| ReferenceType | String | The type of object referenced by this update, such as note or file. | |
| S3Bucket | String | The name of the Amazon S3 bucket where mail message content for this update is stored. | |
| S3BucketPath | String | The path within the S3 bucket where mail message content for this update is stored. | |
| SentFlag | Integer | Indicates whether a mail message in this update has been sent. A value of 1 means the message was sent. | |
| SentFromPipedriveFlag | Integer | Indicates whether a mail message in this update was sent directly through Pipedrive. A value of 1 means it was sent from the Pipedrive interface. | |
| Series | String | The series identifier for a recurring activity in this update. | |
| SmartBccFlag | Integer | Indicates whether a mail message in this update was captured via Smart BCC. | |
| Snippet | String | A short preview excerpt from a mail message body in this update. | |
| SourceTimezone | String | The timezone of the source system where the activity in this update was originally created. | |
| Subject | String | The subject line of a mail message in this update, or the title of an activity. | |
| SyncedFlag | Integer | Indicates whether a mail message in this update has been synchronized with the external mail provider. | |
| TemplateId | String | The identifier of the email template used to compose a mail message in this update. | |
| Timestamp | Datetime | The date and time when this update record was last modified. | |
| To | String | The primary recipients of a mail message in this update record. | |
| Type | String | The type of update event, such as activity, note, change, or mailMessage. | |
| UpdateTime | Datetime | The date and time when this update record was last modified. | |
| UpdateUserId | Integer | The unique identifier of the user who last modified this update record. | |
| UserId | Integer | The unique identifier of the user associated with this update record. | |
| WriteFlag | Boolean | Indicates whether the current user has write access to this update record. | |
| Object | String | The object type identifier returned by the Pipedrive API for this update record. |
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. | |
| 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. |