How can we parse nested JSON

[Ankita9793]

Hi All,

How can we parse nested JSON? I tried it as below, it shows '[object Object],[object Object]'

 var request = new sn_ws.RESTMessageV2(restMessage, restMethod);

        for (var p in params) {

            if (p == "returnObj"){

                request.setStringParameterNoEscape(p, JSON.stringify(params[p][0]));

            }

            gs.info('params[p]' + JSON.stringify(params[p]) +JSON.stringify(p));

            request.setStringParameterNoEscape(p, params[p]);

        }
 

JSON DATA :

{"returnObj":[{"RequesterUserId":"45333530","RequestCategory":"01","ServiceNowFormNumber":"RITM1234","ScTaskNumber":"SCNum01234","AdminSystemName":"MDM","CustomerNumber":"042721608","KycRm":"072"},{"RequesterUserId":"45333530","RequestCategory":"01","ServiceNowFormNumber":"RITM1234","ScTaskNumber":"SCNum01267","AdminSystemName":"MDM","CustomerNumber":"350802601","KycRm":"610"}]}

[Ankur Bawiskar]

@Ankita9793 

try this if you want to send the entire nested JSON as a string parameter:

request.setStringParameterNoEscape("returnObj", JSON.stringify(params["returnObj"]));

try this If you want to send the whole payload as the request body

request.setRequestBody(JSON.stringify(params));

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Ankita9793 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Ankita9793 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Bhimashankar H]

Hi @Ankita9793 ,

I think you want to parse the data from JSON. So I have tried below snippet to parse data.

var jsonData = {
    "returnObj": [{
        "RequesterUserId": "45333530",
        "RequestCategory": "01",
        "ServiceNowFormNumber": "RITM1234",
        "ScTaskNumber": "SCNum01234",
        "AdminSystemName": "MDM",
        "CustomerNumber": "042721608",
        "KycRm": "072"
    }, {
        "RequesterUserId": "45333530",
        "RequestCategory": "01",
        "ServiceNowFormNumber": "RITM1234",
        "ScTaskNumber": "SCNum01267",
        "AdminSystemName": "MDM",
        "CustomerNumber": "350802601",
        "KycRm": "610"
    }]
}
gs.info(jsonData.returnObj[1].RequesterUserId)

so here it will print the 

45333530

 One thing to consider is that 'returnObj' is the array and each one is array data and we can access those values using "." then property name.

Thanks,

Bhimashankar

----------------------------------------------------------------------------------------
Please mark my answer as helpful/correct if it resolves your query.
----------------------------------------------------------------------------------------