JSON validate function needed

Idea created by mrwatson-gbs on May 15, 2017



    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


    Use Cases


    • JSON validation
    • FM Data API