JDBC Driver for Pipedrive

Build 22.0.8462

PersonsProducts

Get details of Persons Products.

Select

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

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462