JSONAllKeys ( json ; prefix ; cont ; res )

Get all keys of a JSON

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:

JSONAllKeys( "{\"popup\":{\"menuitem\":[{\"onclick\":\"OpenDoc()\"}]}}" ; "." ; 1 ; "" )

Sample output:

.popup
.popup.menuitem
.popup.menuitem[0]
.popup.menuitem[0].onclick

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

/*
* Purpose: Get all keys of a JSON
* Autor:      Angel Martinez Fernandez, Atatiki Group
* Version:   2.0
*
* Uses: PrependToList () , ListOfJSONArray () , OriginalToNatural () , NaturalToOriginal ()
*
* Params:
*  -json : JSON Element
*  -prefix: Path of the element
*  -cont: Recursive number
*  -res: Result to return
*
* Vars:
*  -element : JSON Element of -prefix
*  -error : Error code
*  -isArray: For know if it is JSONArray
*  -keys : List of keys of -prefix
*  -items : -keys prepending -prefix at the start separated by "."
*  -count : Value count of -res
*
* Notes:     none
*/

Let ( [

	element = JSONFormatElements ( JSONGetElement( json ; prefix ) );
	error = Case (
		Left( json ; 1 )="?" or IsEmpty( json ) ; 1 ;
		0
	);
        isArray = If( Left( element ; 1 ) = "[" ; 1 ; 0 );
	keys = JSONListKeys( json ; prefix );
	items = If ( not IsEmpty ( keys ) ; If ( isArray = 1 ; ListOfJSONArray ( prefix ; keys ; 1 ; "" ) ; PrependToList ( prefix ; keys ; 1 ; "" ) ) ; "" );
	res = If ( not IsEmpty ( keys ) ; List ( res ; items ) ; res) ;
	count = ValueCount ( res );
	prefix = GetValue ( res ; cont );
	cont = cont + 1

] ;

If( error ≠ 0 ; 
    "Empty or invalid JSON";
    If( cont ≤ (count + 1) ; 
        JSONAllKeys ( json ; prefix ; cont ; res )  ; 
        NaturalToOriginal ( SortValues ( OriginalToNatural ( res ; 1 ) ; 1 ) ; 1 )
    )
)

)

Uses: PrependToList () , ListOfJSONArray () , OriginalToNatural () , NaturalToOriginal ()
Currently JSONListKeys (), get the keys of a path, so using it we can get all the keys from a starting point to an end.

Comments

		oliver Jul 27, 2022
Hi Angel, i can run this function but it only return the first item (ie. .popup) but the other three items in your example.

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

JSONAllKeys ( json ; prefix ; cont ; res )

Comments

Support this website.

Support this website.