If you’ve ever worked with Filemaker’s Insert From URL function, you may have experienced a situation where the external site you are working with insists on returning information as GET (as opposed to POST). This is a custom function that simplifies grabbing the variables returned and formatting them as JSON.
JSONfromGET ( url ) =
// Custom Function to turn variables returned as GET into json
// Parameter:
//url : the url containing the get variables returned by a web server. From a webviewer, you can use
// GetLayoutObjectAttribute ( “nameofwebviewer” ; “source” ) to get the url
Let([
// count how many variables are in the url by counting “=”
count = PatternCount ( url; “=”);
le = Length(url);
last = Position ( url ; “=” ;le ; -1 );
lastsep = Position (url; “&”; le; -1 );
start = Position (url; “?”; 0; 1);
// find the last key,value set
key = If ( count = 1; Middle (url; start + 1; last – start -1); Middle (url; lastsep + 1; last – lastsep – 1));
value = Right ( url; Length(url) – last);
type = If (Length(value) = Length(GetAsNumber(value)); “JSONNumber”; JSONString);
// determine if this is the first loop
isJSON = If (Left(url; 1) = “{“; 1 ; 0);
JSONstart = If (isJSON; Left(url; Position (url; “}”; le; -1)) ;”{}”);
// add the key, value pair to the json
json = JSONSetElement ( JSONstart ; key ; value ; type );
// strip the key, value pair from the url
newurl = Middle (url; start; lastsep – start);
// if there are more variables to grab, run the function again
result = If ( count > 1; JSONfromGET(json & newurl) ;
json)
];
result
)