JDBC Driver for Pipedrive

Build 22.0.8462

PipelineDeals

Lists deals in a specific pipeline across all its stages.

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 PipelineDeals WHERE Id = 4

Columns

Name Type Description
Id [KEY] Integer ID of the pipeline.
Active Boolean Active.
ActivitiesCount Integer ActivitiesCount.
AddTime Datetime AddTime.
CcEmail String CcEmail.
CloseTime String CloseTime.
CreatorUserId Integer CreatorUserId.
Currency String Currency.
Deleted Boolean Deleted.
DoneActivitiesCount Integer DoneActivitiesCount.
EmailMessagesCount Integer EmailMessagesCount.
ExpectedCloseDate Date ExpectedCloseDate.
FilesCount Integer FilesCount.
FirstWonTime Datetime FirstWonTime.
FollowersCount Integer FollowersCount.
FormattedValue String FormattedValue.
FormattedWeightedValue String FormattedWeightedValue.
Label String Label.
LastActivityDate String LastActivityDate.
LastActivityId String LastActivityId.
LastIncomingMailTime Datetime LastIncomingMailTime.
LastOutgoingMailTime Datetime LastOutgoingMailTime.
LostReason String LostReason.
LostTime String LostTime.
NextActivityDate Date NextActivityDate.
NextActivityDuration Time NextActivityDuration.
NextActivityId Integer NextActivityId.
NextActivityNote String NextActivityNote.
NextActivitySubject String NextActivitySubject.
NextActivityTime Time NextActivityTime.
NextActivityType String NextActivityType.
NotesCount Integer NotesCount.
OrgHidden Boolean OrgHidden.
OrgId Integer OrgId.
OrgName String OrgName.
OwnerName String OwnerName.
ParticipantsCount Integer ParticipantsCount.
PersonHidden Boolean PersonHidden.
PersonId Integer PersonId.
PersonName String PersonName.
PipelineId Integer PipelineId.
Probability String Probability.
ProductsCount Integer ProductsCount.
RottenTime String RottenTime.
StageChangeTime Datetime StageChangeTime.
StageId Integer If supplied, only deals within the given stage will be returned.
StageOrderNr Integer StageOrderNr.
Status String Status.
Title String Title.
UndoneActivitiesCount Integer UndoneActivitiesCount.
UpdateTime Datetime UpdateTime.
UserId Integer UserId.
Value Integer Value.
VisibleTo String VisibleTo.
WeightedValue Integer WeightedValue.
WeightedValueCurrency String WeightedValueCurrency.
WonTime Datetime WonTime.

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
FilterId Integer If supplied, only deals matching the given filter will be returned.

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