UserProvisioning
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. | |
| 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. |