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