PersonsProducts
Get details of Persons Products.
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.
- DealPersonId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM PersonsProducts WHERE DealPersonId = 113
Columns
| Name | Type | Description |
| ProductId [KEY] | Integer | ProductId. |
| DealActive | Boolean | DealActive. |
| DealActivitiesCount | Integer | DealActivitiesCount. |
| DealAddTime | Datetime | DealAddTime. |
| DealCloseTime | String | DealCloseTime. |
| DealCompanyId | Integer | DealCompanyId. |
| DealCreatorUserId | Integer | DealCreatorUserId. |
| DealCurrency | String | DealCurrency. |
| DealDeleted | Boolean | DealDeleted. |
| DealDoneActivitiesCount | Integer | DealDoneActivitiesCount. |
| DealEmailMessagesCount | Integer | DealEmailMessagesCount. |
| DealExpectedCloseDate | String | DealExpectedCloseDate. |
| DealFilesCount | Integer | DealFilesCount. |
| DealFirstAddtime | Datetime | DealFirstAddtime. |
| DealFirstWonTime | String | DealFirstWonTime. |
| DealFollowersCount | Integer | DealFollowersCount. |
| DealId | Integer | DealId. |
| DealLabel | String | DealLabel. |
| DealLastActivityDate | String | DealLastActivityDate. |
| DealLastActivityId | String | DealLastActivityId. |
| DealLastIncomingMailTime | Datetime | DealLastIncomingMailTime. |
| DealLastOutgoingMailTime | Datetime | DealLastOutgoingMailTime. |
| DealLostReason | String | DealLostReason. |
| DealLostTime | String | DealLostTime. |
| DealNextActivityDate | Date | DealNextActivityDate. |
| DealNextActivityId | Integer | DealNextActivityId. |
| DealNextActivityTime | String | DealNextActivityTime. |
| DealNotesCount | Integer | DealNotesCount. |
| DealOrgId | Integer | DealOrgId. |
| DealParticipantsCount | Integer | DealParticipantsCount. |
| DealPersonId | Integer | persons Id. |
| DealPipelineId | Integer | DealPipelineId. |
| DealProbability | String | DealProbability. |
| DealProductsCount | Integer | DealProductsCount. |
| DealStageChangetime | Datetime | DealStageChangetime. |
| DealStageId | Integer | DealStageId. |
| DealStatus | String | DealStatus. |
| DealTitle | String | DealTitle. |
| UndoneActivitiescount | Integer | UndoneActivitiescount. |
| DealUpdateTime | Datetime | DealUpdateTime. |
| DealUserId | Integer | DealUserId. |
| DealValue | Double | DealValue. |
| DealVisibleTo | String | DealVisibleTo. |
| DealWonTime | String | DealWonTime. |
| ProductActiveFlag | Boolean | ProductActiveFlag. |
| ProductAddTime | Datetime | ProductAddTime. |
| ProductCategory | String | ProductCategory. |
| ProductCode | String | ProductCode. |
| ProductCompanyId | Integer | ProductCompanyId. |
| ProductDealId | Integer | ProductDealId. |
| ProductDescription | String | ProductDescription. |
| ProductFilesCount | String | ProductFilesCount. |
| ProductFirstChar | String | ProductFirstChar. |
| ProductFollowersCount | Integer | ProductFollowersCount. |
| ProductName | String | ProductName. |
| ProductOwnerId | Integer | ProductOwnerId. |
| ProductSelectable | Boolean | ProductSelectable. |
| ProductTax | Integer | ProductTax. |
| ProductUnit | String | ProductUnit. |
| ProductUpdateTime | Datetime | ProductUpdateTime. |
| ProductVisibleTo | String | ProductVisibleTo. |