Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in 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 Excel Add-In for Kintone Stored Procedures
| Name | Description |
| AddGuests | Adds guest users to the Kintone environment for controlled external access without sending invitations or automatically assigning them to Spaces. |
| AddGuestsToSpace | Assigns existing guest users to a specific guest Space so administrators can grant workspace-level access where needed. |
| AddThreadComment | Adds a comment to a discussion thread inside a Space to support team communication and auditability. |
| AppsDeployStatus | Returns the deployment status for one or more apps so you can track whether recent app updates are live and available to users. |
| CreateApp | Creates a new Kintone app from a provided configuration, supporting automated provisioning workflows. |
| DeleteGuests | Removes a guest user from the environment, helping administrators maintain security and revoke external access when needed. |
| DeployApps | Deploys pending app updates so schema changes, permissions, and settings become active in the production environment. |
| DownloadFile | Downloads a file stored in an app's attachment field so it can be archived, processed externally, or analyzed offline. |
| GetOAuthAccessToken | Gets an authentication token from Kintone. |
| 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 request the OAuthAccessToken from this URL. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Kintone. |
| UpdateAssignees | Updates the user or group assigned to a record, supporting workflow progression or ownership changes. |
| UpdateStatus | Updates a record's status field to move it through a workflow step or process stage. |
| UpdateThread | Updates an existing discussion thread inside a Space so teams can maintain current and accurate collaboration history. |
| UploadFile | Uploads a file to Kintone for use as an attachment or app resource during record creation or updates. |