DealsArchived
Returns data about all archived deals.
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 | = |
| OwnerId | = |
| PersonId | = |
| OrgId | = |
| StageId | = |
| PipelineId | = |
| UpdateTime | = |
| Status | = |
| FilterId | = |
For example, the following queries are processed server-side:
SELECT * FROM DealsArchived WHERE Id = 14
SELECT * FROM DealsArchived WHERE StageId = 1
SELECT * FROM DealsArchived WHERE Status = 'Open'
SELECT * FROM DealsArchived WHERE FilterId = 1
Order by is supported server-side for following columns: Id, AddTime, UpdateTime.
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Deals id. | |
| Title | String | Title. | |
| CreatorUserId | Integer | Creator User Id. | |
| OwnerId | Integer | Owner Id. | |
| Value | Double | Value of the deal. | |
| PersonId | Integer | Person Id. | |
| OrgId | Integer | Org Id. | |
| StageId | Integer | Stage Id. | |
| PipelineId | Integer | Pipeline Id. | |
| Currency | String | Currency. | |
| AddTime | Datetime | Add Time. | |
| ArchiveTime | Datetime | Archive Time. | |
| UpdateTime | Datetime | Update Time. | |
| StageChangeTime | Datetime | Stage Change Time. | |
| Status | String | Status.
The allowed values are open, won, lost, deleted. | |
| IsArchived | Boolean | A flag indicating whether the deal is archived or not. | |
| IsDeleted | Boolean | A flag indicating whether the deal is deleted or not. | |
| Probability | Integer | Gives the Probability percentage rounded off to nearest integer. | |
| LostReason | String | Lost Reason. | |
| VisibleTo | Integer | Visible To. | |
| CloseTime | Datetime | Close Time. | |
| WonTime | Datetime | Won Time. | |
| LostTime | Datetime | Lost Time. | |
| LocalWonDate | Date | Local Won Date. | |
| LocalLostDate | Date | Local Lost Date. | |
| LocalCloseDate | Date | Local Close Date. | |
| ExpectedCloseDate | Date | Expected Close Date. | |
| LabelIds | String | Label Ids. | |
| Origin | String | Origin. | |
| OriginId | String | Origin Id. | |
| Channel | Integer | Channel. | |
| ChannelId | String | Channel Id. | |
| Acv | Integer | Acv. | |
| Arr | Integer | Arr. | |
| Mrr | Integer | Mrr. | |
| ActivitiesCount | Integer | Activities Count. | |
| SmartBccEmail | String | SmartBccEmail. | |
| NextActivityId | Integer | Next Activity Id. | |
| LastActivityId | Integer | Last Activity Id. | |
| FirstWonTime | Datetime | First Won Time. | |
| ProductsCount | Integer | Last Activity Id. | |
| FilesCount | Integer | Products Count. | |
| NotesCount | Integer | Notes Count. | |
| FollowersCount | Integer | Followers Count. | |
| EmailMessagesCount | Integer | Email Messages Count. | |
| DoneActivitiesCount | Integer | Done Activities Count. | |
| UndoneActivitiesCount | Integer | Undone Activities Count. | |
| ParticipantsCount | Integer | Participants Count. | |
| LastIncomingMailTime | Datetime | Last Incoming Mail Time. | |
| LastOutgoingMailTime | Datetime | Last Outgoing Mail Time. |
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 | |
| FilterId | Integer | The ID of the Filter to use. Filter is a set of data validation conditions. |