JSONGetElementsAsVariables ( JSON ; Globals ; Prefix )
Converts JSON to Variables or Global Variables (Supports JSON sub arrays)
Be the first to rate this function Log in to vote
Kyle Williams - Show more from this author
vars = JSONGetElementsAsVariables ( Get(ScriptParameter); 0; "" )
;vars = JSONGetElementsAsVariables ( $window; 0; "window" )
;vars = JSONGetElementsAsVariables ( $position; 0; "window.position" )
* $window (=JSON SubArray)
* $position (=JSON SubArray from within $window )
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
I found Rob Poelking's Custom Function and it worked well but did not really support JSON sub array objects.
I wanted a way to build a formula to extract the JSON as variables and to expand the sub arrays into variables as well.
With using the provided formula, I was able to extract all of the variables from my JSON in a single step.
Thank you Rob for your excellent work on the jsonToVars function.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.