| 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. If empty, we use column names, if you have some. (since 14.3) |
"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. 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
- Version 14.3
- Changed Matrix.JSONRecord and Matrix.JSONRecords to take field names from column names, if you have some and you don't pass field names.
- Version 14.2
- Added firstRow and lastRow parameter to Matrix.JSONRecords function.
- Added flag 16 for Matrix.JSONRecords to include field names as first row if outputting arrays.
- Version 12.2
- Added AsArray flag 4 for Matrix.JSONRecord and Matrix.JSONRecords functions.
- Version 12.1
- Added flag value 8 for FM.SQL.JSONColumn, Matrix.JSONRecord, Matrix.JSONRecords, FM.SQL.JSONRecord and FM.SQL.JSONRecords to return containers as JSON objects with data, size and name.
- Version 11.1
- Fixed memory leak in FM.SQL.JSONRecord and Matrix.JSONRecord functions.
Blog Entries
- MBS FileMaker Plugin, version 14.3pr2
- CSV in FileMaker with MBS FileMaker Plugin
- MBS FileMaker Plugin, version 12.2pr6
- MBS FileMaker Plugin, version 11.1pr2
This function checks for a license.
Created 8th April 2019, last changed 7th June 2024
