Collection_MyFavorites
Each Collection_* view exposes the files and folders that belong to a specific Box collection, and this schema documents the columns common to all of them.
Table Specific Information
When ExposeCollectionViews is set to true, a view prefixed with Collection_ is generated for each of your Box collections, and each view exposes the metadata of the files and folders that belong to that collection using this common schema.
Select
Query the files and folders in a specific collection by selecting from its generated view.
SELECT * FROM Collection_MyFavorites;
To expose collection-specific custom metadata fields as additional columns on the generated views, set IncludeCustomFields to true. You can also use AsUserId to expose the collections of a specific user.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier assigned to the item in the collection. | |
| Name | String | The display name of the item. | |
| Etag | String | Version identifier for the item, used to track changes and manage concurrency. | |
| SequenceId | String | An incremental identifier representing the version sequence of the item. | |
| Description | String | A user-provided description that explains the item's purpose or contents. | |
| Size | Long | The item size in bytes. | |
| CreatedAt | Datetime | The date and time when the item was originally created in Box. | |
| ContentCreatedAt | Datetime | The date and time when the item content was first created, which may differ from the Box creation date. | |
| CreatedById | String |
Users.Id | Identifier of the user who created the item. |
| CreatedByName | String | The full name of the user who created the item. | |
| CreatedByLogin | String | The login email of the user who created the item. | |
| SharedLink | String | A shareable URL that provides access to the item. | |
| ModifiedAt | Datetime | The date and time when the item was last updated in Box. | |
| ContentModifiedAt | Datetime | The date and time when the item content itself was last modified. | |
| ModifiedById | String |
Users.Id | Identifier of the user who most recently modified the item. |
| ModifiedByName | String | The full name of the user who most recently modified the item. | |
| ModifiedByLogin | String | The login email of the user who most recently modified the item. | |
| OwnedById | String |
Users.Id | Identifier of the user who owns the item. |
| OwnedByName | String | The full name of the user who owns the item. | |
| OwnedByLogin | String | The login email of the user who owns the item. | |
| ParentId | String |
Folders.Id | Identifier of the folder that contains the item. |
| ItemStatus | String | The current state of the item, such as active or trashed. | |
| TrashedAt | Datetime | The date and time when the item was moved to the trash. | |
| PurgedAt | Datetime | The date and time when the item is scheduled to be permanently deleted from the trash. | |
| Path | String | The tree of folders that contains the item, starting at the root. | |
| Type | String | The type of the item, which is always file, folder, or web_link. | |
| AsUserId | String | Identifier of the user to impersonate for API requests, available only for Admin, Co-Admin, and Service Accounts. | |
| SearchRootId | String | Identifier of the folder to use as the starting point for recursive searches, with '0' representing the root folder. |