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
Matrix.JSONRecords
Returns rows as JSON array.
| Component | Version | macOS | Windows | Linux | Server | FileMaker 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.
Links
MBS Xojo blog
