Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component 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 SSIS Components 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. |