Google-sheets – Google Sheets importxml() showing “Imported Content Empty”

Some tools that give the xPath are able to read the DOM of the related page after it was modified but IMPORTXML is only able to read the source code of the page. In these cases, you should use another tool or manually find out the xPath.

Related

• How to create an auto updating Google spreadsheet with information from Steam?
• Google Sheets importxml() can't fetch from this URL

When URL: http(s)://www.moneycontrol.com/stocks/fno/marketstats/futures/gainers/homebody.php?opttopic=&optinst=allfut&sel_mth=1&sort_order=0

opened in client (browser) following server side rendering of dynamic data are requested by browser:

 - send @   jquery-1.12.0.min.js:4 
 - ajax @   jquery-1.12.0.min.js:4
 - updaterss    @   jquery.webticker.js:39
 - (anonymous)  @   jquery.webticker.js:137
 - many more...

this is why you can not use IMPORTHTML or IMPORTXML to fetch Dynamic data as in this webpage.

How to check if Error: Imported Content is Empty is because of dynamic data?

1. use a la carte rendering of web page in question like:

   =IMPORTXML("http://www.moneycontrol.com/stocks/fno/marketstats/futures/gainers/homebody.php?opttopic=&optinst=allfut&sel_mth=1&sort_order=0", "/")

   • "/" will force to fetch everything from URL, and there is nothing useful in this IMPORT XML/HTML for your need.

2. Using the Chrome browser's INSPECT function displays all the client requests.