Deals

Get all deals.

Select

The add-in 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 add-in.

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. The allowed values are 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

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	Filter Id