doc-exports/docs/dataartsstudio/umn/dataartsstudio_01_0501.html

JSONUtil Embedded Objects

A JSONUtil embedded object provides JSON object methods.

Methods

Table 1 Method description

Method	Description
Object parse(String jsonStr)	Converts a JSON character string into an object.
String toString(Object jsonObject)	Converts an object to a JSON character string.
Object path(String jsonStr,String jsonPath)	Returns the field value in a path specified by the JSON character string. This method is similar to XPath and can be used to retrieve or set JSON by path. You can use . or [] in the path to access members and values. For example, tables[0].table_name.

Example

The content of variable str is as follows:

{
            "cities": [{
                        "name": "city1",
                        "areaCode": "1000"
            },
            {
                        "name": "city2",
                        "areaCode": "2000"
            },
            {
                        "name": "city3",
                        "areaCode": "3000"
            }]
}

The expression for obtaining the area code of city1 is as follows:

#{JSONUtil.path(str,"cities[0].areaCode")}

Parent topic: EL Expression Reference