FROMJSON

Parses the supplied JSON string and converts it into formula values, if valid.

Syntax

=FROMJSON(json)

Arguments

Argument	Type	Description
json	String	The JSON string to parse

Examples

=FROMJSON('{"A": 123, "B": 234}')→{A: 123, B: 234}

=FROMJSON('[1, "B", true]')→[1, B, true]

=FROMJSON('{"A": {"B": 123}, "C": {"D": 234}}')→{A: {B: 123}, C: {D: 234}

=FROMJSON('{"incomplete"')→#ERROR!
Returns an error when the JSON input is invalid.