how can I get this Pol[i] into one list

0

I want to retrieve list of ABC and DEF in jasper report.Please help me out as I am not able to think of how I will be able to increment the POL[i] node.

{  
"CalcRespose":{  
  "xml":{  
     "Messages":[  
        {  
           "More":""
        }
     ],
     "OUTPUT":{  
    "NODE1":"35.1",
    "NODE2":"0.00",
    "NODE3":"0.00",
    "Pol1":{  
               "ABC":"Red",
               "DEF":"001"
    },
    "Pol2":{  
            "ABC":"BLUE",
            "DEF":"002"
    },
    "Pol3":{  
            "ABC":"GREEN",
            "DEF":"003"
    },
    "Pol4":{  
            "ABC":"YELLOW",
            "DEF":"004"
    }
}
}
}
}

This is the queryString in jasper.What I need is to display it in list,so is there any way to call POL[i] instead of POL1

<queryString language="WebServiceQuery">
        <![CDATA[{
"getparameters" : { },
"fields" : [ {
"name" : "NODE1",
"expression" : "NODE1"
}, {
"name" : "ABC",
"expression" : "Pol1.ABC"
}, {
"name" : "DEF",
"expression" : "Pol1.DEF"
} ],
"options" : {
"contentType" : "application/xml",
"rootPath" : "CalcRespose.xml.OUTPUT",
"baseUrl" : ""
},
"headersMap" : { },
"queryData" : "{\n  \"CalcReq\": {\n    \"xml\": {\n      \"id\": $P{CLIENT_ID}\n    }\n  }\n}",
"GETParameters" : { }
}]]>
mukeshnair18's picture
Joined: May 3 2018 - 4:24am
Last seen: 1 year 4 months ago

0 Answers:

No answers yet
Feedback
randomness