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 |