Webscrape from lego.com with VBA (Collect LEGO set prices from lego official site)

Question

Hello everyone,

I want to get some data from lego.com in Excel, VBA and i tried some code, however i cound't get anything, the best i could get for any king of data was only an empty message box.

I would like to get price infos for this set (or any other):

https://www.lego.com/hu-hu/product/lego-ideas-home-alone-21330

There are two place where price can be found. one is under:

class="Text__BaseText-sc-13i1y3k-0 zkrlj ProductPricestyles__StyledText-sc-vmt0i4-0 tMWye"

The other is the meta datas. I would better like to get from meta because there are other informations i would collect colse to each other.

i would like to collect: set name, availability, price, set number.

These are the meta properties: og:title, product:condition, product:price:amount, product:retailer_item_id

But the most important would be: product:price:amount

<meta property="product:price:amount" content="126990">

Somehow i would like to get the content of a meta data. But it doesn't have an ID or Name, but it has a unique property info but i don't know how to use it.

I found out this part of the code is something called "Open Graph Protocol (OGP)". https://juniortoexpert.com/en/ogp-open-graph-protocol/

Any other solution would be great as well.

Can someone help me how to get these datas from lego.com ?

Thank you very much!

Answer 1

<meta property="product:price:amount" content="126990">

Answer 2

class="Text__BaseText-sc-13i1y3k-0 zkrlj ProductPricestyles__StyledText-sc-vmt0i4-0 tMWye"

Answer 3

class="Text__BaseText-sc-13i1y3k-0 zkrlj ProductPricestyles__StyledText-sc-vmt0i4-0 tMWye"