Forum Discussion
API calls to Freshservice-Beginner level..no experience
Good Morning
My company uses Freshservice to manage IT tickets. Power Bi doesnt have custom connectors to Freshservice
I want to be able to run a snapshot report for all open tickets. I have no experience in developing APIs, so my questions may seem very basic
How do I get started? I know that I need to call APIs. I got a webservice Rest API client to be able to call APIs....now I am clueless what needs to be done next...
Need a lot of help to stand up and get running with this
2 Replies
svishwanathan,
Please review the following examples.
Power BI – Connect to your secure API
API Strategies with Power BI
Your code could be as below.let Source = Json.Document(Web.Contents("URL", [Headers = [#"Content-Type"="application/json", #"Authorization"="Basic <your_access_token>"]])) in Source
Regards,
LydiaHi,
My organisation has built connectors between PowerBi and Freshservice and PowerBI reports are available as out-of-the box solution. You can check out on Freshservice market place: https://apps.freshservice.com/freshservice_on_powerbi/ or visit www.freshinsights.co for more details. We offer limited free period and you can see the reports and dashboards with your data.
Warm Regards,
Janani
