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.
Updated 9 months ago