Forum Discussion

emadrigals104's avatar
emadrigals104
Frequent Visitor
4 years ago
Solved

How to connect to Website

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/ 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
    ImkeF
    Community Champion
    4 years ago

    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"



  • emadrigals104's avatar
    emadrigals104
    Frequent Visitor
    4 years ago

    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.