Skip to main content

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,

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!


Hi, 

 

Is there a page limit?

 

Thank you 


Hi ​@Tintin 

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 ​@00robertjoseph00.

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