@JSON_count_subobjects ( json ; path_to_object )

Return the number of rows in JSON Array

Be the first to rate this function Log in to vote

Oliver Reid - Show more from this author

Sample input:

@JSON_count_subobjects ("{\"Rows\" : [{\"1\":1},{\"2\":2},{\"3\":3}]}";"Rows")

Sample output:

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

If(PatternCount(JSONFormatElements(json);"?")>0;-1;  

// prevents processing invalid JSON 
// returns -1 if not valid JSON
// returns number of sub objects if path_to_object is an object but not an array
// returns number of rows if path_to_object is an array
//parameters must be valid string expressions

valuecount(JSONlistkeys(json;path_to_object))

Useful for calculation or script to loop through array rows to find a specific value

Comments

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

@JSON_count_subobjects ( json ; path_to_object )

Comments

Support this website.

Support this website.