ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Microsoft OneDrive の単純なSELECT 処理にとどまらずconnector の機能を拡張します。

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

CData Tableau Connector for Microsoft OneDrive ストアドプロシージャ


Name	Description
CopyResource	Copies a specified file or folder from one location in OneDrive to another, preserving content and structure.
CreateFolder	Creates a new folder at a specified path within OneDrive to organize content.
CreateSubscription	Registers a webhook subscription to receive notifications for changes to OneDrive content (for example, file updates).
DeleteResource	Permanently deletes a specified file or folder from OneDrive, removing it from all views and history.
DeleteSubscription	Removes an existing webhook subscription to stop receiving change notifications from OneDrive.
DownloadFile	Retrieves and downloads a specified file from OneDrive storage to the local or application context.
FetchAdditionalUserFields	Retrieves tiered metadata fields (T1, T2, T3) for a specific user, typically for profiling or auditing.
GetAdminConsentURL	Generates a URL that an admin must visit to grant tenant-wide OAuth permissions to your app; used when setting up enterprise integrations.
GetOAuthAccessToken	Gets an authentication token from OneDrive.
GetOAuthAuthorizationURL	Gets the authorization URL that 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.
ModifySubscription	Creates or updates a webhook subscription to listen for changes in OneDrive files, folders, or other resources.
MoveResource	Relocates a file or folder within the OneDrive directory structure, maintaining metadata and permissions.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with various Office 365 services.
RenameResource	Changes the name of a specified file or folder in OneDrive without affecting its contents or location.
UploadFile	Uploads a new file or overwrites an existing one in OneDrive, supporting binary content updates.