Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Twitter.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Twitter, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Twitter Stored Procedures
| Name | Description |
| GeoSearch | Run a geo-search against the Twitter service. |
| GetOAuthAccessToken | Obtains the OAuth access token to be used for authentication with Twitter. If using a Windows application, set AuthMode to APP. If using a Web App, set AuthMode to WEB and specify the AuthToken, AuthKey, and Verifier returned by GetOAuthAuthorizationUrl. |
| GetOAuthAuthorizationURL | Gets the authorization URL, AuthToken, and AuthKey from Twitter. Navigate to the authorization URL in an Internet browser. This will return a verifier token that you will need to use as input along with the AuthToken for the GetOAuthAccessToken stored procedure. |
| GetRemainingRequests | Returns the number of remaining requests that can be made to Twitter and how long until the request limit is reset. |
| ReverseGeoSearch | Reverse-searches a place based on the specified latitude and longitude. |
| UploadMedia | Uploads an image or video. Only JPG, PNG, GIF, WEBP, MP4 media types are supported. |