How to filter JSON data to a specific result?

Copper Contributor

Hi all, I am trying to get JSON data from the IEX API and have used the WEBSERVICE() function, but I can't seem to filter it down to the values I need.

 

For example:

If I want the "total cash" for the first year financials of Apple; I have tried this formula:

=VALUE(WEBSERVICE("https://api.iextrading.com/1.0/stock/AAPL/financials?period=annual/0/totalcash"))

Which gives an error. I think the incorrect part is the "/0/" but I don't see how to specify which year I want.

 

Any help is really appreciated.

Thanks, 

0 Replies