API calls to Freshservice-Beginner level..no experience

[svishwanathan]

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

[Anonymous]

@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,
Lydia

[partner]

Hi,

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

www.freshinsights.co