ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Zendesk の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにZendesk から関連するレスポンスデータを返します。
CData JDBC Driver for Zendesk ストアドプロシージャ
Name | Description |
ChangePassword | To change the password of your own account. |
CreateArticleAttachment | Creates an attachment for the specified article. |
CreateContentTagsJob | Creates a job that performs one of the supported actions as a batch operation. Supported actions are delete and merge. |
DeleteTicketsPermanently | This will enqueue a ticket permanent deletion job and return a payload with the status of the jobs. |
GetOAuthAccessToken | Gets an authentication token from Zendesk. |
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. |
ImportSideConversation | Imports a side conversation on the ticket. |
ImportSideConversationEvents | Imports events to an existing side conversation. |
ImportTickets | To move tickets in bulk from legacy systems into Zendesk Support. In this, you can include one or more comments with a ticket. |
MergeTickets | Merges one or more tickets into the target ticket. |
RecoverSuspendedTicket | Recover a previously suspended ticket. |
RestoreTicket | Restore a previously deleted ticket. |
SetUserPassword | To set a user's password by admin if the option is enabled in the Account. Admins and agents can also use this Stored Procedure to change their own password. |
UploadUserImage | To let end users upload images to a help center instance. Returns the image path that you can use to display the image in a community post. |