Reference > Functions reference > JSON functions > JSONFormatElements

JSONFormatElements

Formats elements in JSON data to make them easier to read.

Format

JSONFormatElements ( json )

Parameters

json - any text expression or field that contains a JSON object or array.

Data type returned

text

Originated in

FileMaker Pro 16.0

Description

This function parses the text in the json parameter. If successful, this function returns json with tab and line ending characters added and with JSON objects sorted alphabetically by key. Otherwise, this function returns "?" followed by an error message (see Handling errors in JSON data).

Notes

•This function is not supported in runtime solutions and returns "?".

Example 1

JSONFormatElements ( "{ \"a\" : { \"lnk\" : false, \"id\" : 12 } }" ) returns

{
	"a" : 
	{
		"id" : 12,
		"lnk" : false
	}
}