Services
Retrieve the available Services in HubSpot.
Table Specific Information
In HubSpot, services represent professional services, support offerings, or other service-based products provided to customers. Service records help users track project status, costs, and completion through pipeline stages.
SELECT
When selecting services, filtering can be applied to columns marked as "Filterable." For these columns, the only supported server-side operator is =.
SELECT * FROM Services WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42'
INSERT
INSERT INTO Services ([Name]) VALUES ('Consulting Package')
UPDATE
UPDATE Services SET [Name] = 'Updated Service Name' WHERE ID = '25151'
DELETE
DELETE FROM Services WHERE ID = '25151'
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Id [KEY] | Long | True | True |
Unique identifier of the object. | |
| Archived | Bool | True | False |
Whether the object is archived or not. | |
| CreatedAt | Datetime | True | False |
When the object was created. | |
| UpdatedAt | Datetime | True | False |
When the object was last updated. | |
| All teams | String | True | False |
The team IDs, including the team hierarchy, of all default and custom owner properties for this record. | |
| Business units | String | False | False |
The business units this record is assigned to. | |
| All owner IDs | String | True | False |
Values of all default and custom owner properties for this record. | |
| All team IDs | String | True | False |
The team IDs of all default and custom owner properties for this record. | |
| Amount paid | Decimal | False | True |
What the customer has already paid. | |
| Amount remaining | Decimal | False | True |
What the customer will pay in the future. | |
| Category | String | False | False |
A drop down or multi-select field where customers can differentiate among varied offerings i.e. Marketing hub onboarding vs. full suite onboarding, etc. | |
| Close date | Datetime | False | True |
Date the record is closed. | |
| Created by user ID | Decimal | True | True |
The user who created this record. This value is set automatically by HubSpot. | |
| Object create date/time | Datetime | True | True |
The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified. | |
| Description | String | False | True |
An explanation of the offering that is being represented. | |
| Duration | Decimal | True | True |
Calculates the time between the start date and close date. If the start date occurs after the close date, the value returned is 0. The create date and target end date will be used as fallbacks for the start date and close date respectively. | |
| Object last modified date/time | Datetime | True | True |
Most recent timestamp of any property update for this object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically. | |
| Merged record IDs | String | True | False |
The list of record IDs that have been merged into this record. This value is set automatically by HubSpot. | |
| Name | String | False | True |
Short-summary of the offering the record represents. | |
| Next activity date | Datetime | True | True |
The date of the next upcoming activity for a service. This property is set automatically by HubSpot based on user action. This includes logging a future call, sales email, or meeting using the Log feature, as well as creating a future task or scheduling a future meeting. This is updated automatically by HubSpot. | |
| Record ID | Decimal | True | True |
The unique ID for this record. This value is set automatically by HubSpot. | |
| Record creation source | String | True | True |
Raw internal PropertySource present in the RequestMeta when this record was created. | |
| Record source detail 1 | String | True | True |
First level of detail on how this record was created. | |
| Record source detail 2 | String | True | True |
Second level of detail on how this record was created. | |
| Record source detail 3 | String | True | True |
Third level of detail on how this record was created. | |
| Record creation source ID | String | True | True |
Raw internal sourceId present in the RequestMeta when this record was created. | |
| Record source | String | True | False |
How this record was created. | |
| Record creation source user ID | Decimal | True | True |
Raw internal userId present in the RequestMeta when this record was created. | |
| Owning Teams | String | False | False |
The teams that are attributed to this record. | |
| Pipeline | String | False | False |
The pipeline that contains this service. | |
| Pipeline Stage | String | False | False |
The pipeline stage that contains this service. | |
| Read only object | Bool | True | True |
Determines whether a record can be edited by a user. | |
| Shared teams | String | False | False |
Additional teams whose users can access the record based on their permissions. This can be set manually or through Workflows or APIs. | |
| Shared users | String | False | False |
Additional users that can access the record based on their permissions. This can be set manually or through Workflows and APIs. | |
| Start date | Datetime | False | True |
Date the offering starts being worked on by either the customer or the company. | |
| Status | String | False | False |
This represents how the project is tracking relative towards expectations. | |
| Service Tags | String | True | False |
List of tag ids applicable to a service. This property is set automatically by HubSpot. | |
| Tags | String | False | False |
Deal tags associated with your service. | |
| Target duration | Decimal | True | True |
Calculates the time between the start date and target date. If the start date occurs after the target date, the value returned is 0. | |
| Target end date | Datetime | False | True |
Date the offering is anticipated to be completed. | |
| Time in 'In progress (Service Pipeline)' | Decimal | True | True |
The total time in seconds spent by the service in the 'In progress' stage, 'Service Pipeline' pipeline. | |
| Time in 'New (Service Pipeline)' | Decimal | True | True |
The total time in seconds spent by the service in the 'New' stage, 'Service Pipeline' pipeline. | |
| Time in 'Closed (Service Pipeline)' | Decimal | True | True |
The total time in seconds spent by the service in the 'Closed' stage, 'Service Pipeline' pipeline. | |
| Total cost | Decimal | False | True |
The total value in US dollars of the offering. | |
| Unique creation key | String | True | True |
Unique property used for idempotent creates. | |
| Updated by user ID | Decimal | True | True |
The user who last updated this record. This value is set automatically by HubSpot. | |
| User IDs of all notification followers | String | True | False |
The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications. | |
| User IDs of all notification unfollowers | String | True | False |
The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications. | |
| User IDs of all owners | String | True | False |
The user IDs of all owners of this record. | |
| Cumulative time in New (test) | Decimal | True | True |
The cumulative time in seconds spent by the service in the 'New' stage, 'test' pipeline. | |
| Cumulative time in In progress (test) | Decimal | True | True |
The cumulative time in seconds spent by the service in the 'In progress' stage, 'test' pipeline. | |
| Cumulative time in Closed (test) | Decimal | True | True |
The cumulative time in seconds spent by the service in the 'Closed' stage, 'test' pipeline. | |
| Cumulative time in In progress (Service Pipeline) | Decimal | True | True |
The cumulative time in seconds spent by the service in the 'In progress' stage, 'Service Pipeline' pipeline. | |
| Cumulative time in New (Service Pipeline) | Decimal | True | True |
The cumulative time in seconds spent by the service in the 'New' stage, 'Service Pipeline' pipeline. | |
| Cumulative time in Closed (Service Pipeline) | Decimal | True | True |
The cumulative time in seconds spent by the service in the 'Closed' stage, 'Service Pipeline' pipeline. | |
| Date entered New (test) | Datetime | True | True |
The date and time when the service entered the 'New' stage, 'test' pipeline. | |
| Date entered In progress (test) | Datetime | True | True |
The date and time when the service entered the 'In progress' stage, 'test' pipeline. | |
| Date entered Closed (test) | Datetime | True | True |
The date and time when the service entered the 'Closed' stage, 'test' pipeline. | |
| Date entered In progress (Service Pipeline) | Datetime | True | True |
The date and time when the service entered the 'In progress' stage, 'Service Pipeline' pipeline. | |
| Date entered New (Service Pipeline) | Datetime | True | True |
The date and time when the service entered the 'New' stage, 'Service Pipeline' pipeline. | |
| Date entered Closed (Service Pipeline) | Datetime | True | True |
The date and time when the service entered the 'Closed' stage, 'Service Pipeline' pipeline. | |
| Date exited New (test) | Datetime | True | True |
The date and time when the service exited the 'New' stage, 'test' pipeline. | |
| Date exited In progress (test) | Datetime | True | True |
The date and time when the service exited the 'In progress' stage, 'test' pipeline. | |
| Date exited Closed (test) | Datetime | True | True |
The date and time when the service exited the 'Closed' stage, 'test' pipeline. | |
| Date exited In progress (Service Pipeline) | Datetime | True | True |
The date and time when the service exited the 'In progress' stage, 'Service Pipeline' pipeline. | |
| Date exited New (Service Pipeline) | Datetime | True | True |
The date and time when the service exited the 'New' stage, 'Service Pipeline' pipeline. | |
| Date exited Closed (Service Pipeline) | Datetime | True | True |
The date and time when the service exited the 'Closed' stage, 'Service Pipeline' pipeline. | |
| Latest time in New (test) | Decimal | True | True |
The total time in seconds spent by the service in the 'New' stage, 'test' pipeline since it last entered this stage. | |
| Latest time in In progress (test) | Decimal | True | True |
The total time in seconds spent by the service in the 'In progress' stage, 'test' pipeline since it last entered this stage. | |
| Latest time in Closed (test) | Decimal | True | True |
The total time in seconds spent by the service in the 'Closed' stage, 'test' pipeline since it last entered this stage. | |
| Latest time in In progress (Service Pipeline) | Decimal | True | True |
The total time in seconds spent by the service in the 'In progress' stage, 'Service Pipeline' pipeline since it last entered this stage. | |
| Latest time in New (Service Pipeline) | Decimal | True | True |
The total time in seconds spent by the service in the 'New' stage, 'Service Pipeline' pipeline since it last entered this stage. | |
| Latest time in Closed (Service Pipeline) | Decimal | True | True |
The total time in seconds spent by the service in the 'Closed' stage, 'Service Pipeline' pipeline since it last entered this stage. | |
| Performed in an import | Bool | True | True |
Object is part of an import. | |
| Owner assigned date | Datetime | True | True |
The most recent timestamp of when an owner was assigned to this record. This value is set automatically by HubSpot. | |
| Owner | String | False | True |
The owner of the object. | |
| Owner's main team | String | True | False |
The main team of the record owner. This value is set automatically by HubSpot. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.
| Name | Type | Description |
| ExternalIdColumn | String |
The name of the column to be used as the unique key in a bulk UPSERT statement. |