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/

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.

@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? :( 

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.

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.