How to extract hyperlink from webpage - Yellowpages example

[Mchamarelli]

Hi!

I´m trying to use powerBI to scrape the yellowpages to build a lead database to a client. I can use the examples easily however I´m not able to get to the URL from the site. Here is the URL from the Yellow Pages.

Any ideas?

https://www.yellowpages.com.au/search/listings?clue=Child+Care+Centres&locationClue=Victoria&pageNum...

[Mchamarelli · Accepted solution]

No worries guys! I figured it out by myself!

here is the code for future reference:

let
Source = Web.BrowserContents("https://www.yellowpages.com.au/search/listings?clue=Child+Care+Centres&locationClue=Victoria&pageNum..."),
#"Extracted Table From Html" = Html.Table(Source, {{"Name", ".inside-gap-medium.vertical:nth-child(1) > .first-cell > DIV.media-object.clearfix.inside-gap-medium.image-on-right.listing-summary:nth-child(1):nth-last-child(1) > .body > .listing-name"}, {"Website","a[href^=""http""]", each [Attributes][href]}} , [RowSelector=".search-results > DIV.flow-layout.outside-gap-large.inside-gap.inside-gap-large.vertical:nth-child(1):nth-last-child(1) > .in-area-cell"]),
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Name", type text}, {"Website", type text}})
in
#"Changed Type"