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 |
| CommitCompare | Compares two commits against one another. You can compare references (branches or tags) and commit SHAs in the same repository, or you can compare references and commit SHAs that exist in different repositories within the same repository network, including fork branches. |
| DownloadFile | Download a file from a given repository. |
| GetCurrentlyAuthenticatedUser | Retrieves information about the currently authenticated user. |
| GetOAuthAccessToken | Gets the OAuth access token from GitHub. |
| GetOAuthAuthorizationURL | Gets the GitHub authorization URL. Access the URL returned in the output in a Web browser. This requests the access token that can be used as part of the connection string to GitHub. |
| MergePullRequest | Merge a pull request. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication. |
| UpdatePullRequestBranch | Merge or Rebase HEAD from upstream branch into pull request branch. |
| UploadFile | Upload a file to a repository. |