Skip to main content

Service Pipelines

Written by Nick Maxwell

Data Dictionary

Field

Type

Notes

Connection Name

Text

The name of the Connection. Typically the name of the HubSpot Organisation., Derived from clean_name Connection Name

Data current as of

Datetime

Gives the date and time that this record was taken from HubSpot.

Is Closed

Boolean

Derived from text_to_boolean Is Closed

Pipeline Archived

Boolean

True if the Pipeline has been archived, Derived from text_to_boolean Pipeline Archived

Pipeline Created

Datetime

Derived from text_to_timestamptz Pipeline Created

Pipeline ID

Text

Pipeline Label

Text

Pipeline Sort Order

Integer

Pipeline Stage ID

Text

Derived from generate_hash Pipeline ID and Stage ID

Pipeline Stage Label

Text

Derived from clean_name

Pipeline Stage Sort Order

Integer

Derived from make_sort_order Pipeline Sort Order and Stage Sort Order

Pipeline Updated

Datetime

Derived from text_to_timestamptz Pipeline Updated

Stage Archived

Boolean

True if the Stage has been archived, Derived from text_to_boolean Stage Archived

Stage Created

Datetime

Derived from text_to_timestamptz Stage Created

Stage ID

Text

API: stages.id

Stage Label

Text

API: stages.label

Stage Sort Order

Integer

API: stages.displayOrder

Stage Updated

Datetime

Derived from text_to_timestamptz Stage Updated

Write Permissions

Text

API: stages.writePermissions

Did this answer your question?