ImportJSON

ImportJSON copied to clipboard

How can I get this value?

1

 I get a 4 x 3 matrix. But I want the 0year netIncome in raw. =importjson("https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=cashflowStatementHistory";"/quoteSummary/result/cashflowStatementHistory/cashflowStatements/netIncome";"noInherit")

Gusristic

A way to import multiple URLs and parse the data in new set.

spyhunt3d-cyber

Hello! I'm having a problem using the code. Probably it's quite simple to solve it, but I've not enough knowledge about it. The JSON code that I want to import...

selmangursoy

I have set this up in Google Sheets but when I send it a URL which I construct using concatenate()... ```https://www.googleapis.com/books/v1/volumes?q=isbn:9780099461890&fields=items(volumeInfo/title,volumeInfo/authors)``` I get the message... ``` Error Exception: Request failed...

SirClickALot

I would like to have my nested JSON appear on a single row instead of 2 rows - see example JSON below. At the moment I get two rows based...

TheGeneralLedge

pabloab

Still learning about API's and such. I'm not sure whether its the feed or the code but the output when using importJSON is only returning [object Object] in an array....

Ben-Employsure

=ImportJSON("http://phisix-api4.appspot.com/stocks/BDO.json") #ERROR Error Exception: Request failed for http://phisix-api4.appspot.com returned code 404 (line 220). Sample: https://www.lupagedigital.com/blog/philippine-stock-exchange-api/ Cloud logs: Oct 26, 2022, 11:20:22 AM Error Exception: Request failed for http://phisix-api4.appspot.com returned code...

mikaelarhelger