JDBC Driver for Pipedrive

Build 22.0.8462

OrganizationsPersons

Get details of organizations persons

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.

  • OrgId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationsPersons WHERE OrgId = 10 

Columns

Name Type Description
Id [KEY] Integer Id
ActivitiesCount Integer ActivitiesCount
ActiveFlag Boolean ActiveFlag
AddTime Datetime AddTime
CcEmail String CcEmail
ClosedDealsCount Integer ClosedDealsCount
CompanyId Integer CompanyId
DoneActivitiesCount Integer DoneActivitiesCount
Email String Email
EmailMessagesCount Integer EmailMessagesCount
FilesCount Integer FilesCount
Label Integer label
LastActivityDate Date LastActivityDate
LastActivityId Integer LastActivityId
LastincomingMailTime String LastincomingMailTime
Lastname String Lastname
LastoutgoingMailTime String LastoutgoingMailTime
LostdealsCount Integer LostdealsCount
Name String Name
NextActivityDate Date nextActivityDate
NextActivityId Integer nextActivityId
NextActivityTime String nextActivityTime
NotesCount Integer NotesCount
OpenDealsCount Integer OpenDealsCount
OrgActiveFlag Boolean OrgActiveFlag
OrgAddress String OrgAddress
OrgCcEmail String OrgCcEmail
OrgName String OrgName
OrgownerId Integer OrgownerId
OrgpeopleCount Integer OrgpeopleCount
OrgId Integer OrgId
OwnerActiveFlag Boolean OwnerActiveFlag
OwnerEmail String OwnerEmail
OwnerHasPic Boolean OwnerHasPic
OwnerId Integer OwnerId
OwnerName String OwnerName
OwnerPicHash String OwnerPicHash
OwnerValue Integer OwnerValue
ParticipantClosedDealsCount Integer ParticipantClosedDealsCount
ParticipantOpenDealsCount Integer ParticipantOpenDealsCount
Phone String Phone
PictureActiveFlag Boolean PictureActiveFlag
PictureaddTime Datetime PictureaddTime
PictureaddedByUserId Integer PictureaddedByUserId
PictureItemId Integer PictureItemId
PictureitemType String PictureitemType
Picture128 String Picture128
Picture512 String Picture512
PictureupdateTime String PictureupdateTime
Picturevalue Integer Picturevalue
PictureId String PictureId
RelatedclosedDealsCount Integer RelatedclosedDealsCount
RelatedlostDealsCount Integer RelatedlostDealsCount
RelatedopenDealsCount Integer RelatedopenDealsCount
RelatedwonDealsCount Integer RelatedwonDealsCount
UndoneActivitiesCount Integer UndoneActivitiesCount
UpdateTime Datetime UpdateTime
VisibleTo String visibleTo
WonDealsCount Integer WonDealsCount

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