Fetch data from a web source

[abartozzi]

hi PBI community, have to seek help for this one. 

So i need to set up a call to this api.

https://data.xotelo.com/api/rates?hotel_key=g297930-d305178&chk_in=2021-03-25&chk_out=2021-03-26

After changing with a function all relevant parts in order to obtain data what the api returns is something like this:

it should be a sort of JSON format response however the format seems not suitable to be fetched by power bi:

I also tried to use the "add table based on example" however it says that it canìt find any CSS selector for example values. 

Hence it's impossible to get any data out of this. 

Do you know any way I can work out a solution?

thank you

Alberto 

[Syndicate_Admin]

Hello, I found a web page that contains some data that interests me but is visualized with power BI. How do I get that data and upload it to my power BI?

[PhilipTreacy · Accepted solution]

Hi @abartozzi 

Download example PBIX with the following code

The JSON returned from the API is valid.  To get it you can wrap the Web.Contents function in Json.Document like this

let
    Source = Json.Document(Web.Contents("https://data.xotelo.com/api/rates?hotel_key=g297930-d305178&chk_in=2021-03-25&chk_out=2021-03-26")),
    result = Source[result],
    #"Converted to Table" = Record.ToTable(result)
in
    #"Converted to Table"

Regards

Phil