Copper price from metal.com (shanghai)

[scottiex]

Similar to my recent post,
I now want to get the copper price from

https://www.metal.com/

the value against
SMM 1# Copper Cathode(RMB/mt)

or the one that shows if you click through that link to

https://www.metal.com/Copper/201102250376

For some reason trying to use power query it doesn't show me the data.
Last time Haluk showed me a link to some Json and that also worked well.

[scottiex]

when i pull it up in power query I just get

kind,name,children,text
element, html, table, null

changing the query to xml gives me nothing and text gives me a bunch of html including
"The browser you using may not be able to browse the website normally. To get a better website browsing experience, we recommend two methods "


I presume I am doing something wrong

[alansidman]

You have done nothing wrong. I have seen this many times and it will require someone with more skills in this area. I am not sure if this is a Selenium Issue or an API issue. Patience and hopefully someone with those skills will be along.

[scottiex]

Thanks alansidman