Monkeybread Software - MBS FileMaker Plugin: SQL.GetRecordsAsJSON

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

SQL.GetRecordsAsJSON

Queries records of current result set as JSON array.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
SQL	10.2	Yes	Yes	Yes	Yes	Yes

MBS( "SQL.GetRecordsAsJSON"; Command ) More

Parameters

Parameter Description Example

Command The command reference number gained with SQL.NewCommand. $Command

Parameter	Description	Example
Command	The command reference number gained with SQL.NewCommand.	$Command

Result

Returns JSON or error.

Description

Queries records of current result set as JSON array.
Each array entry contains a record converted to JSON.

Dates, Intervals and BLOBs get converted to text. Boolean, Integer, Numeric and Double types are converted to numbers in JSON. Boolean is passed through as boolean. Null or unknown field types are returned as NULL in JSON.

Examples

Show record as JSON:

# Create select and run it
Set Variable [ $Command ; Value: MBS("SQL.NewCommand"; $Connection; "SELECT * FROM Test") ]
# Run it
Set Variable [ $result ; Value: MBS("SQL.Execute"; $Command) ]
If [ $result ≠ "OK" ]
Show Custom Dialog [ "Error: " & $result ]
Else
Show Custom Dialog [ "JSON" ; MBS( "SQL.GetRecordsAsJSON"; $Command ) ]
End If
# Cleanup
Set Variable [ $result2 ; Value: MBS("SQL.FreeCommand"; $Command) ]

Example Databases

SQL to other databases/SQLite fun

Blog Entries

Release notes

Version 10.2
- Added SQL.GetFieldsAsJSON, SQL.GetParamsAsJSON, SQL.GetRecordsAsJSON and SQL.SetParamsWithJSON functions.

Created 11st March 2020, last changed 11st March 2020

SQL.GetParamsAsJSON - SQL.GetRecordsAsText

Feedback: Report problem or ask question.