Amazon Price in Google Spreadsheets
I tried following the answers here , but I am getting an error Imported Xml content can not be parsed
.
Here's what I've tried:
=importXml("http://www.amazon.it/Asus-GeForce-Scheda-Display-Edition/dp/B00SKWIISQ/","//span[@id='priceblock_ourprice']")
=importxml(hyperlink(concatenate("http://www.amazon.it/Asus-GeForce-Scheda-Display-Edition/dp/B00SKWIISQ/")),"//*[@id='priceblock_ourprice']")
None of them worked.
EDIT: Functions work intermittently. The problem seems to be with the Amazon site as sometimes it works, sometimes it doesn't (and I get "imported content could not be parsed"). When it doesn't, sometimes if I add or remove the trailing slash, it works again. No problem with other sites. Seems to be a known issue: https://productforums.google.com/forum/#!topic/docs/UuMGRl7Asew https://productforums.google.com/forum/#!topic/docs/yWPaNDK0Kpg What is the reason the mystery is.
source to share
if you try //*
xPath, then you can see Amazon doing robot validation. This is the reason for the unsuccessful analysis.
Unfortunately, I don't see an obvious way to overcome this.
And as for changing comma to semicolon and vice versa - it won't work, because it depends on your local settings for Google Spreadheet that you have to use in functions. For some countries it is a comma, for others it is a semicolon.
source to share