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 |
| AddCollaborator | Adds a user to a repository with a specified permission level, updating existing access if necessary. Enterprise Managed Users are added directly, while others receive an invitation. |
| CommitCompare | Compares two references (e.g., commits, branches, or tags) to highlight differences in code or repository history, aiding in change management. |
| CreateCommitOnBranch | Appends a commit to the given branch of the procedure's repository as the authenticated user. |
| DownloadFile | Enables downloading specific files from a repository, facilitating local inspection or offline use. |
| GetCurrentlyAuthenticatedUser | Retrieves details of the currently authenticated user, such as account settings and roles within the repository. |
| 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. |
| RemoveCollaborator | Removes a collaborator from a repository, revoking their access, unstarring repositories, canceling invitations, unassigning issues, denying pull requests, updating related permissions and may delete forks. |
| UpdatePullRequestBranch | Synchronizes a pull request branch with its base branch by merging or rebasing updates, ensuring consistency with the upstream repository. |
| UploadFile | Allows uploading files to a repository for storage, collaboration, or integration into the project. |