Skip to main content

Services

Written by Nick Maxwell

Data Dictionary

Field

Type

Notes

Amount Paid

Number

API: Properties.hs_amount_paid

Amount Remaining

Number

API: Properties.hs_amount_remaining

Archived

Boolean

Derived from text_to_boolean Archived

Associated Companies

JSON

A JSON array that holds the Company ID and Association Type of any Companies associated with this record.

Associated Contacts

JSON

A JSON array that holds the Contact ID and Association Type of any Contacts associated with this record.

Category

Text

API: Properties.hs_category

Close Date

Datetime

Derived from text_to_timestamptz Properties.hs_close_date

Company Name

Text

API: properties.name

Connection Name

Text

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

Contact Name

Text

This is derived from the Firstname and Lastname, Derived from concat First Name and Last Name

Created

Datetime

Derived from text_to_timestamptz Service.createdAt

Created By

Integer

The Owner ID of the person that created the record. Find related details in the Owners table., Derived from text_to_owner_id Properties.hs_created_by_user_id

Created Date

Date

The date that the record was created. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on., Derived from timestamptz_as_text_to_date Service.createdAt

Custom Properties

JSON

Derived from handle_null_json Service.custom_properties

Data current as of

Datetime

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

Description

Text

API: Properties.hs_description

Internal URL

Text

The URL to the Service record - only available to those that have access to HubSpot., API: Service.url

Next Activity Date

Datetime

Derived from text_to_timestamptz Properties.hs_next_activity_date

Object Source

Text

API: Properties.hs_object_source

Object Source Detail 1

Text

API: Properties.hs_object_source_detail_1

Object Source Detail 2

Text

API: Properties.hs_object_source_detail_2

Object Source Detail 3

Text

API: Properties.hs_object_source_detail_3

Owner Assigned Date

Datetime

Hubspot Owner Assigned Date, Derived from text_to_timestamptz Properties.hubspot_owner_assigneddate

Owner ID

Integer

The Owner of the Service. Find related details in the Owners table., Derived from text_to_bigint Properties.hubspot_owner_id

Owner Name

Text

Derived from concat First Name and Last Name

Pipeline ID

Text

API: Properties.hs_pipeline

Pipeline Stage ID

Text

Derived from generate_hash Properties.hs_pipeline and Properties.hs_pipeline_stage

Primary Company ID

Integer

If one exists, the Company ID for the primary Company associated with this record. Find related details in the Companies table., Derived from first_id Associated Companies

Primary Contact ID

Integer

If one exists, the Contact ID for the primary Contact associated with this record. There may not be any associated Contact. Find related details in the Contacts table., Derived from first_id Associated Contacts

Service ID

Integer

HubSpot's unique ID for the Service., Derived from text_to_bigint Service ID

Service Name

Text

API: Properties.hs_name

Service Status

Text

API: Properties.hs_status

Stage ID

Text

API: Properties.hs_pipeline_stage

Start Date

Datetime

Derived from text_to_timestamptz Start Date

Tag IDs

Text

API: Properties.hs_tag_ids

Tags

Text

API: Properties.hs_tags

Target Duration

Interval

Derived from text_milliseconds_to_interval Properties.hs_target_duration

Target End Date

Datetime

Derived from text_to_timestamptz Properties.hs_target_end_date

Team ID

Text

API: Properties.hubspot_team_id

Total Cost

Number

API: Properties.hs_total_cost

Updated

Datetime

Derived from text_to_timestamptz Service.updatedAt

Updated By

Integer

Derived from text_to_owner_id Properties.hs_updated_by_user_id

Updated Date

Date

The date that the record was updated. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on., Derived from timestamptz_as_text_to_date Service.updatedAt

Did this answer your question?