Forum Discussion
Get Data from WEB LIKE JSON string
Hi Gurus,
Did you happen to know what get data method should I use to get below image. I tried Get Data -> JSON but seems I do not get the drop down option open file as. Any help would be highly appriciated.
Is this a public API? If so, you can provide it and the community can provide the needed M code.
Does the Source step of your query look like this? (check by clicking on Advanced Editor or viewing the Formula Bar in the query editor)
let Source = Json.Document(Web.Contents("http://mywebapi")) in SourcePasted this from here - https://www.edureka.co/community/26876/how-can-i-connect-my-web-api-with-power-bi-reports
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
3 Replies
If you are trying to connect to a Web API that gives a JSON response, use the Web connector instead. It will recoginize the response as JSON and you navigate/extract your data from there.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat it did not give me that option.
Is this a public API? If so, you can provide it and the community can provide the needed M code.
Does the Source step of your query look like this? (check by clicking on Advanced Editor or viewing the Formula Bar in the query editor)
let Source = Json.Document(Web.Contents("http://mywebapi")) in SourcePasted this from here - https://www.edureka.co/community/26876/how-can-i-connect-my-web-api-with-power-bi-reports
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
