ODBC Driver for Pipedrive

Build 24.0.9111

Deals

Get all 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.
  • OwnerId supports the '=' operator.
  • PersonId supports the '=' operator.
  • OrgId supports the '=' operator.
  • StageId supports the '=' operator.
  • PipelineId supports the '=' operator.
  • Status supports the '=' operator.
  • FilterId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Deals WHERE Id = 14

SELECT * FROM Deals WHERE StageId = 1

SELECT * FROM Deals WHERE Status = 'Open'

SELECT * FROM Deals WHERE FilterId = 1                    

INSERT

Insert can be executed by specifying the Title columns.The columns that are not read-only can be inserted. Following is an example of how to insert into this table.

INSERT INTO Deals (Title, Currency, StageId, LabelIds) VALUES ('title', 'USD', 1, '[76, 86]')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Deals SET Title = 'test' WHERE Id = 2

DELETE

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

DELETE Deals WHERE Id = 105

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

Deals id.

Title String False

Title.

CreatorUserId Integer True

Creator User Id.

OwnerId Integer False

Owner Id.

Value Double False

Value of the deal.

PersonId Integer False

Person Id.

OrgId Integer False

Org Id.

StageId Integer False

Stage Id.

PipelineId Integer False

Pipeline Id.

Currency String False

Currency.

AddTime Datetime False

Add Time.

UpdateTime Datetime False

Update Time.

StageChangeTime Datetime False

Stage Change Time.

Status String False

Status.

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

IsDeleted Boolean False

Is Deleted.

Probability Double False

Probability.

LostReason String False

Lost Reason.

VisibleTo Integer False

Visible To.

CloseTime Datetime False

Close Time.

WonTime Datetime False

Won Time.

LostTime Datetime False

Lost Time.

LocalWonDate Date True

Local Won Date.

LocalLostDate Date True

Local Lost Date.

LocalCloseDate Date True

Local Close Date.

ExpectedCloseDate Date False

Expected Close Date.

LabelIds String False

Label Ids.

Origin String True

Origin.

OriginId String True

Origin Id.

Channel Integer True

Channel.

ChannelId String True

Channel Id.

Acv Integer True

Acv.

Arr Integer True

Arr.

Mrr Integer True

Mrr.

NextActivityId Integer True

Next Activity Id.

LastActivityId Integer True

Last Activity Id.

FirstWonTime Datetime True

First Won Time.

ProductsCount Integer True

Last Activity Id.

FilesCount Integer True

Products Count.

NotesCount Integer True

Notes Count.

FollowersCount Integer True

Followers Count.

EmailMessagesCount Integer True

Email Messages Count.

ActivitiesCount Integer True

Activities Count.

DoneActivitiesCount Integer True

Done Activities Count.

UndoneActivitiesCount Integer True

Undone Activities Count.

ParticipantsCount Integer True

Participants Count.

LastIncomingMailTime Datetime True

Last Incoming Mail Time.

LastOutgoingMailTime Datetime True

Last Outgoing Mail Time.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
FilterId Integer

Filter Id

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