ProductsDeals
Returns all deals that include the specified product, with full deal details including participants, activities, and pipeline information.
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 | = |
| Status | = |
For example, the following queries are 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 | The unique identifier of the deal. | |
| ProductId | Integer | The unique identifier of the product whose deals are returned. | |
| Active | Boolean | Whether the deal is currently active. | |
| ActivitiesCount | Integer | The total number of activities associated with the deal. | |
| AddTime | Datetime | The date and time when the deal was created. | |
| CcEmail | String | The BCC email address used to add emails to the deal. | |
| CloseTime | String | The date and time when the deal was closed. | |
| CreatorActiveFlag | Boolean | Whether the deal creator's user account is active. | |
| CreatorEmail | String | The email address of the user who created the deal. | |
| CreatorHasPic | Boolean | Whether the deal creator has a profile picture set. | |
| CreatorId | Integer | The unique identifier of the user who created the deal. | |
| CreatorName | String | The full name of the user who created the deal. | |
| CreatorPicHash | String | The hash of the deal creator's profile picture. | |
| CreatorValue | Integer | The numeric ID value of the deal creator user. | |
| Currency | String | The currency code of the deal value, for example USD or EUR. | |
| Deleted | Boolean | Whether the deal has been deleted. | |
| DoneActivitiesCount | Integer | The number of completed activities associated with the deal. | |
| EmailMessagesCount | Integer | The number of email messages associated with the deal. | |
| ExpectedCloseDate | String | The expected close date of the deal. | |
| FilesCount | Integer | The number of files attached to the deal. | |
| FirstWonTime | String | The date and time when the deal was first marked as won. | |
| FollowersCount | Integer | The number of users following the deal. | |
| FormattedValue | String | The deal value formatted with the currency symbol and separators. | |
| FormattedWeightedValue | String | The probability-weighted deal value formatted with the currency symbol and separators. | |
| Label | String | The label or tag applied to the deal. | |
| LastActivityDate | String | The date of the most recent activity on the deal. | |
| LastActivityId | String | The unique identifier of the most recent activity on the deal. | |
| LastIncomingMailTime | String | The date and time of the last incoming email associated with the deal. | |
| LastOutgoingMailTime | String | The date and time of the last outgoing email associated with the deal. | |
| LostReason | String | The reason entered when the deal was marked as lost. | |
| LostTime | String | The date and time when the deal was marked as lost. | |
| NextActivityDate | Date | The scheduled date of the next activity on the deal. | |
| NextActivityDuration | Time | The duration of the next scheduled activity on the deal. | |
| NextActivityId | Integer | The unique identifier of the next scheduled activity on the deal. | |
| NextActivityNote | String | The note attached to the next scheduled activity on the deal. | |
| NextActivitySubject | String | The subject of the next scheduled activity on the deal. | |
| NextActivityTime | Time | The time of the next scheduled activity on the deal. | |
| NextActivityType | String | The type of the next scheduled activity on the deal. | |
| NotesCount | Integer | The number of notes associated with the deal. | |
| OrgHidden | Boolean | Whether the associated organization is hidden from the current user. | |
| OrgIdName | String | The name of the organization associated with the deal. | |
| OrgIdPeopleCount | Integer | The number of people associated with the deal's organization. | |
| OrgIdOwnerId | Integer | The unique identifier of the owner of the deal's organization. | |
| OrgIdAddress | String | The address of the organization associated with the deal. | |
| OrgIdActiveFlag | Boolean | Whether the organization associated with the deal is active. | |
| OrgIdCcEmail | String | The BCC email address of the organization associated with the deal. | |
| OrgIdValue | Integer | The numeric ID of the organization associated with the deal. | |
| OrgName | String | The name of the organization associated with the deal. | |
| OwnerName | String | The full name of the user who owns the deal. | |
| ParticipantsCount | Integer | The number of participants associated with the deal. | |
| PersonHidden | Boolean | Whether the associated person is hidden from the current user. | |
| PersonActiveFlag | Boolean | Whether the person associated with the deal has an active account. | |
| PersonEmail | String | The email addresses of the person associated with the deal. | |
| PersonIdName | String | The full name of the person associated with the deal. | |
| PersonPhone | String | The phone numbers of the person associated with the deal. | |
| PersonValue | Integer | The numeric ID of the person associated with the deal. | |
| PipelineId | Integer | The unique identifier of the pipeline that contains the deal. | |
| Probability | String | The win probability percentage assigned to the deal. | |
| ProductsCount | Integer | The number of products attached to the deal. | |
| RottenTime | String | The date and time when the deal became rotten due to inactivity. | |
| StageChangeTime | String | The date and time when the deal last moved to a different stage. | |
| StageId | Integer | The unique identifier of the pipeline stage the deal is currently in. | |
| StageOrderNr | Integer | The order number of the stage within its pipeline. | |
| 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 | The title of the deal. | |
| UndoneActivitiesCount | Integer | The number of incomplete activities associated with the deal. | |
| UpdateTime | Datetime | The date and time when the deal was last updated. | |
| UserActiveFlag | Boolean | Whether the deal owner's user account is active. | |
| UserEmail | String | The email address of the deal owner. | |
| UserHasPic | Boolean | Whether the deal owner has a profile picture set. | |
| UserId | Integer | The unique identifier of the user who owns the deal. | |
| UserName | String | The full name of the user who owns the deal. | |
| UserPicHash | String | The hash of the deal owner's profile picture. | |
| Uservalue | Integer | The numeric ID value of the deal owner user. | |
| Value | Double | The monetary value of the deal. | |
| VisibleTo | String | The visibility setting that determines which users can see the deal. | |
| WeightedValue | Double | The deal value multiplied by the win probability percentage. | |
| WeightedValueCurrency | String | The currency code of the weighted deal value. | |
| WonTime | String | The date and time when the deal was marked as won. | |
| PersonName | String | The full name of the person associated with the deal. |