GoogleHTML sheet import Failed to get url
Can anyone confirm this for me?
I am helping someone with importHTML problem in google spreadsheet. I'm not familiar with importHTML, but I thought it should work.
=importhtml("http://www.stockq.org/","table",1)
I don't care what table I import as long as it is importing something. It gives an error message Error: Could not fetch url: http://www.stockq.org/
. But the website is available in my browser. This is really weird.
source to share
My google spreadsheet can't handle Chinese characters, but the numbers I recognize on a web page happily import, for at least an average spreadsheet of three, with:
=importhtml("http://www.stockq.org/","table",A12)
This is what I think @DigitalSeraphim mentioned back in September. To quote from the answer that was deleted (how not the answer?):
So I am creating a page to help me keep up with mod updates for my minecraft server using importxml heavily. I found that I am getting the same error for some sites that absolutely load in the browser. Examining it further, I found that sites are reporting 404 errors, but are actually returning the requested data. According to https://drupal.stackexchange.com/questions/110651/how-to-show-a-node-but-return-http-404-response , this is used to remove pages from search engines as I assumed. I don't think it can be done without hackers ... namely, create a "proxy" that "fixed" the status.
However, it looks like the example you gave is now working, so maybe try again.
source to share