Google sheets shows could not fetch URL

Asked May 24 '21 at 12:26

Active Oct 31 '22 at 04:29

Viewed 107 times

I wrote few importXML functions in Google Sheet to get EMA values for a company's stock & it was working fine. Suddenly, I saw the below error

Could not fetch URL: https://www.topstockresearch.com/INDIAN_STOCKS/REFINERIES/Reliance_Industries_Ltd.html

Things I tried

I did a SO search & changed HTTPS to HTTP. This worked only for the first time. I toggled between HTTP/HTTPS back & forth but still it does not work in any of the options.

This is also a crawlable page, as I tried disabling javascript & checking if the page loads or not. The page loaded perfectly fine.

edited Oct 31 '22 at 04:29

Rubén

34,714
9
70
166

asked May 24 '21 at 12:26

Pranav Shah

What are your functions? – Rafa Guillermo May 24 '21 at 13:34
I tried it, and I encountered a 403 error (forbidden). That's the problem and I have no solution. – Mike Steelson May 24 '21 at 15:00
Cell A4 = https://www.topstockresearch.com/INDIAN_STOCKS/REFINERIES/Reliance_Industries_Ltd.html. Formula Used: importxml(A4,"//*[@id='datagrid']") – Pranav Shah May 24 '21 at 16:18
Yeah I don't think there's a way around this. The web server is denying the fetch, nothing that can be done from Google sheets side – Rafa Guillermo May 25 '21 at 09:46
ok thank you. So its not google, the server does not allow the import. – Pranav Shah May 27 '21 at 06:41

Google sheets shows could not fetch URL

0 Answers0