Forum Discussion
Connecting to API
Need to coonect to Json API with input parameteres
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.
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
url: https://MyDomain.com/REST/MyURL
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 to execute and connect to api
This link might help you:
https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/