Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 9.0   9.1   9.2   9.3   9.4   9.5   10.0   10.1   10.2   10.3    Statistic  

JSON.GetArrayItemsAsList

Queries a list of all array entries.

Parameters

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

Result

Returns list or error.

Description

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

• JSON.GetArrayItem

Blog Entries

• With JSON in excellent form
• 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

Release notes

• Version 8.3
  • Fixed crash in JSON.GetArrayItemsAsList for undefined values.
• Version 8.1
  • Added ReturnValues parameter for JSON.GetArrayItemsAsList function.

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

JSON.GetArrayItem   -   JSON.GetArrayPathItems

Feedback: Report problem or ask question.