Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the component 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 SSIS Components 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.