ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Zendesk の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにZendesk から関連するレスポンスデータを返します。

CData SSIS Components for Zendesk ストアドプロシージャ


Name	Description
ChangePassword	Change the password of your 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	Move tickets in bulk from legacy systems into Zendesk Support. 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	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.