Tableau Connector for Box

Build 21.0.8137

TrashedItems

Delete and query the available TrashedItems in Box.

テーブル固有の情報

TrashedItems はすでに削除されたFiles およびFolders です。このテーブルは2つの処理のみが可能です:Update およびDelete。このテーブルから削除するとFile は永久に削除され、戻すことができません。

Select

TrashedItems テーブルの特定のアイテムを検索するには、アイテムのタイプ(File、Folder、またはWEB_LINK)を指定します。

SELECT * FROM TrashedItems WHERE SearchTerms LIKE '%Untitled%' AND Type = 'file'

もしくは、1つの削除済みFolder をクエリしたい場合には、次のようなクエリを実行します:

SELECT * FROM TrashedItems WHERE Id = '123' AND Type = 'folder'

もしくは、1つの削除済みBookmark をクエリしたい場合には、次のようなクエリを実行します:

SELECT * FROM TrashedItems WHERE Id = '123' AND Type = 'web_link'

Delete

TrashedItems を削除するには、アイテムのId およびType を指定してDELETE ステートメントを発行します。

DELETE FROM TrashedItems WHERE Id = 'abc123' AND Type = 'file'

Columns

Name Type ReadOnly Description
SearchTerms String False

Query to search the trashed items database.

Id [KEY] String False

The Id of the trashed item.

Name String False

The name of the trashed item.

Type String False

The type of the item can be trashed item,folder or web_link.

Sha1 String False

The SHA-1 encryption of the trashed item.

Etag String False

The Etag of the trashed item.

SequenceId String False

The sequence Id of the trashed item.

Description String False

The description of the trashed item.

Size Integer False

The size of the trashed item.

CreatedAt Datetime False

The date the trashed item was created at.

ModifiedAt Datetime False

The date the trashed item was modified at.

TrashedAt Datetime False

The date the trashed item was trashed at.

PurgedAt Datetime False

The date the trashed item was purged at.

ContentCreatedAt Datetime False

The date the content of the trashed item was created at.

ContentModifiedAt Datetime False

The date the content of the trashed item was modified at.

CreatedById String False

The Id of the user that created the trashed item.

CreatedByName String False

The Name of the user that created the trashed item..

CreatedByLogin String False

The Login of the user that created the trashed item..

SharedLink String False

The shared link of the user that created the trashed item.

ModifiedBy String False

The Id of the user that last modified the trashed item.

ModifiedByName String False

The Name of the user that last modified the trashed item..

ModifiedByLogin String False

The Login of the user that last modified the trashed item..

OwnedById String False

The Id of the user that owns the trashed item.

OwnedByName String False

The Name of the user that owns the trashed item..

OwnedByLogin String False

The Login of the user that owns the trashed item..

ParentId String False

The Id of the folder that contains the trashed item.

ItemStatus String False

The status of the trashed item.

Pseudo-Columns

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

Name Type Description
Scope String

The scope of the search.

FileExtension String

The extension of the trashed item.

SearchContent String

The content to search the query at, separated by commas.

AsUserId String

The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137