Recents
Returns data about all recent changes occurred after given timestamp.
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 |
| Id | = |
| Item | = |
| SinceTimestamp | = |
For example, the following queries are processed server-side:
SELECT * FROM Recents
SELECT * FROM Recents WHERE Id = 2
SELECT * FROM Recents WHERE Id = 2 and SinceTimestamp = '022-01-01 01:29:32'
Columns
| Name | Type | References | Description |
| Id | Integer | The unique identifier of the recent change record. | |
| DataActive | Boolean | Indicates whether the changed record is currently active. | |
| DataActiveFlag | Boolean | Indicates whether the changed record is marked as active using the active flag field. | |
| DataActivitiesCount | Integer | The total number of activities associated with the changed record. | |
| DataAddTime | Datetime | The date and time when the changed record was originally created. | |
| DataAssignedToUserId | Integer | The unique identifier of the user to whom the changed record is assigned. | |
| DataAttendees | String | The list of attendees for the changed activity record, returned as an aggregate. | |
| DataBusyFlag | String | Indicates whether the activity in the changed record marks the assigned user as busy during its scheduled time. | |
| DataCalendarSyncContext | String | The calendar synchronization context included when syncing the activity to an external calendar. | |
| DataCcEmail | String | The BCC email address associated with the changed record for email drop-box functionality. | |
| DataCloseTime | String | The date and time when the deal in the changed record was closed. | |
| DataCompanyId | Integer | The unique identifier of the company account that owns the changed record. | |
| DataConferenceMeetingClient | String | The name of the video conferencing client used for the activity in the changed record. | |
| DataConferenceMeetingId | String | The identifier of the video conference meeting associated with the activity in the changed record. | |
| DataConferenceMeetingUrl | String | The URL of the video conference meeting associated with the activity in the changed record. | |
| DataCreatedByUserId | Integer | The unique identifier of the user who created the changed record. | |
| DataCreatorUserId | Integer | The unique identifier of the user designated as the creator of the changed record. | |
| DataCurrency | String | The ISO currency code associated with the monetary value of the changed record. | |
| DataDealDropboxBcc | String | The BCC email address used to drop emails directly into the deal associated with the changed record. | |
| DataDealId | String | The unique identifier of the deal associated with the changed record. | |
| DataDealTitle | String | The title of the deal associated with the changed record. | |
| DataDeleted | Boolean | Indicates whether the changed record has been deleted. | |
| DataDone | Boolean | Indicates whether the activity in the changed record has been marked as completed. | |
| DataDoneActivitiesCount | Integer | The number of completed activities associated with the changed record. | |
| DataDueDate | Date | The due date of the activity or task in the changed record. | |
| DataDueTime | Datetime | The due time of the activity in the changed record. | |
| DataDuration | Datetime | The scheduled duration of the activity in the changed record. | |
| DataEmailMessagesCount | Integer | The number of email messages associated with the changed record. | |
| DataExpectedCloseDate | Date | The expected close date set on the deal in the changed record. | |
| DataFileId | String | The unique identifier of the file attached to the changed record. | |
| DataFileCleanName | String | The sanitized display name of the file attached to the changed record. | |
| DataFileUrl | String | The download URL of the file attached to the changed record. | |
| DataFilesCount | Integer | The number of files attached to the changed record. | |
| DataFirstWonTime | String | The date and time when the deal in the changed record was first marked as won. | |
| DataFollowersCount | Integer | The number of users following the changed record. | |
| DataFormattedValue | String | The deal value of the changed record formatted with currency symbol and decimal notation. | |
| DataFormattedWeightedValue | String | The probability-weighted deal value of the changed record formatted with currency symbol and decimal notation. | |
| DataGcalEventId | String | The Google Calendar event identifier for the activity in the changed record. | |
| DataGoogleCalendarEtag | String | The Google Calendar entity tag used for change detection of the synced calendar event. | |
| DataGoogleCalendarId | String | The Google Calendar identifier where the activity in the changed record is synced. | |
| DataId | Integer | The unique identifier of the data object within the changed record. | |
| DataLabel | String | The label or tag applied to the changed record for categorization. | |
| ActivityDate | String | The date of the most recent activity associated with the changed record. | |
| ActivityId | String | The unique identifier of the most recent activity associated with the changed record. | |
| IncomingMailTime | String | The date and time of the most recent incoming email associated with the changed record. | |
| LastNotificationTime | String | The date and time when the most recent notification was sent for the changed record. | |
| LastNotificationUserId | String | The unique identifier of the user who received the most recent notification for the changed record. | |
| LastOutgoingMailTime | String | The date and time of the most recent outgoing email associated with the changed record. | |
| LeadId | String | The unique identifier of the lead associated with the changed record. | |
| LeadTitle | String | The title of the lead associated with the changed record. | |
| Location | String | The location or address associated with the activity in the changed record. | |
| AreaLevel1 | String | The first-level administrative area, such as a state or province, of the location in the changed record. | |
| AreaLevel2 | String | The second-level administrative area, such as a county or district, of the location in the changed record. | |
| LocationCountry | String | The country component of the location in the changed record. | |
| LocationFormattedAddress | String | The full formatted address string of the location in the changed record. | |
| Locationlocality | String | The city or locality component of the location in the changed record. | |
| LocationPostalCode | String | The postal or ZIP code component of the location in the changed record. | |
| LocationRoute | String | The street name or route component of the location in the changed record. | |
| LocationStreetNumber | String | The street number component of the location in the changed record. | |
| LocationSublocality | String | The sub-locality component, such as a neighborhood, of the location in the changed record. | |
| LocationSubpremise | String | The sub-premise component, such as an apartment number, of the location in the changed record. | |
| LostReason | String | The reason provided when the deal in the changed record was marked as lost. | |
| LostTime | String | The date and time when the deal in the changed record was marked as lost. | |
| MarkedAsDoneTime | String | The date and time when the activity in the changed record was marked as completed. | |
| NextActivityDate | String | The scheduled date of the next upcoming activity associated with the changed record. | |
| NextActivityDuration | String | The scheduled duration of the next upcoming activity associated with the changed record. | |
| NextActivityId | String | The unique identifier of the next upcoming activity associated with the changed record. | |
| NextActivityNote | String | The note or description attached to the next upcoming activity associated with the changed record. | |
| NextActivitySubject | String | The subject line of the next upcoming activity associated with the changed record. | |
| NextActivityTime | String | The scheduled time of the next upcoming activity associated with the changed record. | |
| NextActivityType | String | The type of the next upcoming activity associated with the changed record, such as call, meeting, or email. | |
| Note | String | The note text associated with the changed record. | |
| NotesCount | Integer | The total number of notes associated with the changed record. | |
| NotificationLanguageId | Integer | The identifier of the language used for notifications related to the changed record. | |
| OrgHidden | Boolean | Indicates whether the organization associated with the changed record is hidden from the current user. | |
| OrgId | Integer | The unique identifier of the organization associated with the changed record. | |
| OrgName | String | The name of the organization associated with the changed record. | |
| OwnerName | String | The full name of the user who owns the changed record. | |
| Participants | String | The list of participants in the activity of the changed record, returned as an aggregate. | |
| ParticipantsCount | Integer | The total number of participants in the activity of the changed record. | |
| PersonDropboxBcc | String | The BCC email address used to drop emails directly into the person record associated with the changed record. | |
| PersonHidden | Boolean | Indicates whether the person associated with the changed record is hidden from the current user. | |
| PersonId | Integer | The unique identifier of the person associated with the changed record. | |
| PersonName | String | The full name of the person associated with the changed record. | |
| PipelineId | Integer | The unique identifier of the pipeline that contains the deal in the changed record. | |
| Probability | String | The win probability percentage set on the deal in the changed record. | |
| ProductsCount | Integer | The number of products associated with the deal in the changed record. | |
| PublicDescription | String | The publicly visible description text associated with the changed record. | |
| RecMasterActivityId | String | The unique identifier of the master recurring activity from which the activity in the changed record was generated. | |
| RecRule | String | The iCalendar recurrence rule (RRULE) string that defines the repeat pattern for the recurring activity in the changed record. | |
| RecRuleExtension | String | Additional recurrence rule extension data for the recurring activity in the changed record. | |
| ReferenceId | String | The identifier of the external reference associated with the changed record. | |
| ReferenceType | String | The type of the external reference associated with the changed record, indicating what kind of external entity is referenced. | |
| RottenTime | String | The date and time when the deal in the changed record is considered rotten due to inactivity. | |
| Series | String | The series identifier grouping recurring activity instances in the changed record. | |
| SourceTimezone | String | The timezone of the source system where the activity in the changed record was originally created. | |
| StageChangeTime | String | The date and time when the deal in the changed record was last moved to a different pipeline stage. | |
| StageId | Integer | The unique identifier of the pipeline stage that contains the deal in the changed record. | |
| StageOrderNr | Integer | The display order number of the pipeline stage within its pipeline for the deal in the changed record. | |
| Status | String | The current status of the changed record, such as open, won, or lost for deals. | |
| Subject | String | The subject or title of the activity in the changed record. | |
| DataTitle | String | The title or name of the changed record. | |
| DataType | String | The type of Pipedrive object that was changed, such as deal, person, organization, or activity. | |
| UndoneActivitiesCount | Integer | The number of incomplete activities associated with the changed record. | |
| UpdateTime | Datetime | The date and time when the changed record was last updated. | |
| UpdateUserId | String | The unique identifier of the user who last updated the changed record. | |
| UserId | Integer | The unique identifier of the user associated with the changed record. | |
| Value | Integer | The monetary value of the deal in the changed record. | |
| VisibleTo | String | The visibility setting of the changed record, controlling which users can see it. | |
| WeightedValue | Integer | The probability-adjusted monetary value of the deal in the changed record. | |
| WeightedValueCurrency | String | The ISO currency code used for the weighted value of the deal in the changed record. | |
| WonTime | String | The date and time when the deal in the changed record was marked as won. | |
| Item | String | The type of Pipedrive item to filter recent changes by, such as deal, person, organization, or activity. |
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 | |
| SinceTimestamp | Datetime | Timestamp in UTC.
The default value is 2000-01-01 01:29:32. |