Groups
Return a collection of groups. For a more readable representation of a group's users, specify the GroupId field when selecting from the Users table. To change group memberships, see the Memberships table.
Table Specific Information
Select
Retrieve the list of groups created in your Highrise account.
SELECT * FROM Groups
Insert
Create a new group by providing its name.
INSERT INTO Groups (Name) VALUES ('ABC123')
Update
Modify a group's name by providing the group's Id
UPDATE Groups SET Name = 'ABC' WHERE Id = '123'
Delete
Delete a group by providing the group's Id
DELETE FROM Groups WHERE Id = '123'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the group. | |
| Name | String | False |
The name of the group. | |
| Users | String | True |
An aggregate of the users that belong to the group. |