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 |
| CloneTemplateRepository | Duplicates the files and structure of a template repository to create a new repository, streamlining the setup process for consistent project creation. |
| DeleteRepository | Delete a repository from GitHub. |
| 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. |
| MergePullRequest | Automates the merging of an open pull request into the target branch, integrating proposed changes into the main codebase. |
| 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. |