Skip to main content

JsonSetEx - script and chart function

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

Syntax:  

JsonSetEx(json, path, value, ...)

Return data type: dual

Arguments:  

Arguments
Argument Description
json String containing JSON data.
path

The path must be specified according to RFC 6901. This allows buildup of properties inside JSON data without using complex substring or index functions and concatenation.

value The new string value in JSON format.

Example:  

The following load script loads and formats data into a JSON format:

Data: Load *, JsonSetEx('{"fax":123}', '/name', Name, '/address', Address, '/phone', Phone, '/fax', FaxOrNull) AS Json; LOAD *, If(Fax='-',Null(),Fax) AS FaxOrNull; LOAD * INLINE [ Id, Name, Address, Phone, Fax 1, John Doe, Oak Way, 1 234 567, 1 234 568 2, Jane Doe, Maple Way, 123456, - 3, Mr Xavier, Spruce Way, 1-800-MRX ];

This results in the following JSON data:

{"name":"John Doe","address":"Oak Way","phone":"1 243 567","fax":"1 234 568"}
{"name":"Jane Doe","address":"Maple Way","phone":123456}
{"fax":"","name":"Mr Xavier","address":"Spruce Way","phone":"1-800-MRX"} 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!