LeadPipelines
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. |