Help Center/ DataArts Studio/ More Documents/ User Guide (Kuala Lumpur Region)/ User Guide/ DataArts Factory/ EL Expression Reference/ JSONUtil Embedded Objects
Updated on 2022-08-17 GMT+08:00
View PDF
Share

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