still no luck .. :'(
def results = new XmlSlurper().parseText(jdbcResponse)
.ResultSet.Row.collect{[transactionId: it.TRANSACTION_ID,
transactionDate: it.TRANSACTION_DATE_KEY,
transactionValue: it.TRANSACTION_VALUE,
totalDiscount: it.TOTAL_DISCOUNT.text()?:'0',
def arrayOfTagInfo = new JsonSlurper().parseText(restResponse)
.transactions.collect{ [transactionId: it.transactionId,
transactionDate: it.transactionDate,
transactionValue: it.transactionValue,
totalDiscount: it.totalDiscount.text()?:'0',
I get error - groovy.lang.MissingMethodException: No signature of method: java.math.BigDecimal.text() is applicable for argument types: () values: [] Possible solutions: next(), getAt(java.lang.String), wait(), wait(long), max(java.math.BigDecimal), wait(long, int) error at line: 26
for json definitions it gives error - line 26
ONE DOUBT - > ? I need to change in both the definitions - JSON & JDBC ? I am doing it correct ?
I tried with this as well
def results = new XmlSlurper().parseText(jdbcResponse)
.ResultSet.Row.collect{[transactionId: it.TRANSACTION_ID,
transactionDate: it.TRANSACTION_DATE_KEY,
transactionValue: it.TRANSACTION_VALUE,
totalDiscount: it.TOTAL_DISCOUNT != '' ? it.TOTAL_DISCOUNT : 0,
still no luck , I dont know if its because of the negative value of attribute or below format, when discount value is null in JDBC XML.
<TOTAL_DISCOUNT>-32.4</TOTAL_DISCOUNT>
<TOTAL_DISCOUNT/>
JSON
"totalDiscount": -32.4
"totalDiscount": 0
Please look at it !!
I am able to solve the problem with total_discount using :
totalDiscount: it.TOTAL_DISCOUNT.text() ?: '0.0', ---> as suggested by you. Thanks a lot for this.
and tried to make -32.4 to positive by:
totalDiscount: (it.totalDiscount*-1)
Now the problem is with "CITY" because of below:
JDBC JSON
<CITY>Östersund</CITY> "city": Ä -stersund
<CITY>GÖTEBORG<CITY> "city":GÖTEBORG"
while fetching from json it is converting some characters to different values like .
Ö -> Ä
GÖ -> GÃ
Please help!!
Hi,
I tried two steps, one as suggested by you - change in the soapui.bat file and then i also changed the encoding in properties in rest request test step.
Thanks
