The server enables access to metadata for Box tables and folders, as well as related entities such as Users, Tasks, and Groups.

Tables

The server models Box entities, such as Files, Folders, and Users as relational Tables.

Views

Views are read-only tables that model Box entities such as FileVersions and UserEvents.

Stored Procedures

Stored Procedures are function-like interfaces to Box. They can be used to perform tasks such as downloading, uploading, and copying files.

Limit and Offset Handling

If specified in the Statement, the driver will try to push the Limit and Offset Clauses to the server where possible. The maxiumum supported Value for Limit is 1000. Note: Some tables do not offer support for Limit and Offset clauses. For these tables and when hitting the global search endpoint, Limit and Offset clauses will be evaluated client-side.

Dynamic Collection Views

You can use ExposeCollectionViews to expose your Box collections as separate views and query the metadata information of their files and folders. The name of the generated views are prefixed with "Collection_". Additionally, AsUserId can be used to expose the collections of only a certain user and IncludeCustomFields can be used to expose custom metadata fields as columns on these views.