json.unformat ( jsonEntity )

Undoes `JSONFormat()` function by re-interpreting the JSON entity from the root node. Useful for building JSONL (https://jsonlines.org) formatted docs.

Be the first to rate this function Log in to vote

Cristos Lianides-Chin - Show more from this author
Codence
https://www.codence.com

Sample input:

json.unformat ( JSONFormatElements ( JSONSetElement ( "{}" ; [ "foo" ; "bar" ; JSONString ] ; ["foo2" ; "Foo¶Bar" ; JSONString ] ) ) )

Sample output:

{"foo":"bar","foo2":"Foo\rBar"}

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

/** Undoes `JSONFormat()` function by re-interpreting the JSON entity from the
 root node.  Useful for building JSONL (https://jsonlines.org) formatted docs.

json.unformat ( 
    jsonEntity  // (string) A valid JSON entity (e.g., object or array)
)

## USAGE
```
Loop
    Exit Loop If [ $i > Get ( FoundCount ) ]
    Set Variable [ $jsonEntity ; JSONSetElement ( "{}" ; [ "foo" ; Table::bar ; JSONString ] ) ]
    Insert Calculated Result [ $longListOfJsonEntities ; json.unformat ( $jsonEntity ) ]
    Set Variable [ $i ; $i + 1 ]
    Go To Record [ Next ]
End Loop
```
 
## REQUIRES
 - None

## CONTRIBUTORS
 - CLC | Cristos Lianides-Chin | cristos.lianides-chin@codence.com

## CHANGELOG
### v1.0 | CLC | 2024-09-09
 - Function created

**/

Let (
[   ~json.unformat.profiling.startMs = Get ( CurrentTimeUTCMilliseconds )

    // Return the result
;   ~returnValue = JSONGetElement ( jsonEntity ; "" )

    // Capture profiling data
;   ~json.unformat.profiling.stopMs = Get ( CurrentTimeUTCMilliseconds )
;   ~json.unformat.profiling.durationMs = ~json.unformat.profiling.stopMs - ~json.unformat.profiling.startMs
;   $$~json.unformat.durationMs = If ( ~json.unformat.profiling.durationMs > 200 ; ~json.unformat.profiling.durationMs ; "" )
]
;   ~returnValue
)

When using JSONL format (e.g., for performance when creating/consuming a list of JSON entities) it is imperative that each line be a properly formatted JSON entity. This is easily accomplished in FileMaker by using JSONGetElement ( $jsonEntity ; "" ), which just references the root node of the entity. This custom function is just syntactic sugar for that JSONGeElement pattern.

See also: https://jsonlines.org

Comments

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

json.unformat ( jsonEntity )

Comments

Support this website.

Support this website.