Retrieve user information such as working hours, time zone, additional phone numbers, and job title.

View Specific Information

User Object

SELECT

When querying Users, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operators are = != IN.

    SELECT * FROM Users;
    SELECT * FROM Users WHERE Id = '46193633729';
	SELECT * FROM Users WHERE JobTitle = 'Developer';
    SELECT * FROM Users WHERE AvailabilityStatus = 'away';
    SELECT * FROM Users WHERE AdditionalPhone = '+13123456789';
    SELECT * FROM Users WHERE StandardTimeZone = 'America/New_York';

Difference Between Users, UserProvisioning, and Owners.

The Users table 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 table represents a user only within the HubSpot account from which the data was requested. This differs from the users in the UserProvisioning table, which refer to users across all accounts, and the users in the Owners table, which refer to users as owners of records.

Columns