Forum Discussion

jmillsjmills's avatar
jmillsjmills
Helper III
3 years ago

Another Web Scraping Query

I'm looking at pulling in data from this website: https://www.betfred.com/sports/event/22986947.2   And it looks as though the embedded call to the data is via this link, which (as per the screens...
Need Help
jmillsjmills's avatar
jmillsjmills
Helper III
3 years ago

Thanks so much for coming back Aniya!

 

Sorry, I'm not quite following. Are you able to test on your side whether you can pull this data in? The link you've provided exactly the sort of thing I've been playing with but I simply cannot work out how to pull the data.

 

If you are able to kindly provide what the Power Query code would need to be exactly in this instance, I would be so very grateful!

 

Thank you so SO much!

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , jmillsjmills 

This url is your internal , i cannot test in my workaround, but you can try to use this and replace the url for yours to test .

let
    url = "https://www.betfred.com/services/SportsBook/event?language=uk&type=event&eventid=22385490.2&dataflag...[your url should replace here]",
    headers = [#"Accept"="application/json"],
    response = Web.Contents(
        url,
        [
            Headers = headers
        ]
    ),
    jsonResponse = Json.Document(response)
in
    jsonResponse

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly