Stages

Returns all pipeline stages, including configuration for deal probability, rotten deal detection, and stage ordering.

Table-Specific Information

SELECT

The provider uses 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 provider.


Column	Supported Operators
Id	=
PipelineId	=

For example, the following queries are processed server-side:

SELECT * FROM Stages WHERE Id = 1
SELECT * FROM Stages WHERE PipelineId = 1

INSERT

Execute INSERT by specifying the Name and PipelineId columns. You can also insert any optional columns. For example:

INSERT INTO Stages (Name, PipelineId) VALUES ('New Stage',1)

UPDATE

Execute UPDATE by specifying the Id in the WHERE clause. You can update any columns that are not read-only. For example:

UPDATE Stages SET Name = 'Updated Stage' WHERE Id = 8

DELETE

Execute DELETE 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 and time when the stage was created.
DaysToRotten	Integer	False		The number of days a deal must remain without updates in this stage before it becomes rotten.
DealProbability	Integer	False		The win probability percentage assigned to deals in this stage.
IsDealRotEnabled	Boolean	False		Whether deals in this stage can become rotten after a period of inactivity.
IsDeleted	Boolean	True		Whether the stage has been deleted.
OrderNr	Integer	True		The display order number of the stage within its pipeline.
PipelineId	Integer	False		The unique identifier of the pipeline this stage belongs to.
UpdateTime	Datetime	True		The date and time when the stage was last updated.