Skip to main content
Solved

API Freshdesk to Power BI

  • November 20, 2024
  • 4 replies
  • 155 views
Tintin
Skilled Expert
Forum|alt.badge.img+3

Hi,

How can I retrieve data from Freshdesk via API for the date range from January 1, 2024 and for the specific group, to the current date?

Thank you,
Tin

Best answer by madhusingh0906

Hi ​@Tintin 

Greetings From Freshworks Community

We can export data using the API and also filter the same for the group but I am afraid that it would not allow us to set the created date range. You can schedule data export using Settings > Data export. You will find the Settings option near the New Report on Analytics homepage. You can create a data export, select the fields you want, apply the necessary filters and set the schedule.

Sample screenshot:-

 

attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTA2MDAyNDcxNzUwMiwiZG9tYWluIjoidW1icmVsbGFzb2x1dGlvbnMuZnJlc2hkZXNrLmNvbSIsImFjY291bnRfaWQiOjI4NTgxODV9.rEB6Q-pHbSpqAykEWY6QAE0I5YsJRFtuec-kUaV3N6Y

attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTA2MDAyNDcxNzYwNSwiZG9tYWluIjoidW1icmVsbGFzb2x1dGlvbnMuZnJlc2hkZXNrLmNvbSIsImFjY291bnRfaWQiOjI4NTgxODV9.MxOOgDEyvd-DckALKw3mw-kB77wnC7gBM_IGUAmRyLM

Article for reference :-Export Tickets Via API

We have another way in which we can get data export but that would be data in xml/jason format which can be received via account export. This will allow us to set the created date range filter.

Sample screenshot :-

attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTA2MDAyNDcxNzg0NCwiZG9tYWluIjoidW1icmVsbGFzb2x1dGlvbnMuZnJlc2hkZXNrLmNvbSIsImFjY291bnRfaWQiOjI4NTgxODV9.6bmJawUXuCsjYWPIfkLf-kOBXPJRozDvQgiKcNHQEXs

Article for reference :- Account Export

Hope this helps, please do let us know if you have any follow up questions or concerns :)

 

4 replies

madhusingh0906
Community Manager
Forum|alt.badge.img+7
  • madhusingh0906Community Manager
  • Community Manager
  • Answer
  • November 20, 2024

Hi ​@Tintin 

Greetings From Freshworks Community

We can export data using the API and also filter the same for the group but I am afraid that it would not allow us to set the created date range. You can schedule data export using Settings > Data export. You will find the Settings option near the New Report on Analytics homepage. You can create a data export, select the fields you want, apply the necessary filters and set the schedule.

Sample screenshot:-

 

attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTA2MDAyNDcxNzUwMiwiZG9tYWluIjoidW1icmVsbGFzb2x1dGlvbnMuZnJlc2hkZXNrLmNvbSIsImFjY291bnRfaWQiOjI4NTgxODV9.rEB6Q-pHbSpqAykEWY6QAE0I5YsJRFtuec-kUaV3N6Y

attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTA2MDAyNDcxNzYwNSwiZG9tYWluIjoidW1icmVsbGFzb2x1dGlvbnMuZnJlc2hkZXNrLmNvbSIsImFjY291bnRfaWQiOjI4NTgxODV9.MxOOgDEyvd-DckALKw3mw-kB77wnC7gBM_IGUAmRyLM

Article for reference :-Export Tickets Via API

We have another way in which we can get data export but that would be data in xml/jason format which can be received via account export. This will allow us to set the created date range filter.

Sample screenshot :-

attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTA2MDAyNDcxNzg0NCwiZG9tYWluIjoidW1icmVsbGFzb2x1dGlvbnMuZnJlc2hkZXNrLmNvbSIsImFjY291bnRfaWQiOjI4NTgxODV9.6bmJawUXuCsjYWPIfkLf-kOBXPJRozDvQgiKcNHQEXs

Article for reference :- Account Export

Hope this helps, please do let us know if you have any follow up questions or concerns :)

 

Madhu, Freshworks Community || Learn something new today, get recognized for your contributions, stay on top of product updates and build meaningful connections in our Freshdesk community. Fresh ideas, quality service :)
Tintin
Skilled Expert
Forum|alt.badge.img+3
  • Tintin
  • Author
  • Skilled Expert
  • November 21, 2024

Hi,

 

 Is there no other way to have a date range? 

 

Thank you,

 

madhusingh0906
Community Manager
Forum|alt.badge.img+7
  • madhusingh0906Community Manager
  • Community Manager
  • November 21, 2024

Hi ​@Tintin 

We do have option to set the date range or created date range but that would not give an API link. 

You can make use of the API to filter tickets using the created date and group. This api will list all the tickets which will be in the response.

API for filter ticket :- Filter ticket API

Madhu, Freshworks Community || Learn something new today, get recognized for your contributions, stay on top of product updates and build meaningful connections in our Freshdesk community. Fresh ideas, quality service :)
T
Community Debut
  • TinaD
  • Community Debut
  • March 31, 2025

Hello, is there any way to find out who created a data export in Analytics?  I went to create one and there is already one that exists in our environment, but i am not sure who did it.

Terms of UseAccessibility statement