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.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5   11.0   11.1    Statistic    FMM    Blog  


Returns a row as JSON object.

Component Version macOS Windows Linux Server FileMaker iOS SDK
Matrix 9.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Matrix.JSONRecord"; MatrixRef; Row { ; FieldNames; Flags } )   More


Parameter Description Example Flags
MatrixRef The matrix reference number. $matrix
Row The row you like to get. 1
FieldNames A list of field names for the JSON. "Model¶Names" Optional
Flags The flags for the json creation.
Pass 1 to get all values as text.
Pass 2 to get all dates, times and timestamps in SQL format.
1+2 Optional


Returns JSON text or error.


Returns a row as JSON object.
You provide list of field names, which should be in same order as fields in matrix.
Optionally we can return SQL dates, times and timestamps as SQL format.
Containers are returned as Base64 encoded data.


Query JSON:

Set Variable [ $JSON ; Value: MBS( "Matrix.JSONRecord"; $result; 1; "a¶b¶c" ) ]

See also

Release notes

  • Version 11.1
    • Fixed memory leak in FM.SQL.JSONRecord and Matrix.JSONRecord functions.

Created 8th April 2019, last changed 17th December 2019

Matrix.InsertRecordsToSQL   -   Matrix.JSONRecords

Feedback: Report problem or ask question.

MBS Xojo tutorial videos

Start Chat