Returns a list of owners in HubSpot used to assign CRM records to specific users within the organization.

View-Specific Information

SELECT

When selecting Owners, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators is: =.

SELECT * FROM Owners;
SELECT * FROM Owners WHERE Id = 354112170;

Columns

Name	Type	References	Filterable	Description
Id [KEY]	Long		True	Unique identifier of the owner record in HubSpot.
FirstName	String		False	First name of the user who owns CRM objects such as contacts, deals, or companies.
LastName	String		False	Last name of the user who owns CRM objects such as contacts, deals, or companies.
UserId	String		False	Internal HubSpot user ID associated with the owner.
Email	String		True	Primary email address of the owner, used for notifications and assignments.
Teams	String		False	Comma-separated list of team names or IDs that the owner is a member of.
CreatedAt	Datetime		False	Timestamp of when the owner record was first created in HubSpot.
UpdatedAt	Datetime		False	Timestamp of the most recent update to the owner record.
Archived	Bool		False	Indicates whether the owner record has been archived (soft-deleted) in HubSpot.