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.JSONRecord
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
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. |
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
Created 8th April 2019, last changed 17th December 2019
Matrix.InsertRecordsToSQL - Matrix.JSONRecords
Feedback: Report problem or ask question.
Links
MBS Xojo PDF Plugins
