Forum Discussion
RayMaN1
Jan 14, 2019Copper Contributor
How to filter JSON data to a specific result?
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,
1 Reply
Sort By
- swells0244
Microsoft
Please note that the IEX Cloud API has been shut down as of August 2024: IEX Cloud | Important Update
Excel WEBSERVICE is working as expected, but the source data is gone.