cf_jsonFormat ( json ; indent )

replace tab in jsonFormateElement function, make json more readable

Be the first to rate this function Log in to vote

jeff liao - Show more from this author

Sample input:

cf_jsonFormat ( Get ( InstalledFMPluginsAsJSON ) ; " " )

Sample output:

{
"APIVers" : 1,
"plugins" :
[
{
"description" : "Version: 4.1.4\n\nThis plug-in provides additional functionality for BaseElements from Goya.",
"filepath" : "filemac:/OS X/Users/jsl/Library/Application Support/FileMaker/FileMaker Pro/19.0/Extensions/BaseElements.fmplugin/",
"id" : "GyBE",
"name" : "BaseElements",
"state" : "Enabled",
"version" : "4.1.4"
},
{
"description" : "The MBS Plugin extends FileMaker with thousands of functions.\n\nVersion 11.2.0.09, build 5391 from May 17 2021.\n\nSee monkeybreadsoftware.com for more information.",
"filepath" : "filemac:/OS X/Users/jsl/Library/Application Support/FileMaker/FileMaker Pro/19.0/Extensions/MBS.fmplugin/",
"id" : "MBSP",
"name" : "MBS Plug-In",
"state" : "Enabled",
"version" : "11.2.0.09"
}
]
}

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

/*
    Purpose: 
        replace tab in jsonFormateElement function, make json more readable 
    Format:
        cf_jsonFormat ( json ; indent)
        json: json data
        indent: string to replace tab, char (9)
    Dependencies:
    Recursive:
    Notes:
        jsonFormatElements use tab as a spacer, if you think it's too wide to view,
        you can this function to shrink the space
        or you can use another chacacters to ruin the json
    By:Jeff Liao
    History: 20210529
*/
if (
    left ( JSONFormatElements ( json ); 1 ) = "?";
    "";
    Substitute ( JSONFormatElements(json) ; Char(9) ; indent )
)

jsonFormatElements use tab as a spacer, if you think it's too wide to view,
you can this function to shrink the space
or you can use another chacacters to ruin the json

Comments

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

cf_jsonFormat ( json ; indent )

Comments

Support this website.

Support this website.