JDBC Driver for Box

Build 22.0.8462


Create, update, delete, and query the available Groups in Box.

Table Specific Information


You can retrieve all the Groups or filter them by Id.



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'


Name Type ReadOnly Description
ID [KEY] String True

The Id of the group.

Name String False

The name of the group.

Provenance String False

Typically used to track the external source where the group is coming from.

ExternalSyncIdentifier String False

Typically used as a group identifier for groups coming from an external source.

Description String False

The description of the group.

InvitabilityLevel String False

Specifies who can invite this group to folders.

MemberViewabilityLevel String False

Specifies who can view the members of this group.

CreatedAt Datetime True

The date the group was created at, you need to specify an Id to recieve this column.

ModifiedAt Datetime True

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.

Name Type Description
AsUserId String

The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.

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