PARSE

Parse JSON data.

Parameter List

Syntax
PARSE(json
[query]
)
json

The {data} cell or JSON object you want to parse. For example: A3.

[optional] query

The JsonPath query to perform on the JSON.

More details

Read up on JsonPath in our knowledge base.

Examples

PARSE(A1, "fan-count") returns 50, as the value of fan-count is 50.Example 1