Pipelines

[DEPRICATED endpoint, use Pipelines in PipedriveV2 instead.] Returns all sales pipelines, including their names, ordering, deal probability settings, and active status.

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 = 4

INSERT

Execute INSERT by specifying the Name, Active, DealProbability, OrderNr, and UrlTitle columns. You can also insert any columns that are not required. For example:

INSERT INTO PipeLines (Name, Active, DealProbability, OrderNr, UrlTitle) VALUES ('Indias PipeLines for Pipedrive', 'true', '0', 1, 'indiapipedrivepipeline@com')

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 = 'Updating Pipedrive Pipelines1' WHERE Id = 4

DELETE

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

DELETE FROM PipeLines WHERE Id = 5

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		ID of the pipeline.
Name	String	False		The name of the Pipeline.
Active	Boolean	False		Whether this Pipeline will be made inactive (hidden) or active.
DealProbability	Integer	False		Whether Deal probability is disabled or enabled for this Pipeline. The allowed values are 0, 1.
OrderNr	Integer	False		Defines the order of Pipelines. The default value is 0.
Selected	Boolean	True		Indicates whether this pipeline is currently selected as the default view.
UpdateTime	Datetime	True		Date and time when the pipeline was last updated.
AddTime	Datetime	True		Date and time when the pipeline was created.
UrlTitle	String	True		URL-friendly slug version of the pipeline name, used in web addresses.