Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 10.5 11.0 11.1 11.2 11.3 11.4 11.5 12.0 12.1 12.2 Statistic FMM Blog
Returns rows as JSON array.
|Matrix||9.2||✅ Yes||✅ Yes||✅ Yes||✅ Yes||✅ Yes||Paid|
|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.
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)
Returns JSON text or error.
DescriptionReturns 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.
Query matrix as JSON:
- Version 12.2
- Version 12.1
Created 8th April 2019, last changed 9th May 2022
Feedback: Report problem or ask question.