JDBC Driver for Pipedrive

Build 22.0.8462

DealsTimelineDeals

Return details of DealsTimeline deals.

Columns

Name Type Description
Id [KEY] Integer Id.
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.
LastncomingMailTime Datetime LastncomingMailTime.
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 StageId.
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
StartDate Date Date where the first interval starts. Format: YYYY-MM-DD
IntervalType String Type Of Interval.

The allowed values are day, week, month, quarter.

Amount Integer The number of given intervals, starting from start_date, to fetch E.g 3 months.
FieldKey String The date field key which deals will be retrieved from.
FilterId Integer Type Of Interval.

The allowed values are day, week, month, quarter.

ExcludeDeals Integer Whether to exclude deals list 1 or not 0.

The allowed values are 0, 1.

ConvertCurrency String 3-letter currency code of any of the supported currencies.

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