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.

+3


source to share


2 answers


Try the following:

=importXml("http://www.amazon.it/Asus-GeForce-Scheda-Display-Edition/dp/B00SKWIISQ";"//span[@id='priceblock_ourprice']")

      



I changed the colon to a semicolon and removed the trailing slash of the URL to make sure there was no HTTP redirect.

0


source


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.

0


source







All Articles