ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Microsoft Planner の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにMicrosoft Planner から関連するレスポンスデータを返します。
CData Python Connector 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). |