JDBC Driver for Pipedrive

Build 22.0.8462

DealsParticipants

Get details of deals participants.

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.

  • Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsParticipants WHERE Id = 9 

INSERT

Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO DealsParticipants (Id,Personid) VALUES (4,6) 

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM DealsParticipants WHERE id = 14 AND ItemDealId = 17

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Id.

ActiveFlag Boolean True

ActiveFlag.

AddTime Datetime True

AddTime.

AddedByactiveFlag Boolean True

AddedByactiveFlag.

AddedByemail String True

AddedByemail.

AddedByhasPic Integer True

AddedByhasPic.

AddedByid Integer True

AddedByid.

AddedByname String True

AddedByname.

AddedBypicHash String True

AddedBypicHash.

AddedByvalue Integer True

Added_byvalue.

PersonActiveFlag Boolean True

PersonActiveFlag.

ActivitiesCount Integer True

ActivitiesCount.

PersonAddTime Datetime True

AddTime.

CcEmail String True

CcEmail.

ClosedDealsCount Integer True

ClosedDealsCount.

CompanyId Integer True

CompanyId.

DoneActivitiesCount Integer True

DoneActivitiesCount.

Email String True

Email.

EmailMessagesCount Integer True

EmailMessagesCount.

FilesCount Integer True

FilesCount.

FirstChar String True

FirstChar.

FirstName String True

FirstName.

FollowersCount Integer True

FollowersCount.

Personlabel String True

Personlabel.

LastActivityDate Date True

LastActivityDate.

LastActivityId Integer True

LastActivityId.

LastincomingMailTime String True

LastincomingMailTime.

Lastname String True

Lastname.

LastoutgoingMailTime String True

LastoutgoingMailTime.

LostdealsCount Integer True

LostdealsCount.

Name String True

Name.

NextActivityDate Date True

nextActivityDate.

NextActivityId Integer True

nextActivityId.

NextActivityTime String True

nextActivityTime.

NotesCount Integer True

NotesCount.

OpenDealsCount Integer True

OpenDealsCount.

OrgActiveFlag Boolean True

OrgActiveFlag.

OrgAddress String True

OrgAddress.

OrgCcEmail String True

OrgCcEmail.

OrgName String True

OrgName.

OrgownerId Integer True

OrgownerId.

OrgpeopleCount Integer True

OrgpeopleCount.

OrgId Integer True

OrgId.

OwnerActiveFlag Boolean True

OwnerActiveFlag.

OwnerEmail String True

OwnerEmail.

OwnerHasPic Integer True

OwnerHasPic.

OwnerId Integer True

OwnerId.

OwnerName String True

OwnerName.

OwnerPicHash String True

OwnerPicHash.

OwnerValue Integer True

OwnerValue.

ParticipantClosedDealsCount Integer True

ClosedDealsCount.

ParticipantOpenDealsCount Integer True

OpenDealsCount.

Phone String True

Phone.

PictureId String True

PictureId.

RelatedclosedDealsCount Integer True

RelatedclosedDealsCount.

RelatedlostDealsCount Integer True

RelatedlostDealsCount.

RelatedopenDealsCount Integer True

RelatedopenDealsCount.

RelatedwonDealsCount Integer True

RelatedwonDealsCount.

SyncNeeded Boolean True

SyncNeeded.

UndoneActivitiesCount Integer True

UndoneActivitiesCount.

UpdateTime Datetime True

UpdateTime.

VisibleTo String True

visibleTo.

WonDealsCount Integer True

WonDealsCount.

PersonIdActiveFlag Boolean True

PersonactiveFlag.

Personemail String True

Personemail.

Personname String True

Personname.

Personphone String True

Personphone.

PersonValues Integer False

PersonValues.

ItemDealId Integer True

ItemDealId.

ItemTitle String True

ItemTitle.

ItemId Integer True

ItemId.

ItemType String True

ItemType.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PersonId Integer

Person Id.

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