Stages
Get all stages data.
Select
The server 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 server.
- Id supports the '=' operator.
- PipelineId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM Stages WHERE Id = 1 SELECT * FROM Stages WHERE PipelineId = 1
INSERT
Insert can be executed by specifying the Name and PipelineId columns. The columns that are not required can be inserted optionally.
Insert into Stages (Name, PipelineId) values ('New Stage',1)
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 Stages set Name = 'Updated Stage' where id=8
DELETE
Delete can be executed by specifying the Id in the WHERE Clause.
For example:
DELETE FROM Stages where id=8
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the stage. | |
| Name | String | False |
The name of the stage. | |
| AddTime | Datetime | True |
The date-time in which the stage was added. | |
| DaysToRotten | Integer | False |
The number of days the deals not updated in this stage would become rotten. | |
| DealProbability | Integer | False |
The success probability percentage of the deal. | |
| IsDealRotEnabled | Boolean | False |
Whether deals in this stage can become rotten | |
| IsDeleted | Boolean | True |
Whether the deal is deleted. | |
| OrderNr | Integer | True |
The order number corresponding the the stage | |
| PipelineId | Integer | False |
The pipeline id of the the stage | |
| UpdateTime | Datetime | True |
The date-time in which the stage was updated. |