Data Model
The connector enables access to metadata for Box tables and folders, as well as related entities such as Users, Tasks, and Groups.
Tables
The connector 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.
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.