Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Kintone.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Kintone, along with an indication of whether the procedure succeeded or failed.
CData ODBC Driver for Kintone Stored Procedures
| Name | Description |
| AddGuests | Adds Guest users to Kintone. This does not affiliate Guest users with any Guest Spaces, and does not send any invitation emails. To affiliate a Guest user with a Guest Space, use the AddGuestsToSpace Stored Procedure. Only Kintone Administrators can use this API. |
| AddGuestsToSpace | Add the Guest users with a Guest Space. Only the Guest Space Administrator can use this API. |
| AddThreadComment | Adds a comment to a Thread of a Space. |
| AppsDeployStatus | Get app deployment statuses. |
| CreateApp | Creates apps. |
| DeleteGuests | Deletes a Guest user from Kintone. Only Kintone Administrators can use this API. |
| DeployApps | Deploys apps. |
| DownloadFile | Downloads files from an attachment field in an app. |
| GetOAuthAccessToken | Gets an authentication token from Asana. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Asana. |
| UpdateAssignees | Updates assignees. |
| UpdateStatus | Updates the status of an app record. |
| UpdateThread | Updates a Thread of a Space. |
| UploadFile | Uploads a document in kintone. |