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.<\/p>\n
JSONfromGET ( url ) =<\/strong><\/p>\n \/\/ Custom Function to turn variables returned as GET into json Let([ \/\/ find the last key,value set \/\/ determine if this is the first loop \/\/ if there are more variables to grab, run the function again ];<\/p>\n result 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. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-3700","post","type-post","status-publish","format-standard","hentry","category-custom-functions"],"_links":{"self":[{"href":"https:\/\/sarcasolutions.com\/index.php\/wp-json\/wp\/v2\/posts\/3700","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sarcasolutions.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sarcasolutions.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sarcasolutions.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sarcasolutions.com\/index.php\/wp-json\/wp\/v2\/comments?post=3700"}],"version-history":[{"count":4,"href":"https:\/\/sarcasolutions.com\/index.php\/wp-json\/wp\/v2\/posts\/3700\/revisions"}],"predecessor-version":[{"id":3708,"href":"https:\/\/sarcasolutions.com\/index.php\/wp-json\/wp\/v2\/posts\/3700\/revisions\/3708"}],"wp:attachment":[{"href":"https:\/\/sarcasolutions.com\/index.php\/wp-json\/wp\/v2\/media?parent=3700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sarcasolutions.com\/index.php\/wp-json\/wp\/v2\/categories?post=3700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sarcasolutions.com\/index.php\/wp-json\/wp\/v2\/tags?post=3700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n\/\/ Parameter:
\n\/\/url : the url containing the get variables returned by a web server. From a webviewer, you can use
\n\/\/ GetLayoutObjectAttribute ( “nameofwebviewer” ; “source” ) to get the url<\/p>\n
\n\/\/ count how many variables are in the url by counting “=”
\ncount = PatternCount ( url; “=”);
\nle = Length(url);
\nlast = Position ( url ; “=” ;le ; -1 );
\nlastsep = Position (url; “&”; le; -1 );
\nstart = Position (url; “?”; 0; 1);<\/p>\n
\nkey = If ( count = 1; Middle (url; start + 1; last – start -1); Middle (url; lastsep + 1; last – lastsep – 1));
\nvalue = Right ( url; Length(url) – last);
\ntype = If (Length(value) = Length(GetAsNumber(value)); “JSONNumber”; JSONString);<\/p>\n
\nisJSON = If (Left(url; 1) = “{“; 1 ; 0);
\nJSONstart = If (isJSON; Left(url; Position (url; “}”; le; -1)) ;”{}”);
\n\/\/ add the key, value pair to the json
\njson = JSONSetElement ( JSONstart ; key ; value ; type );
\n\/\/ strip the key, value pair from the url
\nnewurl = Middle (url; start; lastsep – start);<\/p>\n
\nresult = If ( count > 1; JSONfromGET(json & newurl) ;
\njson)<\/p>\n
\n)<\/p>\n","protected":false},"excerpt":{"rendered":"