Hi,
How can I retrieve data within the specific group from Freshdesk via API for the date range from January 1, 2024, and to the current date?
We need to integrate this in Power BI tool.
Thank you,
Solved
API Freshdesk
+3Best answer by madhusingh0906
Hi
Greetings From Freshworks Community
To get the tickets for a particular group and created between a certain date range we can use Filter tickets API as mentioned by
Article :- https://developer.freshdesk.com/api/#filter_tickets
Regarding the other concern of page limit a maximum of 300 pages (30000 tickets) will be returned.
Hope this answers your concern.
Thanks :)
1 person likes this
To retrieve ticket data for a specific group from Freshdesk via API for a date range, use the **Tickets API** (`GET /api/v2/tickets`). For example:
```
https://yourdomain.freshdesk.com/api/v2/tickets?group_id=12345&updated_since=2024-01-01T00:00:00Z
```
Replace `12345` with your group ID and adjust the date as needed. Freshdesk doesn’t support an end date filter, so you'll need to handle that in Power BI. Use Power BI’s web connector to pull the data and include your Freshdesk API key for authentication. Be mindful of pagination with the `page` parameter. Let me know if you need more details on the integration!
+3Hi,
Is there a page limit?
Thank you
+5- Community Manager
- 49 replies
- Answer
Hi
Greetings From Freshworks Community
To get the tickets for a particular group and created between a certain date range we can use Filter tickets API as mentioned by
Article :- https://developer.freshdesk.com/api/#filter_tickets
Regarding the other concern of page limit a maximum of 300 pages (30000 tickets) will be returned.
Hope this answers your concern.
Thanks :)
Reply
Join the Community
Already have an account? Login.
Sign in to the Community
No account yet? Create an account.
Social Login
Login with LinkedInor use your username
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.