ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Box の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにBox から関連するレスポンスデータを返します。

CData SSIS Components for Box ストアドプロシージャ


Name	Description
AddMetadataTemplatestoFile	Applies an instance of a metadata template to a file.
CopyFile	Copy a File.
CopyFolder	Copy a Folder.
CreateSchema	Creates a schema file for the specified table or view.
CreateSignRequest	Create a Sign Request.
DeleteFile	Delete a File.
DownloadFile	Downloads a File.
EmptyTrash	Clear the recycle bin/trash.
GetOAuthAccessToken	Gets an authentication token from Box.
GetOAuthAuthorizationURL	Gets the authorization URL, which must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the auth token from this URL.
LockFile	Lock a file.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with Box.
RestoreItem	Restore an item from trash. In case of a folder itemType the source folder and all of its descendants will be locked for the duration of the operation.
ShareAnItem	Shares a File, Folder or Bookmark.
UnlockFile	Unlock a file.
UpdateFile	Update a File.
UploadFile	Uploads a File.
UploadFileVersion	Uploads a new version of an existing File.