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
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies