URLParameters.JSON ( payload )

Returns url parameter format as JSON

Be the first to rate this function Log in to vote

Jonni™ - Show more from this author

Sample input:

{"amount":100,"checksum":"CA2203648BEBFF7DE33581B0D25F2855","id":"205C18A1-7BAF-413D-BB1F-89523DB504A9","paid":true}

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 ( [ 

	~payload = payload ;
	~array = Substitute ( ~payload ; "&" ; "¶" ) ;
	~count = ValueCount ( ~array ) ;
	~pSet = "" ;
	~jType = "" ;
	~result = "" ;
	~i = 1


] ; 

	~i ≤ ~count

; [ 

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

		GetValue ( ~pSet ; 2 ) = "true" ; 5 ;
		GetValue ( ~pSet ; 2 ) = "false" ; 5 ;
		Filter ( GetValue ( ~pSet ; 2 ) ; ",.0123456789" ) = GetValue ( ~pSet ; 2 ) ; 2 ;
		1

	) ;

	~result = JSONSetElement ( ~result ; GetValue ( ~pSet ; 1 ) ; GetValue ( ~pSet ; 2 ) ; ~jType ) ;
	~i = ~i + 1

] ; 

	~result

)

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

Returns url parameter format as JSON

Comments

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

URLParameters.JSON ( payload )

Comments

Support this website.

Support this website.