Tip: How to Export incident tickets linked to Problem ticket as CSV/Excel
The Goal
Export incident tickets from a Problem ticket into CSV or Excel format which allows businesses to analyze a specific technical issue that was widespread and implement improvements for the future.
Prerequisites
- The user who is exporting the data should be logged in to zendesk as admin/agent
- Online JSON to CSV converter https://json-csv.com/
Instructions
Step 1
Make an API call from the browser to list the incident tickets linked to the problem ticket
https://subdomain.zendesk.com/api/v2/tickets/{problem_ticket_id}/incidents.json
Note: Replace subdomain with your zendesk account name and problem ticket id.
For Ex: https://acme.zendesk.com/api/v2/tickets/115/incidents.json
Step 2
Once json result is loaded completely, save it on your computer using CTRL+S or CMD+S
Step 3
Open the online JSON to CSV converter and upload the JSON file.
Step 4
Review and download the results
Note: Zendesk allows a max of 100 records so if you have more than 100 incident tickets linked to the problem ticket then you may need to use page parament in your URL.
You can simply find get the next page URL at the bottom of your json result.
That's it!
-
Thanks for posting this tip, @...!
-
Thanks for providing this example. I wish there were an 'export' button in the product. The link is very helpful.
Instead of uploading potentially confidential customer data into the json-csv.com website, you can open it in a code editor.
For example, after downloading the .json from the browser, open the .json in VS Code.
Select all text then click 'View' > to choose 'Word Wrap'.
Then, select all text, and use shortcut to format in easy-to-read view.
Shortcut:
Shift + Alt + F - Windows
Shift + Option + F - Mac
Ctrl+Shift+I - Linux -
Similar to how we can export all the tickets in a view, I would love to have that feature built in to the product for linked tickets to a problem ticket. This would allow us to export all tickets that are linked to a problem ticket. This seems like a rather useful and intuitive functionality to have especially since problem tickets are usually issues that need to be investigated and it's helpful to be able to have an excel/CSV of all tickets with the issue.
-
This is great, although it does not provide actual requester and organization names and instead gives the IDs, which aren't as useful to the average user. It would be awesome if you could create a view for these instead.
Please sign in to leave a comment.
4 Comments