Visit Freshworks.com Visit Freshworks

How can I export the content (body text) of all my tickets?

  • 10 December 2019
  • 4 replies
  • 1214 views
M
Rank

Hey all,


I'd like to do a search for particular keywords in all my company's tickets. Freshdesk doesn't provide a search function for keywords so I figured I'd make an export of all tickets and do the search manually in Excel, because searching ticket by ticket when you have 1,000s of tickets is very time-consuming.


Now that I've made some exports, it seems as if the body text of the tickets isn't included in the export. Doesn't Freshdesk provide this option? 


Thanks in advance for your help.


Gregor



4 replies

A
Rank

Hi,


There is an export button in the tickets menu. You can export all fields from your ticket to CSV or Excel directly. Freshdesk will email you the file.


O
Rank
Badge +7

@Antony: this only exports the ticket or contact fields plus some time/date fields. It does not export ticket content i.e. description and subsequent discussion.


M
Rank

New here, but being a programmer I'd use API to pull it all out, preferably in text format and not HTML. https://developers.freshdesk.com/api/#conversations


V
Rank

Hello, 


The description of the ticket can be obtained from the UI. Click on Show multiline text fields and choose Description. Please refer to the screenshots below:





To obatin the conversations present in the ticket, you can make use of List all conversations API:
https://developers.freshdesk.com/api/#list_all_ticket_notes

Hope this helps.

Cheers! 

Reply


Terms of UseCookie settings