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