Get Data from WEB LIKE JSON string

[amaleranda]

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.

[mahoneypat]

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

[amaleranda]

@mahoneypat  it did not give me that option.

[mahoneypat · Accepted solution]

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
    Source

Pasted 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