Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 questions regarding the tFileInputJSON :
(1)
I want to extract data from the JSON file. But the JSONPath query is still read "dot" at the "1. open" as one of the syntax. Is there any way for me to extract the data from JSON file with the dot at "1. open" ?
(2)
I want to select only the data from the first child. Besides using [0], is there any other way to do it?
Hi
the problem not with dot (also not good, but not main issue there) - main problem spaces in the names
for example, if you change original json to:
{ "TimeSeriesDaily":{ "2019-04-16":{ "1.Open":"132.2600", "2.Close":"132.2600", "3.Adj":"132.2600"} } }
and correct JSON PATH:
result will be expected:
But in any case - and spaces not supported by many programms