Forum Discussion

gracerashmi's avatar
gracerashmi
Helper I
8 years ago

Connecting to API

Hi Team,   I am new to Power BI kindly help how to connect to API to start the data extraction and data model.   Regards GR
Need Help
MagnusSthlm's avatar
MagnusSthlm
Helper I
8 years ago

Hi!

 

What kind of API do you need to connect to?

  • gracerashmi's avatar
    gracerashmi
    Helper I
    8 years ago

    Need to coonect to Json API with input parameteres

    • MagnusSthlm's avatar
      MagnusSthlm
      Helper I
      8 years ago

      Hi!

       

      Go to Query Editor, choose "New Source" -> "Blank Query". Enter your url to your json something like this:

       

      = Json.Document(Web.Contents("https://yourjsonurl.com/parameter"))

       

      Then you need to click List and transform into table, select what fields you want. Finally rename Query1 to something else.

       

       

      • gracerashmi's avatar
        gracerashmi
        Helper I
        8 years ago

        url: https://MyUrl/REST/mylink

        input parameter:
        { "ServiceName":"GETTicket", "objCommonParameters":{ "_ProxyDetails":{ "Password":"test@123", "UserName":"[email protected]", "ProxyID":0, "ReturnType":"JSON", "OrgID":1 }, "CallerMobileNo":"91XXXXXXXX", "CallerID":"2", "TopIncident":5 } }

         

        how do i execute this code. can any1 plz help on this