SSIS Components for Box

Build 23.0.8839

SharedItems

Query the available shared items in Box.

テーブル固有の情報

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

Select

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.

Columns

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.

Pseudo-Columns

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

Name Type Description
SharedLink String The shared link to query.
SharedLinkPassword String The password of shared link.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839