PersonsProducts
Returns all products linked to deals associated with a specific person in Pipedrive, including full deal and product details.
View-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| DealPersonId | = |
For example, the following query is processed server-side:
SELECT * FROM PersonsProducts WHERE DealPersonId = 113
Columns
| Name | Type | References | Description |
| ProductId [KEY] | Integer | Unique identifier of the product. | |
| DealActive | Boolean | Indicates whether the deal linked to the product is currently active. | |
| DealActivitiesCount | Integer | Total number of activities associated with the linked deal. | |
| DealAddTime | Datetime | Date and time when the linked deal was created. | |
| DealCloseTime | String | Date and time when the linked deal was closed as won or lost. | |
| DealCompanyId | Integer | Identifier of the company account to which the linked deal belongs. | |
| DealCreatorUserId | Integer | Identifier of the user who created the linked deal. | |
| DealCurrency | String | Three-letter currency code for the linked deal value. | |
| DealDeleted | Boolean | Indicates whether the linked deal has been deleted. | |
| DealDoneActivitiesCount | Integer | Number of completed activities associated with the linked deal. | |
| DealEmailMessagesCount | Integer | Number of email messages associated with the linked deal. | |
| DealExpectedCloseDate | String | Date on which the linked deal is expected to close. | |
| DealFilesCount | Integer | Number of files attached to the linked deal. | |
| DealFirstAddtime | Datetime | Date and time when the linked deal was first created in the system. | |
| DealFirstWonTime | String | Date and time when the linked deal was first marked as won. | |
| DealFollowersCount | Integer | Number of users following the linked deal. | |
| DealId | Integer | Unique identifier of the deal linked to the product. | |
| DealLabel | String | Color label assigned to the linked deal for visual categorization. | |
| DealLastActivityDate | String | Date of the most recent activity associated with the linked deal. | |
| DealLastActivityId | String | Identifier of the most recent activity associated with the linked deal. | |
| DealLastIncomingMailTime | Datetime | Date and time of the most recently received email for the linked deal. | |
| DealLastOutgoingMailTime | Datetime | Date and time of the most recently sent email for the linked deal. | |
| DealLostReason | String | Reason recorded when the linked deal was marked as lost. | |
| DealLostTime | String | Date and time when the linked deal was marked as lost. | |
| DealNextActivityDate | Date | Date of the next scheduled activity for the linked deal. | |
| DealNextActivityId | Integer | Identifier of the next scheduled activity for the linked deal. | |
| DealNextActivityTime | String | Scheduled time of the next activity for the linked deal. | |
| DealNotesCount | Integer | Number of notes attached to the linked deal. | |
| DealOrgId | Integer | Identifier of the organization linked to the deal. | |
| DealParticipantsCount | Integer | Number of persons participating in the linked deal. | |
| DealPersonId | Integer |
Persons.Id | Identifier of the person linked to the deal. This field is required to query the table. |
| DealPipelineId | Integer | Identifier of the pipeline to which the linked deal belongs. | |
| DealProbability | String | Estimated probability of winning the linked deal, expressed as a percentage. | |
| DealProductsCount | Integer | Number of products attached to the linked deal. | |
| DealStageChangetime | Datetime | Date and time when the linked deal last moved to a different pipeline stage. | |
| DealStageId | Integer | Identifier of the pipeline stage the linked deal is currently in. | |
| DealStatus | String | Current status of the linked deal, for example open, won, or lost. | |
| DealTitle | String | Title or name of the linked deal. | |
| UndoneActivitiescount | Integer | Number of incomplete activities associated with the linked deal. | |
| DealUpdateTime | Datetime | Date and time when the linked deal was last updated. | |
| DealUserId | Integer | Identifier of the user who owns the linked deal. | |
| DealValue | Double | Monetary value of the linked deal in the specified currency. | |
| DealVisibleTo | String | Visibility setting of the linked deal, controlling which users can see it. | |
| DealWonTime | String | Date and time when the linked deal was marked as won. | |
| ProductActiveFlag | Boolean | Indicates whether the product is active and available for use. | |
| ProductAddTime | Datetime | Date and time when the product was created in Pipedrive. | |
| ProductCategory | String | Category assigned to the product for organizational purposes. | |
| ProductCode | String | Internal product code or SKU used to identify the product. | |
| ProductCompanyId | Integer | Identifier of the company account to which the product belongs. | |
| ProductDealId | Integer | Identifier of the deal to which the product is attached. | |
| ProductDescription | String | Detailed description of the product. | |
| ProductFilesCount | String | Number of files attached to the product. | |
| ProductFirstChar | String | First character of the product name, used for alphabetical indexing. | |
| ProductFollowersCount | Integer | Number of users following the product. | |
| ProductName | String | Name of the product. | |
| ProductOwnerId | Integer | Identifier of the user who owns the product. | |
| ProductSelectable | Boolean | Indicates whether the product can be selected and added to deals. | |
| ProductTax | Integer | Tax rate percentage applied to the product. | |
| ProductUnit | String | Unit of measure for the product, for example piece, hour, or license. | |
| ProductUpdateTime | Datetime | Date and time when the product record was last updated. | |
| ProductVisibleTo | String | Visibility setting of the product, controlling which users can see it. |