Not sure if this is a bug per se but I’m trying to parse a value from a list in a JSON but am having difficulty referencing part of my request to a cell containing a date. I’m getting a #N/A error message.
The request that’s returning the error message is the following:
=PARSE($B8,"[‘Technical Analysis: SMA’].[’"&D8&"’].['SMA’]”)
D8 contains the date I’m trying to reference.
If I replace “&D8&” by writing the date directly - i.e. so the request reads:
=PARSE($B8,"[‘Technical Analysis: SMA’].[‘2018-08-02’].[‘SMA’]”)
it works completely fine. It also works fine if I populate D8 by parsing a date within the JSON itself - in this instance, I’m using an Alpha Vantage API so can get today’s date by parsing the ‘Last refreshed’ value (but my issue is that the date I want to reference isn’t today’s date).
Is there an easy fix for this?