Home

How to filter JSON data to a specific result?

%3CLINGO-SUB%20id%3D%22lingo-sub-314720%22%20slang%3D%22en-US%22%3EHow%20to%20filter%20JSON%20data%20to%20a%20specific%20result%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314720%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20I%20am%20trying%20to%20get%20JSON%20data%20from%20the%20IEX%20API%20and%20have%20used%20the%26nbsp%3BWEBSERVICE()%20function%2C%20but%20I%20can't%20seem%20to%20filter%20it%20down%20to%20the%20values%20I%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CP%3EIf%20I%20want%20the%20%22total%20cash%22%20for%20the%20first%20year%20financials%20of%20Apple%3B%20I%20have%20tried%20this%20formula%3A%3C%2FP%3E%3CP%3E%3DVALUE(WEBSERVICE(%22%3CA%20href%3D%22https%3A%2F%2Fapi.iextrading.com%2F1.0%2Fstock%2FAAPL%2Ffinancials%3Fperiod%3Dannual%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fapi.iextrading.com%2F1.0%2Fstock%2FAAPL%2Ffinancials%3Fperiod%3Dannual%3C%2FA%3E%3CSTRONG%3E%3CU%3E%2F0%2F%3C%2FU%3E%3C%2FSTRONG%3Etotalcash%22))%3C%2FP%3E%3CP%3EWhich%20gives%20an%20error.%20I%20think%20the%20incorrect%20part%20is%20the%20%22%2F0%2F%22%20but%20I%20don't%20see%20how%20to%20specify%20which%20year%20I%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20really%20appreciated.%3C%2FP%3E%3CP%3EThanks%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-314720%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EJson%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
RayMaN1
Visitor

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, 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies