JSON validate function needed

Idea created by mrwatson-gbs on May 15, 2017
    Active
    Score18

    Issue

     

    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

     

     

    Idea

     

    Give us a function to validate JSON.

     

    Benefits

     

    • readable code
    • easier to use
    • can validate the JSON from the FM Data API

     

    Use Cases

     

    • JSON validation
    • FM Data API