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: 9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5   10.6    Statistic    FMM    Blog  

JSON.Sort

Sorts the JSON array/object.

Parameters

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

Result

Returns JSON code.

Description

Examples

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

• Files.ListAsJSON
• JSON.SortWithEvaluate

Blog Entries

• Sort with evaluate in FileMaker
• With JSON in excellent form
• Neues vom MBS Plugin 9.3
• Whats new in MBS FileMaker Plugin version 9.3
• Neues MBS FileMaker Plugin 9.3 - Über 5900 Funktionen in einem Plugin
• MBS FileMaker Plugin 9.3 - More than 5900 Functions In One Plugin
• JSON Sort
• MBS FileMaker Plugin, version 9.3pr3

FileMaker Magazin

• Ausgabe 5/2020, Seite 18, PDF

Release notes

• Version 10.2
  • Added JSON.SortWithEvaluate function to sort JSON objects or arrays with custom expression.
• Version 9.3
  • Added JSON.Sort function.

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

JSON.SetPathItem   -   JSON.SortWithEvaluate

Feedback: Report problem or ask question.