Question

Load of tickets more than 30 000 using Freshdesk REST API v2

  • 18 October 2022
  • 4 replies
  • 813 views

Userlevel 1
Badge

Account has tickets more 30 000 items. Using Freshdesk REST API v2 I can load max 30 000 tickets (max page number: 300 and max 100 items per page). How I can load all tickets? 


4 replies

Userlevel 5
Badge +6

Hi @Ruslan 

 

Greetings from the Freshworks community!

 

I can understand that you would like to load all the tickets via API.

 

I am afraid there is a limitation of 9000 tickets for the list all ticket API as mentioned in our API documentation - https://developer.freshdesk.com/api/

 

13CjXswLjVhv7wQPqTU3EW9BjL8_UcPwVMyjuwyxXOliJvAWV2JXqwl2rTtFC4CF8CmvFz7Ko1pkdB18GdcHhbDajO4D9SrpKZ042p1H1ilCXk8k5N2H3KGqNw-3_dbAvuHiti89PyiWjo963BrqngN6w3O-oXUVL2uyGxI15iO3fbzee9q6bdcSKA

 

In case the use case is to fetch all the tickets created till date in your account, could you make use of the Account data export option - https://support.freshdesk.com/en/support/solutions/articles/226393-how-do-i-export-the-data-in-my-account-

 

That said, please have a look at our Ideas page, and post your ask here. We will look into this and take this up from our end.

Userlevel 1
Badge

@Aishvarya Hi! Thank you for answering! Is there any way to get all tickets via API? Or only using Account data export option on UI? :( 

Userlevel 5
Badge +6

Hi @Ruslan 

Unfortunately, you either have to perform a filter ticket API or an account export to get all the tickets in your helpdesk. The list all APIs would only return 9000 tickets at the moment. Apologies for not being of much help here.

Badge

We have had on various sites a similar issue for several years. Larger sites often have over 100.000 tickets stored and these numbers grow by time. Ultimately, we have created an incremental tickets table. It initially loads a set using updated_since and then starts combining the starting point with changed tickets: insert, update and delete. After initial load, the typical number of API calls per day goes down to a few dozen at most. It has some disadvantages compared to hypothetical directly accessing the Freshdesk database, but for most purposes it works fine.

 

See https://forums.invantive.com/t/freshdesk-power-bi-performance-improvements-for-large-volumes-of-tickets/2994 for details.

Reply