BE_JSON_ArraySize

BE_JSON_ArraySize ( json {; path } )

Will return the number of values in a JSON array.  If now path is included, it counts the array at the root of the JSON, and will return 1 for a non array type.  If a path is included, the format is as per the JSONPath function, which is NOT the same as the internal FileMaker JSON functions introduced in version 16.

Version : 2.1
Version : 4.1 : Added the optional path parameter.

Parameters :
json : the array to count.
path : the path within the JSON to locate the array to count.

Result : Returns the number of values in the array, or ? for an error. Other errors are logged and can be retrieved with BE_GetLastError.

Examples :

BE_JSON_ArraySize ( " [ { " &
BE_JSON_Encode ( "firstName" ; "John" ) & ", " & BE_JSON_Encode ( "lastName" ; "Doe" ) & " }, { " &
BE_JSON_Encode ( "firstName" ; "Anna" ) & ", " & BE_JSON_Encode ( "lastName" ; "Smith" ) & " }, { " &
BE_JSON_Encode ( "firstName" ; "Peter" ) & ", " & BE_JSON_Encode ( "lastName" ; "Jones" ) & " } ]" )