Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


Queries a list of all array entries.

Component Version macOS Windows Linux Server iOS SDK
JSON 4.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "JSON.GetArrayItemsAsList"; json { ; ReturnValues } )   More


Parameter Description Example Flags
json A JSON text or reference. "[1,2,3]"
ReturnValues Available in MBS FileMaker Plugin 8.1 or newer.
Pass 1 to return values instead of keeping strings in quotes.
1 Optional


Returns list or error.


Queries a list of all array entries.
Intended for arrays containing text or numbers.

Broken in version 6.0. Please use 6.1. Version 6.5 and newer doesn't add an extra newline any more.


Query a list from JSON array:

MBS( "JSON.GetArrayItemsAsList"; "[1,2,3]" )

Now a list of strings:

MBS( "JSON.GetArrayItemsAsList"; "[\"Hello\",\"World\",\"Test\"]" )

Now an array with objects:

MBS( "JSON.GetArrayItemsAsList"; "[\"Hello\", \"World\", {\"Hello\": \"test\"}]" )

See also

Release notes

Blog Entries

This function checks for a license.

Created 18th August 2014, last changed 30th January 2018

JSON.GetArrayItems - JSON.GetArrayItemsAsQuickList