Forum Discussion
Getting data from Freshdesk Support Desk
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?
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:
Here is a blog about how to import data from Web REST APIs that implement Cursor-Based Pagination:
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.
2 Replies
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:
Here is a blog about how to import data from Web REST APIs that implement Cursor-Based Pagination:
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.
Hello could you, share how you made that connection
