JSONListKeyValuePairs ( json ; separator )

List Key Value pairs from a JSON Object

Be the first to rate this function Log in to vote

Neil Simpson - Show more from this author
Onroute.io
http://www.onroute.io

Sample input:

{"ABC":"123","ZYC":"323"}

Sample output:

ABC-123
ZYC-323

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

While ( 

[ 
~json = json ; 
~key_count = ValueCount ( JSONListKeys ( ~json ; "" ) ) ;
~result = ""
] ;

~key_count > 0 and Left ( JSONListKeys ( ~json ; "" ) ; 1 ) ≠ "?" ; 

[ 
~key_list = JSONListKeys ( ~json ; "" ) ;
~key = GetValue ( ~key_list ; 1 ) ;
~value = JSONGetElement ( ~json ; ~key ) ;
~json = JSONDeleteElement ( ~json ; ~key ) ;
~key_count = ValueCount ( JSONListKeys ( ~json ; "" ) ) ;
~result = List ( ~result ; ~key & separator & ~value )
 ] ; 

~result )

Takes a JSON Object and converts the key value pairs into a list.

Comments

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

JSONListKeyValuePairs ( json ; separator )

Comments

Support this website.

Support this website.