Retrieves details about user accounts in HubSpot, including user permissions and provisioning.

View-Specific Information

SELECT

When querying UserProvisioning, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operator is =.

    SELECT * FROM UserProvisioning ;
    SELECT * FROM UserProvisioning WHERE Id = '1165089';

Columns

Name	Type	References	Filterable	Description
Id [KEY]	Long		True	Unique identifier for the user.
FirstName	String		False	First name of the user.
LastName	String		False	Last name of the user.
Email	String		True	Email address associated with the user account.
RoleId	Long	Roles.Id	False	Identifier for the role assigned to the user.
PrimaryTeamId	Long	Teams.Id	False	Identifier for the user's primary team.
SecondaryTeamIds	String		False	Comma-separated list of IDs for secondary teams the user belongs to.
IsSuperAdmin	Boolean		False	Indicates whether the user has super admin privileges.