Retrieves the IDs of all the objects associated to specific Courses objects in HubSpot.

Table-Specific Information

The CourseAssociations table provides access to the relationship data between course records and other HubSpot objects such as contacts, companies, deals, and tickets.

SELECT

When selecting course associations, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operators are = and, for the ID column, IN.

SELECT * FROM CourseAssociations WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42'
SELECT * FROM CourseAssociations WHERE Type = 'contacts'

Filtering by multiple ID values with IN, combined with Type, retrieves associations for up to 1,000 courses in a single batched request instead of one request per ID. The connector splits IN lists larger than 1,000 values into additional batched requests automatically.

SELECT * FROM CourseAssociations WHERE ID IN ('96ec8565-3b73-4ee8-9815-f90566ba9c42', '3fa85f64-5717-4562-b3fc-2c963f66afa6') AND Type = 'contacts'

INSERT

INSERT statements use the format:

INSERT INTO CourseAssociations (ID, AssociationId, Type) VALUES ('25151', '12345', 'contacts')

DELETE

DELETE statements use the format:

DELETE FROM CourseAssociations WHERE ID = '25151' AND AssociationId = '12345'

Columns

Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	False	Courses.Id	False	Courses ID.
AssociationId [KEY]	Long	False		False	ID of the object that this Courses object is associated with.
Type [KEY]	String	False		False	Type of the associated object, which can be a contact, deal etc.
TypeId [KEY]	String	False		False	The numeric ID for the association type. This column is empty for more general associations queries.
Category [KEY]	String	False		False	The category of the association type for the specified object pair. This column is empty for more generic associations queries.
TypeLabel	String	True		False	The label assigned to the association type between objects.