JSON.URLParameters ( JSONpayload )

Returns JSON as url parameters

Be the first to rate this function Log in to vote

Jonni™ - Show more from this author

Sample input:

RectangleArea ( 2 ; 3 )

Sample output:

amount=100&checksum=CA2203648BEBFF7DE33581B0D25F2855&id=205C18A1-7BAF-413D-BB1F-89523DB504A9&paid=1

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

While ( [ 

	~object = JSONpayload ;
	~count = ValueCount ( JSONListKeys ( ~object ; "" ) ) ;
	~key = "" ;
	~value = "" ;
	~result = "" ;
	~i = 1

] ; 

	~i ≤ ~count

; [ 

	~key = GetValue ( JSONListKeys ( ~object ; "" ) ; ~i ) ;
	~value = Substitute ( JSONGetElement ( ~object ; ~key ) ; [ " " ; "20%" ] ; [ "<" ; "%3C" ] ; [ ">" ; "%3E" ] ; [ "#" ; "23%" ] ; [ "%" ; "25%" ] ; [ "+" ; "%2B" ] ; [ "{" ; "%7B" ] ; [ "}" ; "%7D" ] ; [ "|" ; "%7C" ] ; [ "\\" ; "%5C" ] ; [ "^" ; "%5E" ] ; [ "~" ; "%7E" ] ; [ "[" ; "%5B" ] ; [ "]" ; "%5D" ] ; [ "‘" ; "60%" ] ; [ ";" ; "%3B" ] ; [ "/" ; "%2F" ] ; [ "?" ; "%3F" ] ; [ ":" ; "%3A" ] ; [ "@" ; "40%" ] ; [ "=" ; "%3D" ] ; [ "&" ; "26%" ] ; [ "$" ; "24%" ] ) ;
	~result = List ( ~result ; ~key & "=" & ~value ) ;
	~i = ~i + 1

] ; 

	Substitute ( ~result ; "¶" ; "&" ) 

)
// Returns URL parameters as JSON
// Written by: jonni@me.com
// V 1.2

Returns JSON as url parameters

Comments

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

JSON.URLParameters ( JSONpayload )

Comments

Support this website.

Support this website.