SharedItems

Query the available shared items in Box.

テーブル固有の情報

Shared Items は、URL を使って外部からビューが公開されているFile です。これらのFile はパスワードで保護することが可能です。このURL へのアクセスとパスワードを保有する人は誰でも、このFile を読み/書きできます。

SharedItems のSelect には、アイテムを指し示すSharedLink を指定します。

SELECT * FROM SharedItems WHERE SharedLink = 'www.url.com'

SharedItem にパスワードがある場合には、パスワードも指定する必要があります。

SELECT * FROM SharedItems WHERE SharedLink = 'www.url.com' AND SharedLinkPassword = 'password'

If you're authenticated as an administrator with user impersonation permissions, you can query shared items from multiple user accounts:

SELECT * FROM SharedItems WHERE AsUserId IN (SELECT Id FROM Users)

Note: User impersonation has the following limitations:

The authenticated user cannot be impersonated unless that user is a service account.
If the authenticated user is a standard user account, they can only query shared items associated with their account.
Shared items shared with multiple users are only returned for one of the users.


Name	Type	Description
Name	String	The name of the shared item.
ItemId [KEY]	String	The Id of the shared item.
ItemType	String	The item type that the shared item points to.
CreatedAt	String	The date the shared item was created at.
Description	String	The description of the of the shared item.
ModifiedAt	String	The date the shared item was modified at.
OwnedById	String	The id of owner of the shared item.
OwnedByName	String	The name of owner of the shared item.
OwnedByLogin	String	The login of owner of the shared item.
ParentId	String	The id of the parent of the shared item.
ParentName	String	The Name of the parent of the shared item.
Access	String	The availability of the shared item.
DownloadCount	Integer	The number of times the item was downloaded
DownloadUrl	String	The url to download the item from.
IsPasswordEnabled	String	If you need to specify a password to download the file or not.
CanDownload	Boolean	If the item is available to download or not.
CanPreview	Boolean	If the item is available to preview or not.
PreviewCount	Integer	The number of times the item was previewed.
Url	String	The preview url of the item.
Size	Long	The size of the item.
AsUserId	String	The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。