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: 10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4    Statistic    FMM    Blog  

Matrix.JSONRecords

Returns rows as JSON array.

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

Parameters

Parameter Description Example Flags
MatrixRef The matrix reference number. $matrix
FieldNames A list of field names for the JSON. "Model¶Names"
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

Result

Returns JSON text or error.

Description

Returns rows as JSON array.
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 matrix as JSON:

# Matrix as JSON object
Set Variable [ $JSON ; Value: MBS( "Matrix.JSONRecords"; $result; "a¶b¶c" ) ]
Show Custom Dialog [ "Matrix as JSON" ; $JSON ]

See also

FileMaker Magazin

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


Matrix.JSONRecord - Matrix.Max

Feedback: Report problem or ask question.