Google Sheets ImportXML – How to Import a JSON Query from Investing.com

google sheetsimportxml

I've trying this for several days and I'm not able to load the data displayed below the graph in https://es.investing.com/equities/facebook-inc

IMPORTHTML does not work because these fields are the response from a JSON query. I've used Chrome Dev Tools to save the result in a HAR file and found one of the fields "Retorno un año", but I am not able to automatize the query (curl cmd only returns the .js source code, not the response, it was the first time that I used it…):

Any ideas about how to import these fields into a Google Docs Spreadsheet?

P.S.: I can't paste the commands due to my low reputation (no more than 1 URL allowed), sorry 🙁

Best Answer

You can pull in all those fields using importxml instead of importhtml:

=IMPORTXML("https://es.investing.com/equities/facebook-inc","//*[@class='clear overviewDataTable']/*")

Related Solutions

Google Sheets – How to Import JSON Data into a Google Spreadsheet

Currently there is no any Add-on which offer this functionality, so you have to create or import custom functions by Script Editor available in Tools menu (for Spreadsheet). Then re-paste the content of ImportJSON.gs from bradjasper's GitHub page and save it.

After that, you can use ImportJSON function, for example:

=ImportJSON("http://gdata.youtube.com/feeds/api/standardfeeds/most_popular?v=2&alt=json", "/feed/entry/title,/feed/entry/content", "noInherit,noTruncate,rawHeaders")

Here is another example:

=split(concatenate(ImportJSON("https://api.binance.com/api/v1/klines?symbol=BTCUSDT&interval=1m&limit=1")), ",")

The ImportJSON library at Fast Fedora
Import JSON data into Google Spreadsheet at Stackoverflow
Custom Functions in Google Sheets at Google Developers

Google Sheets – Query to Import HTML/XML Data

The referred site use JavaScript to load several tables from other files after the user click on the "All Reports" link.

The solution is to find the source file of the desired table and use its URL instead of the one considered in first place.

Best Answer

Related Solutions

Google Sheets – How to Import JSON Data into a Google Spreadsheet

Google Sheets – Query to Import HTML/XML Data

Related Topic