Recents
Returns data about all recent changes occurred after given timestamp.
Select
The add-in will use 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 add-in.
- Id supports the '=' operator.
- Item supports the '=' operator.
- SinceTimestamp supports the '=' operator.
For example, the following query is 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 | Description |
| Id | Integer | Id. |
| DataActive | Boolean | DataActive. |
| DataActiveFlag | Boolean | DataActiveFlag. |
| DataActivitiesCount | Integer | DataActivitiesCount. |
| DataAddTime | Datetime | DataAddTime. |
| DataAssignedToUserId | Integer | DataAssignedToUserId. |
| DataAttendees | String | DataAttendees. |
| DataBusyFlag | String | Data BusyFlag. |
| DataCalendarSyncContext | String | DataCalendarSyncContext. |
| DataCcEmail | String | DataCcEmail. |
| DataCloseTime | String | DataCloseTime. |
| DataCompanyId | Integer | DataCompanyId. |
| DataConferenceMeetingClient | String | DataConferenceMeetingClient. |
| DataConferenceMeetingId | String | DataConferenceMeetingId. |
| DataConferenceMeetingUrl | String | DataConferenceMeetingUrl. |
| DataCreatedByUserId | Integer | DataCreatedByUserId. |
| DataCreatorUserId | Integer | DataCreatorUserId. |
| DataCurrency | String | DataCurrency. |
| DataDealDropboxBcc | String | DataDealDropboxBcc. |
| DataDealId | String | DataDealId. |
| DataDealTitle | String | DataDealTitle. |
| DataDeleted | Boolean | DataDeleted. |
| DataDone | Boolean | DataDone. |
| DataDoneActivitiesCount | Integer | DataDoneActivitiesCount. |
| DataDueDate | Date | DataDueDate. |
| DataDueTime | Datetime | DataDueTime. |
| DataDuration | Datetime | DataDuration. |
| DataEmailMessagesCount | Integer | DataEmailMessagesCount. |
| DataExpectedCloseDate | Date | DataExpectedCloseDate. |
| DataFileId | String | DataFile Id. |
| DataFileCleanName | String | DataFile clean name. |
| DataFileUrl | String | DataFile url. |
| DataFilesCount | Integer | DataFilesCount. |
| DataFirstWonTime | String | DataFirstWonTime. |
| DataFollowersCount | Integer | DataFollowersCount. |
| DataFormattedValue | String | DataFormattedValue. |
| DataFormattedWeightedValue | String | DataFormattedWeightedValue. |
| DataGcalEventId | String | DataGcalEventId. |
| DataGoogleCalendarEtag | String | DataGoogleCalendarEtag. |
| DataGoogleCalendarId | String | DataGoogleCalendarId. |
| DataId | Integer | DataId. |
| DataLabel | String | DataLabel. |
| ActivityDate | String | ActivityDate. |
| ActivityId | String | ActivityId. |
| IncomingMailTime | String | IncomingMailTime. |
| LastNotificationTime | String | Last_notification_time. |
| LastNotificationUserId | String | Last_notification_user_id. |
| LastOutgoingMailTime | String | Last_outgoing_mail_time. |
| LeadId | String | LeadId. |
| LeadTitle | String | LeadTitle. |
| Location | String | Location. |
| AreaLevel1 | String | AreaLevel1. |
| AreaLevel2 | String | AreaLevel2. |
| LocationCountry | String | LocationCountry. |
| LocationFormattedAddress | String | LocationFormattedAddress. |
| Locationlocality | String | Locationlocality. |
| LocationPostalCode | String | LocationPostalCode. |
| LocationRoute | String | LocationRoute. |
| LocationStreetNumber | String | LocationStreetNumber. |
| LocationSublocality | String | LocationSublocality. |
| LocationSubpremise | String | LocationSubpremise. |
| LostReason | String | LostReason. |
| LostTime | String | LostTime. |
| MarkedAsDoneTime | String | MarkedAsDoneTime. |
| NextActivityDate | String | NextActivityDate. |
| NextActivityDuration | String | NextActivityDuration. |
| NextActivityId | String | NextActivityId. |
| NextActivityNote | String | NextActivityNote. |
| NextActivitySubject | String | NextActivitySubject. |
| NextActivityTime | String | NextActivityTime. |
| NextActivityType | String | NextActivityType. |
| Note | String | Note. |
| NotesCount | Integer | NotesCount. |
| NotificationLanguageId | Integer | NotificationLanguageId. |
| OrgHidden | Boolean | OrgHidden. |
| OrgId | Integer | OrgId. |
| OrgName | String | OrgName. |
| OwnerName | String | OwnerName. |
| Participants | String | Participants. |
| ParticipantsCount | Integer | ParticipantsCount. |
| PersonDropboxBcc | String | PersonDropboxBcc. |
| PersonHidden | Boolean | PersonHidden. |
| PersonId | Integer | PersonId. |
| PersonName | String | PersonName. |
| PipelineId | Integer | PipelineId. |
| Probability | String | Probability. |
| ProductsCount | Integer | ProductsCount. |
| PublicDescription | String | PublicDescription. |
| RecMasterActivityId | String | RecMasterActivityId. |
| RecRule | String | RecRule. |
| RecRuleExtension | String | RecRuleExtension. |
| ReferenceId | String | ReferenceId. |
| ReferenceType | String | ReferenceType. |
| RottenTime | String | RottenTime. |
| Series | String | Series. |
| SourceTimezone | String | SourceTimezone. |
| StageChangeTime | String | StageChangeTime. |
| StageId | Integer | StageId. |
| StageOrderNr | Integer | StageOrderNr. |
| Status | String | Status. |
| Subject | String | Subject. |
| DataTitle | String | DataTitle. |
| DataType | String | DataType. |
| UndoneActivitiesCount | Integer | UndoneActivitiesCount. |
| UpdateTime | Datetime | UpdateTime. |
| UpdateUserId | String | UpdateUserId. |
| UserId | Integer | UserId. |
| Value | Integer | Value. |
| VisibleTo | String | VisibleTo. |
| WeightedValue | Integer | WeightedValue. |
| WeightedValueCurrency | String | WeightedValueCurrency. |
| WonTime | String | WonTime. |
| Item | String | Item. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| SinceTimestamp | Datetime | Timestamp in UTC.
The default value is 2000-01-01 01:29:32. |