Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with GitHub.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from GitHub, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for GitHub Stored Procedures
| Name | Description |
| CloneTemplateRepository | Duplicates the files and structure of a template repository to create a new repository, streamlining the setup process for consistent project creation. |
| DownloadFile | Facilitates downloading specific files from a GitHub repository for offline access or local reference. |
| GetCurrentlyAuthenticatedUser | Fetches comprehensive details about the currently authenticated GitHub user, including username and account preferences. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to GitHub. |
| 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 GitHub resources without requiring reauthorization from the user. |
| UploadFile | Enables users to upload files directly to a specified GitHub repository for collaborative purposes. |