JSONKeyExists ( json ; keyOrIndexOrPath )

Determine if a key exists in a JSON object (even if it is empty)

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:

JSONKeyExists ( "{\"test\":\"\"}" ; "test" )

Sample output:

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

/*
==================================================================
PURPOSE:
       Check if specified key exists at specified keyOrIndexOrPath
       
PARAMETERS:
       json | string
       keyOrIndexOrPath | string | path to look in, including the key to check for

RETURNS:
       (bool) True or False

NOTES & DEPENDENCIES:
       None

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

CHANGELOG
       2019-10-19 JW Created
       2021-03-04 JW Updated to use 2 parameters instead of 3
==================================================================
*/


Let ([
  ~split = Substitute ( keyOrIndexOrPath ; "." ; ¶ ) ;
  ~key = GetValue ( ~split ; ValueCount ( ~split ) ) ;
  ~path = Substitute ( keyOrIndexOrPath ; "." & ~key ; "" ) ;
  ~path = If ( ~path = ~key ; "" ; ~path )

];

ValueCount ( FilterValues ( JSONListKeys ( json ; ~path ) ; ~key ) )

)

Returns true if the specified key, index, or path exists in the provided JSON object. Returns false otherwise (including if the JSON is not valid).

Comments

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

JSONKeyExists ( json ; keyOrIndexOrPath )

Comments

Support this website.

Support this website.