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