These docs are for v1.0. Click to read the latest docs for v1.2.

FROMJSON

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

Syntax

=FROMJSON(json)

Arguments

ArgumentTypeDescription
jsonStringThe 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.