PARSE

Parse JSON data.

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.

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

🍪

We use cookies to enhance your user experience and analyze website performance. You can revoke consent anytime. Learn more.