Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


Sorts the JSON array/object.

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


Parameter Description Example
json A JSON text or reference. {"key":"value"}


Returns JSON code.


Sorts the JSON array/object.
Use JSON.SortWithEvaluate to sort entries within an array of objects.


Sort an array of numbers:

MBS( "JSON.Sort"; "[9,4,3.2,3.1,123]" )

Sort text values:

MBS( "JSON.Sort"; "[\"123\", \"Hello\", \"FileMaker\", \"World\"]" )

Sort keys in object:

MBS( "JSON.Sort"; "{\"last\":123, \"first\":456}" )

See also

Release notes

Blog Entries

This function checks for a license.

Created 15th June 2019, last changed 29th September 2020

JSON.SetPathItem - JSON.SortWithEvaluate