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 | The user's unique ID. | |
| FirstName | String | False | The user's firstname. | |
| LastName | String | False | The user's lastname. | |
| String | True | The user's email. | ||
| RoleId | Long |
Roles.Id | False | The user's role. |
| PrimaryTeamId | Long |
Teams.Id | False | The user's primary team. |
| SecondaryTeamIds | String | False | Comma-separated list of user IDs representing secondary team members. | |
| IsSuperAdmin | Boolean | False | Boolean indicating whether the user is a super admin. |