ListOfJSONArray ( prefix ; theList ; cont ; res )

Make a list of an JSONArray Element of a path

Average rating: 5.0 (1 vote) Log in to vote

Ãngel MartÃnez FernÃ¡ndez - Show more from this author
Lesterius Barcelona
https://www.lesterius.es/

Sample input:

ListOfJSONArray ( "item" ; "0¶1¶2" ; 1 ; "" )

Sample output:

item[0]
item[1]
item[2]

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
* Purpose: Make a list of an JSONArray Element of a path
* Autor: Angel Martinez Fernandez, Atatiki Group
* Version: 1.0
*
* Params:
* -prefix: JSONArray name
* -theList: List of values
* -cont: Recursive number
* -res: Result to return
*
* Vars:
* -toAdd : The new item for -res
* -count : Value count of -theList
*
* Notes: none
*/

Let (
[
count = ValueCount ( theList );
toAdd = prefix & "[" & GetValue ( theList; cont ) & "]";
res = List ( res ; toAdd )
]
;
If (cont < count ; 
ListOfJSONArray ( prefix ; theList ; cont + 1 ; res ) ;
res
)
)

It's like the PrependToList CM, but modified for prepend and append this characters: "[", "]".

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

ListOfJSONArray ( prefix ; theList ; cont ; res )

Comments

Support this website.

Support this website.