Only #VALUE with Xpath and Amazon

Support
#1

Hi,
I'm trying again to scrape seller information from Amazon but I only get #VALUE.
One example:
https://www.amazon.es/sp?_encoding=UTF8&asin=B07GVB5RM9&isAmazonFulfilled=1&isCBA=&marketplaceID=A1RKKUPIHCS9HS&orderID=&seller=A1I3SPZNL89XX2&tab=home&vasStoreID=

//*[@id="seller-profile-container"]/div[2]/div/ul/li[1]/span

Anyone can help? Thanks !!

38
Captura de pantalla 2019-05-31 a las 11.24.38.jpg2370×272 149 KB

#2

This formula works for me:
=Dump(XPathOnUrl(A1;"//div[@id='seller-profile-container']//ul/li"))

bild
bild.png1166×573 38.1 KB

#3

Does not work for me. What could be the reason ? The internet connection?

23
Captura de pantalla 2019-05-31 a las 14.22.23.png2320×240 173 KB

#4

Your formula is messed up. The dump formula and XPathOnUrl is included in the argument for the Xpath. Can you try my formula and place the URL in cell A1?

#5

I get this. Thanks !

32
Captura de pantalla 2019-06-01 a las 13.34.32.jpg2282×628 459 KB

#6

Can you email me the Excel file with the errors? victor@seotoolsforexcel.com