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.TO.RANGE for writing the complete data of a JSON object to the sheet.

Syntax

=JSON.VALUE(JSON, Key1...KeyN)

Arguments

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

Return

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

Examples

	A	B
1	{"Name": "Peter", "Kids": ["Paul", "Mary"]}}

Formula	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