Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Microsoft Planner.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Microsoft Planner, along with an indication of whether the procedure succeeded or failed.
CData JDBC Driver for Microsoft Planner Stored Procedures
| 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). |