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.
If I want the "total cash" for the first year financials of Apple; I have tried this formula:
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.