mukeshnair18 Posted May 3, 2018 Share Posted May 3, 2018 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 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 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" : { }}]]> Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now