How can I get this value?

bradjasper / ImportJSON

Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet

GNU Lesser General Public License v3.0

2.11k stars 1.06k forks source link

How can I get this value? #240

Open Gusristic opened 2 years ago

Gusristic commented 2 years ago

Captura de pantalla 2022-08-11 203636

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")

NeutrinoPanda commented 2 years ago

Wrap this in an index() function. So: =index(importjson("[https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=cashflowStatementHistory";"/quoteSummary/result/cashflowStatementHistory/cashflowStatements/netIncome";"noInherit](https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=cashflowStatementHistory%22;%22/quoteSummary/result/cashflowStatementHistory/cashflowStatements/netIncome%22;%22noInherit)"),2,1)