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 |
| DownloadFile | Download a file from a gist. |
| 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. |
| IsGistStarred | Checks if a gist is starred by the authenticated user. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication. |
| StarGist | Stars a gist for the authenticated user. |
| UnstarGist | Unstar a gist for the authenticated user. |