Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the provider beyond simple SELECT/INSERT/UPDATE/DELETE operations with Zendesk.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Zendesk, along with an indication of whether the procedure succeeded or failed.

CData ADO.NET Provider for Zendesk Stored Procedures


Name	Description
AddTicketTags	Appends tags to a specified ticket.
ChangePassword	Changes the password of your account.
CreateArticleAttachment	Creates an attachment for an article.
CreateContentTagsJob	Creates a job that performs one of the supported batch actions on content tags. Supported actions are delete and merge.
CreateTicketComment	Creates a new comment on the specified ticket.
DeleteTicketsPermanently	Enqueues a job to permanently delete the specified deleted tickets.
DownloadCommentAttachment	Downloads the specified attachment for a ticket comment.
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 a 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	Recovers a previously suspended ticket.
RefreshOAuthAccessToken	Refreshes the OAuth token.
RestoreTicket	Restores a previously deleted ticket.
SetUserPassword	Sets a user's password as an admin, if the option is enabled in the account. Admins and agents can also use this stored procedure to change their own password.
UploadUserImage	Uploads an image to a help center instance on behalf of an end user. Returns the image path that can be used to display the image in a community post.