Provides pipelines used for managing lead progression through various stages in HubSpot.

View-Specific Information

SELECT

When selecting LeadPipelines, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators is: =.

SELECT * FROM HubSpotV3.LeadPipelines;
SELECT * FROM HubSpotV3.LeadPipelines WHERE Id = 'lead-pipeline-id';

Columns

Name	Type	References	Filterable	Description
Id [KEY]	String		True	The unique identifier of the lead pipeline.
Label	String		False	The display name of the pipeline as shown in the HubSpot UI.
Archived	Bool		False	Indicates whether the pipeline has been archived and is no longer active.
CreatedAt	Datetime		False	The date and time when the pipeline was initially created.
UpdatedAt	Datetime		False	The date and time when the pipeline was last modified.
DisplayOrder	Int		False	The position of the pipeline within the list of pipelines, used to determine display order.
StagesAggregate	String		False	A summarized list of the stages associated with this pipeline. Detailed information is available in the LeadPipelineStages table.