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: 11.2   11.3   11.4   11.5   12.0   12.1   12.2   12.3   12.4   12.5    Statistic    FMM    Blog  


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

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

JSON.SetPathItem - JSON.SortWithEvaluate

Feedback: Report problem or ask question.

Start Chat