ODBC Driver for Pipedrive

Build 24.0.9062

ProductsDeals

Get details of Products Deals.

Select

The 本製品 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 本製品.

  • Id supports the '=' operator.
  • Status supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM ProductsDeals WHERE Id = 10 

SELECT * FROM ProductsDeals WHERE Id = 10 AND status = 'open'

Columns

Name Type Description
Id [KEY] Integer Id.
ProductId Integer Products Id.
Active Boolean Active.
ActivitiesCount Integer ActivitiesCount.
AddTime Datetime AddTime.
CcEmail String CcEmail.
CloseTime String CloseTime.
CreatorActiveFlag Boolean CreatorActiveFlag.
CreatorEmail String CreatorEmail.
CreatorHasPic Boolean CreatorHasPic.
CreatorId Integer CreatorId.
CreatorName String CreatorName.
CreatorPicHash String CreatorPicHash.
CreatorValue Integer CreatorValue.
Currency String Currency.
Deleted Boolean Deleted.
DoneActivitiesCount Integer DoneActivitiesCount.
EmailMessagesCount Integer EmailMessagesCount.
ExpectedCloseDate String ExpectedCloseDate.
FilesCount Integer FilesCount.
FirstWonTime String FirstWonTime.
FollowersCount Integer FollowersCount.
FormattedValue String FormattedValue.
FormattedWeightedValue String FormattedWeightedValue.
Label String Label.
LastActivityDate String LastActivityDate.
LastActivityId String LastActivityId.
LastIncomingMailTime String LastIncomingMailTime.
LastOutgoingMailTime String 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.
OrgIdName String OrgId Name.
OrgIdPeopleCount Integer OrgId People count.
OrgIdOwnerId Integer OrgId Owner Id.
OrgIdAddress String OrgId Address.
OrgIdActiveFlag Boolean OrgId Active flag.
OrgIdCcEmail String OrgId CcEmail.
OrgIdValue Integer OrgId Value.
OrgName String OrgName.
OwnerName String OwnerName.
ParticipantsCount Integer ParticipantsCount.
PersonHidden Boolean PersonHidden.
PersonActiveFlag Boolean PersonActiveFlag.
PersonEmail String PersonEmail.
PersonIdName String PersonName.
PersonPhone String PersonPhone.
PersonValue Integer PersonValue.
PipelineId Integer PipelineId.
Probability String Probability.
ProductsCount Integer ProductsCount.
RottenTime String RottenTime.
StageChangeTime String StageChangeTime.
StageId Integer StageId.
StageOrderNr Integer StageOrderNr.
Status String Only fetch deals with specific status.

使用できる値は次のとおりです。open, won, lost, deleted, all_not_deleted

デフォルト値はall_not_deletedです。

Title String Title.
UndoneActivitiesCount Integer UndoneActivitiesCount.
UpdateTime Datetime UpdateTime.
UserActiveFlag Boolean UserActiveFlag.
UserEmail String UserEmail.
UserHasPic Boolean UserHasPic.
UserId Integer UserId.
UserName String UserName.
UserPicHash String UserPicHash.
Uservalue Integer Uservalue.
Value Double Value.
VisibleTo String VisibleTo.
WeightedValue Double WeightedValue.
WeightedValueCurrency String WeightedValueCurrency.
WonTime String WonTime.
PersonName String Person name.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062