user3865289
Reputation: 11
Import XML Using Xpath for Spreadsheets saying "import internal error"
I am trying to collect some data on a few Forbes articles using import XML and XPath. I want to pull article views on this page http://www.forbes.com/sites/kurtbadenhausen/2014/07/20/rory-mcilroy-is-golfs-leading-man-with-british-open-win/
I'm using this.
=IMPORTXML("http://www.forbes.com/sites/kurtbadenhausen/2014/07/20/rory-mcilroy-is-golfs-leading-man-with-british-open-win/", "//html/body/div[5]/section[1]/div[2]/hgroup/h5/span")
The response I keep getting is
Import Internal Error
Upvotes: 1
Views: 498
Answers (1)
dirkk
Reputation: 6218
Your XPath is not finding any element. The Forbes site is displaying another layer page before the actual content page if you have not accessed it before. Hence, Google sees this layer page instead of the article content.
Hence, you can not import this page using Google Spreadsheet.
Upvotes: 1
Related Questions
- Import Internal Error during ImportXML with Google Spreadsheet
- How to figure out proper xpath for IMPORTXML in Google Sheets - Receiving An Error?
- Google Sheets IMPORTXML error: Import Internal Error
- Google spreadsheet ImportXML Error:"the XPath query did not return any data"
- Google Spreadsheet ImportXML xpath issue
- IMPORTXML Error on Google Sheets
- importxml to google spreadsheet with xpath returns FALSE
- google sheets import internal error
- xpath on Google spreadsheet "Internal import error"
- importxml google spreadsheet - "xml content cannot be parsed" error in NEW Google Sheets