ProductsDeals
Get details of Products Deals.
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.
- Status supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM ProductsDeals WHERE Id = 10 SELECT * FROM ProductsDeals WHERE Id = 10 AND status = 'open'
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Id. | |
| ProductId | Integer | Products Id. | |
| Active | Boolean | Active. | |
| ActivitiesCount | Integer | ActivitiesCount. | |
| AddTime | Datetime | AddTime. | |
| CcEmail | String | CcEmail. | |
| CloseTime | String | CloseTime. | |
| CreatorActiveFlag | Boolean | CreatorActiveFlag. | |
| CreatorEmail | String | CreatorEmail. | |
| CreatorHasPic | Boolean | CreatorHasPic. | |
| CreatorId | Integer | CreatorId. | |
| CreatorName | String | CreatorName. | |
| CreatorPicHash | String | CreatorPicHash. | |
| CreatorValue | Integer | CreatorValue. | |
| Currency | String | Currency. | |
| Deleted | Boolean | Deleted. | |
| DoneActivitiesCount | Integer | DoneActivitiesCount. | |
| EmailMessagesCount | Integer | EmailMessagesCount. | |
| ExpectedCloseDate | String | ExpectedCloseDate. | |
| FilesCount | Integer | FilesCount. | |
| FirstWonTime | String | FirstWonTime. | |
| FollowersCount | Integer | FollowersCount. | |
| FormattedValue | String | FormattedValue. | |
| FormattedWeightedValue | String | FormattedWeightedValue. | |
| Label | String | Label. | |
| LastActivityDate | String | LastActivityDate. | |
| LastActivityId | String | LastActivityId. | |
| LastIncomingMailTime | String | LastIncomingMailTime. | |
| LastOutgoingMailTime | String | LastOutgoingMailTime. | |
| LostReason | String | LostReason. | |
| LostTime | String | LostTime. | |
| NextActivityDate | Date | NextActivityDate. | |
| NextActivityDuration | Time | NextActivityDuration. | |
| NextActivityId | Integer | NextActivityId. | |
| NextActivityNote | String | NextActivityNote. | |
| NextActivitySubject | String | NextActivitySubject. | |
| NextActivityTime | Time | NextActivityTime. | |
| NextActivityType | String | NextActivityType. | |
| NotesCount | Integer | NotesCount. | |
| OrgHidden | Boolean | OrgHidden. | |
| OrgIdName | String | OrgId Name. | |
| OrgIdPeopleCount | Integer | OrgId People count. | |
| OrgIdOwnerId | Integer | OrgId Owner Id. | |
| OrgIdAddress | String | OrgId Address. | |
| OrgIdActiveFlag | Boolean | OrgId Active flag. | |
| OrgIdCcEmail | String | OrgId CcEmail. | |
| OrgIdValue | Integer | OrgId Value. | |
| OrgName | String | OrgName. | |
| OwnerName | String | OwnerName. | |
| ParticipantsCount | Integer | ParticipantsCount. | |
| PersonHidden | Boolean | PersonHidden. | |
| PersonActiveFlag | Boolean | PersonActiveFlag. | |
| PersonEmail | String | PersonEmail. | |
| PersonIdName | String | PersonName. | |
| PersonPhone | String | PersonPhone. | |
| PersonValue | Integer | PersonValue. | |
| PipelineId | Integer | PipelineId. | |
| Probability | String | Probability. | |
| ProductsCount | Integer | ProductsCount. | |
| RottenTime | String | RottenTime. | |
| StageChangeTime | String | StageChangeTime. | |
| StageId | Integer | StageId. | |
| StageOrderNr | Integer | StageOrderNr. | |
| Status | String | Only fetch deals with specific status.
The allowed values are open, won, lost, deleted, all_not_deleted. The default value is all_not_deleted. | |
| Title | String | Title. | |
| UndoneActivitiesCount | Integer | UndoneActivitiesCount. | |
| UpdateTime | Datetime | UpdateTime. | |
| UserActiveFlag | Boolean | UserActiveFlag. | |
| UserEmail | String | UserEmail. | |
| UserHasPic | Boolean | UserHasPic. | |
| UserId | Integer | UserId. | |
| UserName | String | UserName. | |
| UserPicHash | String | UserPicHash. | |
| Uservalue | Integer | Uservalue. | |
| Value | Double | Value. | |
| VisibleTo | String | VisibleTo. | |
| WeightedValue | Double | WeightedValue. | |
| WeightedValueCurrency | String | WeightedValueCurrency. | |
| WonTime | String | WonTime. | |
| PersonName | String | Person name. |