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:
11.1
11.2
11.3
11.4
11.5
12.0
12.1
12.2
12.3
12.4
Statistic
FMM
Blog
JSON.GetArrayItemsAsList
Queries a list of all array entries.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| JSON | 4.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameters
| 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 |
Result
Returns list or error.
Description
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.
Examples
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
- Version 8.3
- Fixed crash in JSON.GetArrayItemsAsList for undefined values.
- Version 8.1
- Added ReturnValues parameter for JSON.GetArrayItemsAsList function.
Blog Entries
- MBS FileMaker Plugin, version 8.3pr1
- MBS FileMaker Plugin, version 8.1pr1
- MBS FileMaker Plugin, version 6.5pr8
- MBS FileMaker Plugin, version 6.1pr1
- MBS FileMaker Plugin, version 5.2pr2
- MBS Filemaker Plugin, version 4.2pr4
FileMaker Magazin
Created 18th August 2014, last changed 30th January 2018
JSON.GetArrayItems - JSON.GetArrayPathItems
Feedback: Report problem or ask question.
