Forum Discussion
mrpowrbihelp
8 years agoFrequent Visitor
scrapping amazon
I'm able to load the webpage and create a table in Power BI. Below is the advanced editor. let Source = Web.BrowserContents("https://www.amazon.com/gp/offer-listing/0062420704"), #"Extracted Ta...
Stachu
8 years agoCommunity Champion
my guess is unnecessary paranthesis, try this
Source = Web.BrowserContents("https://www.amazon.com/gp/offer-listing/" & ASIN),mrpowrbihelp
8 years agoFrequent Visitor
That worked. Thanks!
Would you know how to loop thru the next pages. I found tutorials for how to do it if the page number is shown in the URL, but that is not the case with Amazon. When you click to page 2 the URL changes to the below.
What could I write to get it to loop thru all the pages of data?