Skip to main content
Question

API Freshdesk

  • November 22, 2024
  • 3 replies
  • 51 views

Tintin
Skilled Expert
Forum|alt.badge.img+3
  • Skilled Expert
  • 11 replies

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,

Did this topic help you find an answer to your question?

3 replies

00robertjoseph00
Community Debut

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!


Tintin
Skilled Expert
Forum|alt.badge.img+3
  • Author
  • Skilled Expert
  • 11 replies
  • November 23, 2024

Hi, 

 

Is there a page limit?

 

Thank you 


madhusingh0906
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 49 replies
  • November 28, 2024

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 :)