Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in 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 Excel Add-In for Zendesk Stored Procedures
| Name | Description |
| AddTicketTags | Appends tags to a specified ticket. |
| BulkMarkTicketsAsSpam | Marks up to 100 tickets as spam. This deletes the tickets and suspends their requesters. |
| BulkRestoreTickets | Restores up to 100 previously deleted tickets. |
| ChangePassword | Changes the password of your account. |
| CloneTicketForm | Creates a new ticket form by cloning an existing one. |
| 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. |
| DeleteMultipleSuspendedTickets | Deletes up to 100 suspended tickets. |
| 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. |
| MakeTicketAuditPrivate | Changes the comment on a ticket audit from public to private. |
| MakeTicketCommentPrivate | Changes a public ticket comment to a private comment. |
| MarkTicketAsSpam | Marks a ticket as spam. This deletes the ticket and suspends its requester. |
| MergeTickets | Merges one or more tickets into the target ticket. |
| RecoverMultipleSuspendedTickets | Recovers up to 100 suspended tickets. One row is returned for each ticket that was recovered. |
| RecoverSuspendedTicket | Recovers a previously suspended ticket. |
| RedactCommentAttachment | Permanently removes an attachment from a ticket comment, replacing it with an empty redacted.txt file. This cannot be undone, and it is not possible once the ticket is closed. |
| RedactTicketComment | Permanently removes words, strings, or attachments from a ticket comment. Unlike the older redact endpoint, this also covers closed tickets, archived tickets, and formatted text. Redaction cannot be undone. |
| 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. |