Retrieve the available users in HubSpot, including standard properties and any custom user properties defined in the account.

View Specific Information

SELECT

The Users view is dynamic. The driver retrieves the column list directly from HubSpot at runtime, so any custom user properties you have defined in your HubSpot account appear as additional columns.

The column names returned depend on the UseDisplayNames connection property. When UseDisplayNames is True (the default), the driver returns the human-readable display name (for example, Availability Status, Job Title). When UseDisplayNames is False, the driver returns the underlying internal property name.

When selecting users, you can filter by columns marked below as Filterable. For those columns, the supported server-side operators are =, !=, <, <=, >, >=, IN, and IS_NOT.

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 Users WHERE [Job Title] = 'Developer' AND [Last Active] > '2020-01-01'
SELECT * FROM Users WHERE [First Name] = 'John' OR [First Name] = 'William'

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

SELECT * FROM Users WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Users WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}
SELECT * FROM Users WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Users 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})

Difference Between Users, UserProvisioning, and Owners

The Users view contains details about users within a specific HubSpot account, including properties such as working hours, time zone, phone number, and job title. A user in the Users view represents a user only within the HubSpot account from which the data was requested. This differs from the users in the UserProvisioning view, which refer to users across all accounts, and the users in the Owners view, which refer to users as owners of records.

Columns