Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 12.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4   13.5    Statistic    FMM    Blog  


Returns pretty printed JSON for the given JSON text.

Component Version macOS Windows Linux Server iOS SDK
JSON 4.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "JSON.Format"; json )   More


Parameter Description Example
json A JSON text or reference. "[1,2,3]"


Returns JSON code.


Returns pretty printed JSON for the given JSON text.


Format some object:

Set Variable [$json; Value:MBS( "JSON.Format"; "{\"Hello\": \"World\"}" )]
Show Custom Dialog [$json]

Parse some JSON, display it formatted and release:

Set Variable [$json; Value:MBS( "JSON.Parse"; "{\"Hello\": \"World\"}" )]
Show Custom Dialog [$json; MBS("JSON.Format"; $json)]
Set Variable [$r; Value:MBS( "JSON.Release"; $json)]

Format various JSON entries:

MBS( "JSON.Format";
\"Hello\": \"World\",
\"num\": 123,
\"value\": 123.456,
\"object\": {\"Hello\": \"World\"},
\"empty\": null,
\"array\": [1,2,3]}")

Example result:
{ "Hello": "World", "num": 123, "value": 123.456, "object": { "Hello": "World" }, "empty": null, "array": [1, 2, 3] }

Colorize and format in Auto-Enter calculation:

Let ( [
jsonFormatted = MBS("JSON.Format"; Self);
jsonFormatFailed = MBS("IsError");
jsonText = If(jsonFormatFailed; Self; jsonFormatted);
result = MBS("JSON.Colorize"; jsonText)
]; result )

// put this calculation into a field, so the field gets formated and colorized whenever the field is changed and the record gets commited.

Format JSON removes unicode escapes:

MBS( "JSON.Format"; "\"\uD83C\uDF4E\"")

Example result: "🍎"

See also

Release notes

  • Version 11.2
    • Fixed JSON.Format to not return reference number for JSON reference numbers as input, broken in 11.1.
  • Version 9.4
    • Improved pretty formatting for JSON arrays in JSON.Format.

Example Databases

Blog Entries

This function checks for a license.

Created 18th October 2014, last changed 31st January 2023

JSON.Flatten - JSON.GetArrayItem

💬 Ask a question or report a problem