Skip to main content
Question

Access the survey responses with Power Bi

  • March 15, 2024
  • 0 replies
  • 13 views

rolevc
Contributor
Forum|alt.badge.img+1

Hi,

 

I am using the Freshservice growth edition, which prevents me from scheduling reports and using their API to get the data I need. So, I am using the FreshService API to connect directly and extract all information. So far, I was able to get everything I need using the different API connectors (Tickets, groups, Sla_policies, etc.) but… I am missing the one for Survey (CSAT/ESAT).

I tried with https://companyname.freshservice.com/api/v2/surveys but only got the main survey info (we only have one). I am trying to see how to get a single table with all tickets ID, their survey responses and work on a report for it.

The API mentions using /api/v2/tickets/id]/csat_response for each ticket, but I would like to have a more detailed single table with all responses. Any ideas?

 

thanks!