JSON.GetArrayItemsAsQuickList
-----------------------------

Queries array values as QuickList.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [JSON](component_JSON.md) | [13.3](newinversion133.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "JSON.GetArrayItemsAsQuickList"; JSON ) 

**MBS**( **"JSON.GetArrayItemsAsQuickList";** /\* Queries array values as QuickList. \*/  
**$JSON**) /\* A JSON text or reference.e.g. "\[{\\"key\\": 1}\]" \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| JSON | A JSON text or reference. | "\[{\\"key\\": 1}\]" |

### Result

Returns quicklist refernece number or error.

### Description

Queries array values as QuickList.  
Creates a new QuickList and puts each JSON there into an entry of the QuickList.  
  
See [QuickList.JoinJSON](QuickListJoinJSON.md) function to join back the JSON.  
### Examples

Try the function:

 Let(\[  
list = MBS ( "JSON.GetArrayItemsAsQuickList"; "\[{\\"id\\": 1},{\\"id\\": 2},{\\"id\\": 3}\]" );  
text = MBS ( "[QuickList.GetList](QuickListGetList.md)"; list );  
r = MBS ( "[QuickList.Release](QuickListRelease.md)"; list )  
\]; text)  
Filter JSON items:

 Set Variable \[ $json ; Value: "\[{\\"id\\": 1},{\\"id\\": 2},{\\"id\\": 3}\]" \]   
\# turn into a list   
Set Variable \[ $list ; Value: MBS ( "JSON.GetArrayItemsAsQuickList"; $json ) \]   
\#   
\# now loop over entries to filter   
Set Variable \[ $n ; Value: MBS ( "[QuickList.Count](QuickListCount.md)"; $list ) \]   
If \[ $n > 0 \]   
 Loop  
 # get next item  
 Set Variable \[ $n ; Value: $n - 1 \]   
 Set Variable \[ $item ; Value: MBS ( "[QuickList.GetValue](QuickListGetValue.md)"; $list ; $n ) \]   
 #   
 # if meets criteria, then remove it  
 If \[ JSONGetElement ( $item ; "id" ) = 2 \]   
 Set Variable \[ $r ; Value: MBS ( "[QuickList.Remove](QuickListRemove.md)"; $list ; $n ) \]   
 End If  
 #   
 # next  
 Exit Loop If \[ $n ≤ 0 \]   
 End Loop  
End If  
\#   
Set Variable \[ $json ; Value: MBS ( "[QuickList.JoinJSON](QuickListJoinJSON.md)"; $list ) \]   
Show Custom Dialog \[ "after filter" ; $json \]   
\#   
Set Variable \[ $r ; Value: MBS ( "[QuickList.Release](QuickListRelease.md)"; $list ) \]  
### See also

- [JSON.GetArrayItem](JSONGetArrayItem.md)
- [JSON.GetArrayItems](JSONGetArrayItems.md)
- [List.GetValue](ListGetValue.md)
- [List.Remove](ListRemove.md)
- [QuickList.Count](QuickListCount.md)
- [QuickList.GetList](QuickListGetList.md)
- [QuickList.GetValue](QuickListGetValue.md)
- [QuickList.JoinJSON](QuickListJoinJSON.md)
- [QuickList.Release](QuickListRelease.md)
- [QuickList.Remove](QuickListRemove.md)

### Release notes

- **Version 13.3**
    - Added [JSON.GetArrayItemsAsQuickList](https://www.mbsplugins.eu/JSONGetArrayItemsAsQuickList.shtml) and [QuickList.JoinJSON](https://www.mbsplugins.eu/QuickListJoinJSON.shtml) functions.

### Blog Entries

- [QuickList.JSONArray vs. QuickList.JoinJSON](https://www.mbsplugins.de/archive/2024-08-09/QuickListJSONArray_vs_QuickLis/monkeybreadsoftware_blog_filemaker)
- [New in MBS FileMaker Plugin 13.3](https://www.mbsplugins.de/archive/2023-07-25/New_in_MBS_FileMaker_Plugin_13/monkeybreadsoftware_blog_filemaker)
- [Neues MBS Plugin 13.3 für Claris FileMaker](https://www.mbsplugins.de/archive/2023-07-18/Neues_MBS_Plugin_133_für_Clar/monkeybreadsoftware_blog_filemaker)
- [MBS Plugin 13.3 for Claris FileMaker](https://www.mbsplugins.de/archive/2023-07-18/MBS_Plugin_133_for_Claris_File/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 13.3pr1](https://www.mbsplugins.de/archive/2023-06-01/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)

This function checks for a license.

Created 31st May 2023 , last changed 14th December 2023

  
[JSON.GetArrayItemsAsList](JSONGetArrayItemsAsList.md) - [JSON.GetArrayPathItems](JSONGetArrayPathItems.md)

[HTML Version](JSONGetArrayItemsAsQuickList.shtml)