JSON.VALUE

Returns a value from a JSON object. The value to return corresponds to the path specified by given keys. Please refer to JSON.RANGE for writing the complete data of a JSON object to the sheet.

Syntax

=JSON.VALUE(JSON, Key1, Key2, …)

Arguments

Name	Description
JSON	A JSON object to read value from.
Key1…KeyN	A list of keys which build up a path within given JSON object.

Return Value

The value at specified path or an error if no JSON object is passed or path is invalid.

Example Below examples assumes following text in A1: {“Customer”: {“Name”: “Peter”, “Kids”: [“Paul”, “Mary”]}}

Function	Result	Comment
=JSON.VALUE(JSON(A1),”Customer”,”Name”)	Peter	Value at Customer.Name
=JSON.VALUE(JSON(A1),”Customer”,”Kids”, 1)	Mary	Value at Customer.Kids[1]
=JSON.VALUE(JSON(A1),”Customer”,”Kids”, “Name”)	#NA	Invalid json path