Getting data from Freshdesk Support Desk

[jevansfbc]

Hi

I am trying to build a dashboard for an overview of our IT ticketing, we are using Freshdesk Support Desk.

I have managed to get a data connection in PBI but I don't know how to pull through more than 30 tickets.

Has anyone successfully used PBI with Freshdesk before?

[Syndicate_Admin]

Hello could you, share how you made that connection

[Anonymous · Accepted solution]

Hi @jevansfbc 

The API call returns 30 records by default and 100 by extending the page. But the confusion is in that it will never just give you a full output of your data. You have to work for it.

This link may help:

List all tickets

Here is a blog about how to import data from Web REST APIs that implement Cursor-Based Pagination:

Iterate over dynamic Web API Pages with Power Query - How to resolve Cursor-Based Pagination - DataC...

This process is an example using Power BI, so while it may take a bit to figure out how to replace your API calls.

^{Best Regards,}

^{Zhengdong Xu}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}