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

Matrix.JSONRecord

Returns a row as JSON object.

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

Parameters

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.
Pass 4 to get arrays instead of objects for the individual rows.
Pass 8 to get containers as objects with name, size and data entries. (new in v12.1)
1+2 Optional

Result

Returns JSON text or error.

Description

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.

Examples

Query JSON:

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

See also

Release notes

Blog Entries

This function checks for a license.

Created 8th April 2019, last changed 9th May 2022


Matrix.InsertRecordsToSQL - Matrix.JSONRecords