Syntax
JSONARRAYSIZE(<string containing a JSON array>)
Description
Returns the number of elements of the selected JSON arrays.
...
| Group | Name_List | Name_JSON | JSONARRAYSIZE returns |
|---|---|---|---|
| Group1 | [Andy, Alba, Anna, Affa] | ["Andy","Alba","Anna","Affa"] | 4 |
| Group2 | [Jeff, June, Jack] | ["Jeff","June","Jack"] | 3 |
| Group3 | [Rick, Rode] | ["Rick","Rode"] | 2 |
| Group4 | [Molly] | ["Molly"] | 1 |
Further Documentation
Find more documentation on working with JSON here.