Create, update, delete, and query the available Groups in Box.
Table Specific Information
You can retrieve all the Groups or filter them by Id.
SELECT * FROM Groups
Only the Name column is required to create a Group.
INSERT INTO Groups(Name, Provenance, MemberViewabilityLevel) VALUES('new group', 'google', 'admins_only')
Any column where ReadOnly=False can be updated.
UPDATE Groups SET InvitabilityLevel='admins_and_members' WHERE Id = '111'
Groups can be deleted by providing an Id and issuing a DELETE statement.
DELETE FROM Groups WHERE Id = '111'
The Id of the group.
The name of the group.
Typically used to track the external source where the group is coming from.
Typically used as a group identifier for groups coming from an external source.
The description of the group.
Specifies who can invite this group to folders.
Specifies who can view the members of this group.
The date the group was created at, you need to specify an Id to recieve this column.
The date the group was modified at, you need to specify an Id to recieve this column.
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.