Brian Dunning's FileMaker Custom Functions

@JSONFormatElements ( json )

Formats JSON data in two columns: elements hierarchy and values. Version 2.1

  Average rating: 3.0 (1 vote) Log in to vote

Alex Zueiv   Alex Zueiv
Tashkent

Share on Facebook Share on Twitter

  Sample input:
@JSONFormatElements ( "[{\"exclamation\":\"Hello\"},[{\"punctuation\":\" \"},[{\"noun\":\"World\"},[{\"punctuation\":\"!\"}]]]]" )
  Sample output:
[
    {
        "exclamation"               : "Hello"
    },
    [
        {
            "punctuation"           : " "
        },
        [
            {
                "noun"              : "World"
            },
            [
                {
                    "punctuation"   : "!"
                }
            ]
        ]
    ]
]

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This CF is intended for developers. It allows you to visually separate the data from the document structure. This makes working with JSON API more comfortable.

Required FM16+ (no runtimes).

v2.1 fix: Added 5000 ms time limit to prevent a hang on a large document.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.