ScriptResultGetElement ( keyOrIndexOrPath )

Get a key, index, or path from a JSON formatted script result

Be the first to rate this function Log in to vote

Jason Wood - Show more from this author
Define Database
https://www.definedatabase.com

Sample input:

ScriptResultGetElement ( "hello" )

Sample output:

world
//assuming the output of Get ( ScriptResult ) is { "hello" : "world" }

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

/*
==================================================================
PURPOSE:
       Just like JSONGetElement but source is Get(ScriptResult)
       
PARAMETERS:
       keyOrIndexOrPath | text | The JSON key, index, or path to the target element.

RETURNS:
       (string) Element at specified key, index, or path.

NOTES & DEPENDENCIES:
       None

CONTRIBUTORS
       JW / Jason Wood / Define Database / www.definedatabase.com

CHANGELOG
       2020-06-02 JW Created
==================================================================
*/

If ( Left ( JSONGetElement ( Get ( ScriptResult ) ; "xalsdjfaluksdfjlnzvoiysehsz" ) ; 3 ) ≠ "? *" ; //JSON is valid
JSONGetElement ( Get ( ScriptResult ) ; keyOrIndexOrPath ) ;
"" )

Returns empty if the key, index, or path is empty, missing, or if the script result is not valid JSON, otherwise, returns the value at the specified key, index, or path.

Comments

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

ScriptResultGetElement ( keyOrIndexOrPath )

Comments

Support this website.

Support this website.