Skip to main content
Version: 2.3

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

NameDescription
JSONA JSON object to read value from.
Key1...KeyNA 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"]}}

FunctionResultComment
=JSON.VALUE(JSON(A1),"Customer","Name")PeterValue at Customer.Name
=JSON.VALUE(JSON(A1),"Customer","Kids", 1)MaryValue at Customer.Kids[1]
=JSON.VALUE(JSON(A1),"Customer","Kids", "Name")#NAInvalid json path