1

My org is using utilizing Zendesk for work orders. To do this, we have created custom fields to manage statuses and various other information. I want to be able to export this data for reporting purposes to see what is completed, what is in progress, etc. but the 10 column limitation in Zendesk is an issue. Can I use the API to export these work order tickets with a column for each custom field and get it into CSV?

d3mozs
  • 43
  • 7

2 Answers2

0

Can you be more specific on which Zendesk product are you using? They have lots of different products (Zendesk Support, Zendesk Talk, Zendesk Chat, etc.). Feel free to contact me through email.

god830
  • 35
  • 4
  • I am using Zendesk support I believe. I am working inside of the ticketing system, but we have temporarily repurposed it to house work orders. – d3mozs Jul 21 '21 at 16:10
  • P.S. If it's for work and you have a budget, there are two options. The simplest option is Acho.io, you can pull the data out as CSV and do some data analysis without writing any code. If you know how to code, have a data warehouse, and have days to spend you can try panoply.io. If you don't have a budget and you are good at coding, give Airbyte a try. – god830 Jul 22 '21 at 00:13
0

Zendesk Views do have current 10 column limitation. Although Zendesk provides multiple api endpoints to export data from its products.

You can do following:

  1. Export with the time-based incremental export api export. Documentation link

  2. Export with Query based search endpoint. Documentation link. There is also a zendesk community post "Support Search Reference" on how to create search query. Do take a look at that!

IMO you probably want to go via route 2.

There's also an Advanced Search marketplace app which is pretty handy and easy to use!

Vote this up , If you found this helpful!

Karun
  • 188
  • 2
  • 11