ストアドプロシージャ

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

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

CData ODBC Driver for Microsoft Planner ストアドプロシージャ


Name	Description
GetAdminConsentURL	Generates the URL required for an admin to grant your application access to an organization's domain. Necessary for custom OAuth configurations.
GetOAuthAccessToken	Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Microsoft Planner.
GetOAuthAuthorizationURL	Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process.
RefreshOAuthAccessToken	Refreshes an expired OAuth Access Token to maintain continuous authenticated access to Microsoft Planner resources without requiring reauthorization from the user.
UpdateAssignedToTaskBoardTaskFormat	Formats and displays tasks in the 'Assigned To' view of the Task Board, organizing them by the users responsible for each task.
UpdateBucketTaskBoardFormat	Formats and displays tasks in the 'Buckets' view of the Task Board, showing tasks grouped by their designated bucket categories.
UpdateProgressTaskBoardFormat	Formats and displays tasks in the 'Progress' view of the Task Board, arranging them by their completion status (for example, Not Started, In Progress, Complete).