Tables
The component models the data in Box as a list of tables in a relational database that can be queried using standard SQL statements.
CData SSIS Components for Box Tables
| Name | Description |
| Bookmarks | Stores and manages bookmarks that reference web links saved within Box, allowing users to create, update, delete, and retrieve them. |
| Collaborations | Tracks collaboration settings on Box items such as files and folders, including user roles and permissions for shared access. |
| Comments | Contains user comments made on Box files and folders, supporting creation, retrieval, updates, and deletion. |
| Folders | Represents folders in Box, including their structure, contents, and metadata, with full create, update, delete, and query capabilities. |
| Groups | Manages groups of users in Box for easier collaboration and permission assignment across files and folders. |
| LegalPolicies | Stores legal hold policies created by an enterprise to preserve content for compliance or litigation purposes. |
| Memberships | Defines user memberships in groups, linking users to groups and managing their access within Box. |
| MetadataTemplates | Contains reusable metadata templates that define structured fields which can be applied to files and folders. |
| TaskAssignments | Represents assignments of tasks within Box, linking a task to the users responsible for completing it. |
| Tasks | Stores tasks created in Box for files and folders, supporting assignment, due dates, and completion tracking. |
| TrashedItems | Contains items moved to the trash, allowing users to view, query, or permanently delete trashed files and folders. |
| Users | Stores user account details in Box, supporting creation, management, and retrieval of users across the enterprise. |