How to connect to Website

[emadrigals104]

Hi everyone, I have recently tried to connect to the web page, however, and tried to use Html.Table and have not been successful in extracting the team stats information from the following web page. I appreciate your collaboration.

https://es.uefa.com/uefachampionsleague/statistics/clubs/ 

[Anonymous · Accepted solution]

Hi @emadrigals104 ,

Is this the table you want?

Best Regards,

Stephen Tao

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

[ImkeF]

Hi @emadrigals104 ,
sorry, I have no idea why that is. I'm getting a full table with that script.

[emadrigals104]

Hi @ImkeF 

I tried to run the submitted script but it gives me an error when trying to access the web page. I have permissions enabled in my config and I have webview2. I do not understand why it does not let me see that specific page, since if I use other web pages, I have no problems.

[ImkeF]

Hi @emadrigals104 ,
this query returns the results that I would expect:

let
    Source = Web.BrowserContents("https://es.uefa.com/uefachampionsleague/statistics/clubs/"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".N51GH5vJJlIa6hwjHbZQ"}, {"Column2", ".pk-badge + *"}, {"Column3", ".pk-identifier SPAN + *"}, {"Column4", ".is-active .a6hEscoxpkolLo5esjqi"}, {"Column5", ".with-width:nth-child(3) *"}, {"Column6", ".with-width:nth-child(4) *"}, {"Column7", ".sc-pk-table-cell-h:nth-child(5) *"}}, [RowSelector=".sc-pk-table-row-h"]),
    #"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", Int64.Type}, {"Column2", type text}, {"Column3", type text}, {"Column4", Int64.Type}, {"Column5", Int64.Type}, {"Column6", Int64.Type}, {"Column7", Int64.Type}})
in
    #"Changed Type"