How to escape period in tFileInputJSON JSONPath query

[Anonymous]

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?

[vapukov]

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