JSON

JSON all things!

BoxLang supports native JSON support via several key functions and some member functions.

Serialize

BoxLang gives us the jsonSerialize() function to convert any piece of data to its JSON representation (https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/conversion/jsonserialize)

jsonSerialize(
 var
 [, serializeQueryByColumns = false ]
 [, useSecureJSONPrefix = false ]
 [, useCustomSerializer = false ]
)

Pass in any complex or simple variable to the var argument and JSON will be produced:

person = { name = "Luis Majano", company = "Ortus Solutions", year = 2006};
writeOutput( jsonSerialize( person ) );

You can even use the toJSON() member function:

person = { name = "Luis Majano", company = "Ortus Solutions", year = 2006};
writeOutput( person.toJSON() );

Key Casing

By default BoxLang will convert the keys in a struct to uppercase in the result JSON document:

person = { name = "Luis Majano", company = "Ortus Solutions", year = 2006};
writeOutput( jsonSerialize( person ) );

// Will become
{ "NAME" : "Luis Majano", "COMPANY" : "Ortus Solutions", "YEAR" : 2006 }

If you want to preserve the key casing then wrap them in double/single quotes and define the case:

person = {
    'Name' = "Luis Majano",
    'company' = "Ortus Solutions",
    'year' = 2006
};

// Will become
{ "Name" : "Luis Majano", "company" : "Ortus Solutions", "year" : 2006 }

Possible Casting Issues

BoxLang may incorrectly serialize some strings if they can be automatically converted into other types, like numbers or booleans. One workaround is to use a class with property to specify types. Another workaround is to prepend Chr(2) to the value and it will be forced to a string, however, that is an unofficial/undocumented workaround. A more formal workaround is to call setMetadata() as a member function on a struct to force a type:

myStruct = { "zip"="00123" };
myStruct.setMetadata( { "zip": "string" } );
writeOutput( jsonSerialize(myStruct) );

Deserialize

The inverse of serialization is deserialization (https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/conversion/jsondeserialize). BoxLang gives you the jsonDeserialize() function that will take a JSON document and produce native BoxLang data structures for you.

jsonDeserialize(
 json
 [, strictMapping = true ]
 [, useCustomSerializer = false ]
)

Just pass a JSON document, and off we go with native structs/arrays/dates/strings and booleans.

if( isJson( mydata ) ){
    return jsonDeserialize( data );
}

person = jsonDeserialize( '{"company":"Ortus","name":"Mr OrtusMan"}' );
writeOutput( person.company );

This function can also be used as a member function in any string literal:

var deserializedData = myjsonString.jsonDeserialize();
var data = '[]'.jsonDeserialize();

Is this JSON?

BoxLang has a function to test if the incoming string is valid JSON (https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/decision/isjson) or not: isJSON()

isJSON( "[ 1, 2, 3 ]" )

Last updated

Logo

Copyright & Register Trademark by Ortus Solutions, Corp & Ortus Software, LLC