We need a function to validate JSON strings - the JSONFormatElements function is not enough!
Currently, we are forced to use the JSONFormatElements function as a workaround to test if JSON is valid, HOWEVER, the JSONFormatElements function cannot deal with non-unique keys.
Sadly, the FM Data API returns JSON with multiple keys, IF a field appears twice on the query layout.
...and as far as I know, a JSON object with two identical keys is NOT invalid JSON, in itself, just not supported by the JSON functionality in FileMaker
Give us a function to validate JSON.
- readable code
- easier to use
- can validate the JSON from the FM Data API
- JSON validation
- FM Data API