AnsweredAssumed Answered

Is it possible to use a literal dot in a JSON key with FileMaker's JSON parsing functions?

Question asked by jbarnum on Oct 20, 2017
Latest reply on Nov 14, 2017 by beverly

I am trying to access a REST web service where the keys have dots in the name. FileMaker interprets a dot in a key name to indicate a sub-element. Is there any way to escape the dot so that FileMaker treats it literally instead of as a separator?

 

For instance, if I have JSON like this:

 

{

     "value1": "Red",

     "value_1": "Green",

     "value.1": "Blue"

}

 

this works: JSONGetElement ( $json ; "value1" )

this works: JSONGetElement ( $json ; "value_1" )

this fails (returns an empty value): JSONGetElement ( $json ; "value.1" )

this also fails (returns an empty value): JSONGetElement ( $json ; "value\.1" )

Outcomes