Expand/Collapse all

JsonSet - script and chart function

JsonSet() modifies a string containing JSON (JavaScript Object Notation) data. It can set or insert a JSON value with the new location specified by the path. The data must be valid JSON but can contain extra spaces or newlines.

Syntax:  

value JsonSet(json, path, value)

Return data type: dual

Example: Valid JSON, path, and value

Example	Result
JsonSet('{}','/a','"b"')	Returns '{"a":"b"}'
JsonSet('[]','/0','"x"')	Returns '["x"]'
JsonSet('"abc"','','123')	Returns 123

Example: Invalid JSON, path, or value

Example	Result	Description
JsonSet('"abc"','/x','123')	Returns null	The path does not point to a valid part of the JSON data.
JsonSet('{"a":{"b":"c"}}','a/b','"x"')	Returns null	The path is invalid.
JsonSet('{"a":"b"}','/a','abc')	Returns null	The value is not valid JSON. A string must be enclosed in quotes.

See also:

• IsJson - script and chart function

• JsonGet - script and chart function