The example for extracting the second phone number reads
A2: =parsejson(A1,"phoneNumbers.get(1).number")
Why use "get"? It's confusing because it's the same as the GET function, and there is already a well-established notation for accessing arrays in nested data structures:
The example for extracting the second phone number reads
Why use "get"? It's confusing because it's the same as the GET function, and there is already a well-established notation for accessing arrays in nested data structures: