Pipelines

Returns all pipelines, including configuration, ordering, and deal probability settings.

Table-Specific Information

SELECT

The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.


Column	Supported Operators
Id	=

For example, the following query is processed server-side:

SELECT * FROM Pipelines WHERE Id = 1

INSERT

Execute INSERT by specifying the Name column. All columns that are not required are optional. For example:

INSERT INTO Pipelines (Name) VALUES ('Pipeline 2')

UPDATE

Execute UPDATE by specifying the Id in the WHERE clause. All columns that are not read-only can be updated. For example:

UPDATE Pipelines Set Name = 'Updated Pipeline 2' WHERE Id = 4

DELETE

Execute DELETE by specifying the Id in the WHERE clause. For example:

DELETE FROM Pipelines WHERE Id = 1

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the pipeline.
Name	String	False		The name of the pipeline.
AddTime	Datetime	True		The date and time when the pipeline was created.
IsDealProbabilityEnabled	Boolean	False		Whether deal win probability tracking is enabled for this pipeline.
IsDeleted	Boolean	True		Whether the pipeline has been deleted.
OrderNr	Integer	True		The display order number of the pipeline relative to other pipelines.
UpdateTime	Datetime	True		The date and time when the pipeline was last updated.