JDBC Driver for Highrise

Build 24.0.9060

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060