Services

Retrieve the available Services in HubSpot.

Table Specific Information

In HubSpot, services represent professional offerings, support packages, or other service-related activities that can be tracked and managed. Service records support customer success, professional services, and ongoing engagement tracking.

SELECT

When selecting services, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are: =, !=, <, <=, >, >=, IN

Further filtering is available using AND and OR combinations. A maximum of 3 OR operators are supported server-side, with each of these operators supporting up to 3 AND operators inside of them. For example:

SELECT * FROM Services WHERE [Total Cost] > 5000 AND [Status] = 'In Progress'
SELECT * FROM Services WHERE [Category] = 'Consulting' OR [Name] = 'Premium Support'

In the below server-offloading examples, "{Column}" represents any column you'd like to filter and "{Value}" represents any value you want to filter it on:

SELECT * FROM Services WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Services WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}
SELECT * FROM Services WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Services WHERE ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}) OR ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}) OR ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value})

INSERT

INSERT INTO Services ([Name], [Description], [Total Cost]) VALUES ('Website Maintenance', 'Monthly website maintenance and updates', 1200)

UPDATE

UPDATE Services SET [Status] = 'Completed' WHERE ID = '22222'

DELETE

DELETE FROM Services WHERE ID = '22222'

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, such as Marketing hub onboarding and full suite onboarding.
Close date	Datetime	False		True	Date the record is
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.

CData Python Connector for HubSpot