JDBC Driver for Highrise

Build 22.0.8462

GroupUsers

Query the groups created in your account and the users that are associated with the groups.

Table Specific Information

Select

Retrieve all the groups of your account and all the users in each group

SELECT * FROM GroupUsers 

You can also retrieve all users that belong to one group

SELECT * FROM GroupUsers WHERE GroupId='123'

Columns

Name Type References Description
GroupId [KEY] Integer The unique identifier of the group.
GroupName String The name of the group.
UserId [KEY] Integer Id of the user belonging to the group.
Username String Name of the user belonging to the group.
UserEmailAddress String Name of the user belonging to the group.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462