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 | References | 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. |