Courses

Retrieve the available Courses in HubSpot.

Table Specific Information

In HubSpot, courses represent educational or training programs that can be tracked and managed. Course records support organizing educational content and tracking participant engagement.

SELECT

When selecting courses, 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 Courses WHERE [Course Name] = 'Advanced Marketing' AND [Enrollment Capacity] > 50
SELECT * FROM Courses WHERE [Pipeline] = 'Course Pipeline' OR [Course ID] = 'course-123'

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 Courses WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Courses WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}
SELECT * FROM Courses WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Courses 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 Courses ([Course Name], [Course Description], [Enrollment Capacity]) VALUES ('Digital Marketing 101', 'Introduction to digital marketing concepts', 25)

UPDATE

UPDATE Courses SET [Course Description] = 'Updated course description' WHERE ID = '67890'

DELETE

DELETE FROM Courses WHERE ID = '67890'

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.
Course Description	String	False		True	Brief explanation of what the course covers.
Course ID	String	False		True	Unique ID for the course record.
Course Name	String	False		True	Title or name of the course.
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.
Date entered 'Closed Stage (Course Pipeline)'	Datetime	True		True	The date and time when the Course entered the 'Closed Stage' stage, 'Course Pipeline' pipeline.
Date entered 'Open Stage (Course Pipeline)'	Datetime	True		True	The date and time when the Course entered the 'Open Stage' stage, 'Course Pipeline' pipeline.
Date exited 'Closed Stage (Course Pipeline)'	Datetime	True		True	The date and time when the Course exited the 'Closed Stage' stage, 'Course Pipeline' pipeline.
Date exited 'Open Stage (Course Pipeline)'	Datetime	True		True	The date and time when the Course exited the 'Open Stage' stage, 'Course Pipeline' pipeline.
Enrollment Capacity	Decimal	False		True	Maximum number of participants allowed.
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.
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 course.
Pipeline Stage	String	False		False	The pipeline stage that contains this course.
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.
Time in 'Closed Stage (Course Pipeline)'	Decimal	True		True	The total time in seconds spent by the Course in the 'Closed Stage' stage, 'Course Pipeline' pipeline.
Time in 'Open Stage (Course Pipeline)'	Decimal	True		True	The total time in seconds spent by the Course in the 'Open Stage' stage, 'Course Pipeline' pipeline.
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.
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.

Excel Add-In for HubSpot