JSON Parsing. Cannot cast object with class 'java.lang.Integer' to class 'java.util.Map'

yakovlieva.olena · December 15, 2023, 4:15pm

Hi,

I work with json that is REST api response (pretty is about 11000 lines).
I can’t parse it. What is wrong?

response status 200 OK.

Cannot cast object '200' with class 'java.lang.Integer' to class 'java.util.Map'

import com.kms.katalon.core.testobject.RequestObject

import com.kms.katalon.core.testobject.ResponseObject

import com.kms.katalon.core.webservice.verification.WSResponseManager

import groovy.json.JsonSlurper

RequestObject request = WSResponseManager.getInstance().getCurrentRequest()

ResponseObject response = WSResponseManager.getInstance().getCurrentResponse()

responseString= response.toString()

JsonSlurper js = new JsonSlurper()

Map m = js.parseText(responseString)

String tracksData = m["tracksData"]

println m.get("tracksData").size()

JSON looks like:

{
    "tracksData": [
        {
            "name": "1",
            "area": "Center",           
        }
    ],
    "avgByArea": [
        {
            "area": "Center",
            "avg_wear_coefficient": 0.004851138365159119
        }
    ],
    
    "wearCoefficientOverTunnelmeter": [
        {
            "tunnelmeter": 22,
            "wear_coefficient": 0.002479905440550177,
            "weartype": "Inspection",
            "area": "Gauge",
            "track_name": "29",
            "from": "2023-01-13T12:30:46.000Z"
        },
        {
            "tunnelmeter": 22,
            "wear_coefficient": 0.005698029177732199,
            "weartype": "Inspection",
            "area": "Gauge",
            "track_name": "28",
            "from": "2023-01-13T12:30:46.000Z"
        }
    ]
}

error:

Verification FAILED.

Reason:

org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object '200' with class 'java.lang.Integer' to class 'java.util.Map'

at WSVerification1702655914901.run(WSVerification1702655914901:15)

at com.kms.katalon.core.main.ScriptEngine.run(ScriptEngine.java:194)

at com.kms.katalon.core.main.ScriptEngine.runScriptAsRawText(ScriptEngine.java:119)

at com.kms.katalon.core.main.WSVerificationExecutor.runScript(WSVerificationExecutor.java:180)

at com.kms.katalon.core.main.WSVerificationExecutor.doExecute(WSVerificationExecutor.java:174)

at com.kms.katalon.core.main.WSVerificationExecutor.processExecutionPhase(WSVerificationExecutor.java:157)

at com.kms.katalon.core.main.WSVerificationExecutor.accessMainPhase(WSVerificationExecutor.java:149)

at com.kms.katalon.core.main.WSVerificationExecutor.execute(WSVerificationExecutor.java:131)

at com.kms.katalon.core.main.TestCaseMain.runWSVerificationScript(TestCaseMain.java:150)

at com.kms.katalon.core.main.TestCaseMain$runWSVerificationScript$0.call(Unknown Source)

at TempTestCase1702655910490.run(TempTestCase1702655910490.groovy:25)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

P.S. I need to parse this JSON to calculate wearCoefficientOverTunnelmeter.track_name with defined value

Thank you in advance for your help!

viewxy · December 18, 2023, 12:05pm

I think that, this way your verification script gets the response status code 200, and tries to parse it.
I tried to replicate it and got the same error, the error occures with this line:

Map m = js.parseText(responseString)

if you change ‘Map’ to ‘def’ like this, and print right after:

def m = js.parseText(responseString)
println(m)

No error, but the printed line is 200 and nothing else, I tried with a bad url expecting 500 status code and the printed line was 500.So it is definitely the status code that is being parsed and printed.

I think for further help I would need to know what exactly you want to achieve. What do you mean by calculating, do you mean to verify track_name and compare with a predefined value? Or overwrite it with a predefined value?

yakovlieva.olena · December 18, 2023, 12:28pm

@viewxy thank you for your answer.

initially I need to check if FE changes are applied in defined use cases.

a TC is planned:

API call
FE changes
the same API call to compare the target value*

*target value - a number of wearCoefficientOverTunnelmeter.track_name records with defined track_name value
e.g. number of "track_name": "29" objects.

Thank you for your help!

kazurayam · December 18, 2023, 1:22pm

Try the following change:

ResponseObject response = WSResponseManager.getInstance().getCurrentResponse()

// responseString= response.toString()

JsonSlurper slurper = new JsonSlurper()

//Map m = slurper.parseText(responseString)

Map m = slurper.parseText(response.getResponseBodyContent())

You should check the javadoc of ResponseObject

https://api-docs.katalon.com/com/kms/katalon/core/testobject/ResponseObject.html

You can read the source of ResponseObject here

github.com

katalon-studio/katalon-studio-testing-framework/blob/master/Include/scripts/groovy/com/kms/katalon/core/testobject/ResponseObject.java

package com.kms.katalon.core.testobject;

import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.StringReader;
import java.io.StringWriter;
import java.util.Collections;
import java.util.List;
import java.util.Map;

import javax.xml.parsers.DocumentBuilder;
import javax.xml.transform.OutputKeys;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerException;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;
import javax.xml.xpath.XPath;
import javax.xml.xpath.XPathConstants;
import javax.xml.xpath.XPathFactory;

This file has been truncated. show original

yakovlieva.olena · December 18, 2023, 3:02pm

@kazurayam Thank you for your help. The response is parsed successfully.

But another problem has arisen. It seems because of the response big size.

Verification status is incomplete when I try to interact with parsed response.

import com.kms.katalon.core.testobject.RequestObject
import com.kms.katalon.core.testobject.ResponseObject
import com.kms.katalon.core.webservice.verification.WSResponseManager
import groovy.json.JsonSlurper


RequestObject request = WSResponseManager.getInstance().getCurrentRequest()
ResponseObject response = WSResponseManager.getInstance().getCurrentResponse()

responseString= response.toString()

JsonSlurper slurper = new JsonSlurper()
Map m = slurper.parseText(response.getResponseBodyContent())

def wearCoefficientOverTunnelmeter= m.wearCoefficientOverTunnelmeter
 countWearCoef = 0
for (def p: wearCoefficientOverTunnelmeter) {
	if(wearCoefficientOverTunnelmeter.track_name =='34' ) {
	countWearCoef= countWearCoef +1
}
}
println (countWearCoef)

Could you please advise a solution?

Thank you in advance for your help!

yakovlieva.olena · December 18, 2023, 4:29pm

something is wrong with a loop. I need some time to understand.

kazurayam · December 18, 2023, 10:32pm

What do you mean by saying “incomplete”?

In the screenshot I found the output from your code:
1229

It looks just fine. That’s all your script does. It has no “verification” code at all.

So what is “incomplete”? I have no idea.

kazurayam · December 18, 2023, 10:37pm

The screenshot shows this:

This looks strange. You would rather want this, don’t you?

if (wearCoefficientOverTunnelmeter.track_name == '34') {
    countWearCoef = countWearCoef + 1
}

yakovlieva.olena · December 19, 2023, 1:51pm

@kazurayam thank you. I’ve fixed this loop.

I’ve added an assertion, but the result of verification is still incomplete (lable in Verification Log)

No exeptions.

code that is executed:

import static org.assertj.core.api.Assertions.*

import com.kms.katalon.core.testobject.RequestObject
import com.kms.katalon.core.testobject.ResponseObject
import com.kms.katalon.core.webservice.keyword.WSBuiltInKeywords as WS
import com.kms.katalon.core.webservice.verification.WSResponseManager

import groovy.json.JsonSlurper


RequestObject request = WSResponseManager.getInstance().getCurrentRequest()
ResponseObject response = WSResponseManager.getInstance().getCurrentResponse()

JsonSlurper slurper = new JsonSlurper()
Map m = slurper.parseText(response.getResponseBodyContent())

/*
def avgByArea= m.avgByArea
def avgByArea_gauge= m.avgByArea[0]
def avgByArea_gauge_area= m.avgByArea[0].area

*/

def wearCoefficientOverTunnelmeter= m.wearCoefficientOverTunnelmeter
 countWearCoef = 0
 countWearCoefAll = 0
 
List<String>  wearTypes = new ArrayList<String>()
List<Date>  dateFrom = new ArrayList<Date>()
 
 println (wearCoefficientOverTunnelmeter[0].track_name)
 println(wearCoefficientOverTunnelmeter.size())
 
 for (int i = 0; i <wearCoefficientOverTunnelmeter.size(); i++) {
 
	 
		countWearCoefAll= countWearCoefAll +1
		if (wearCoefficientOverTunnelmeter[i].weartype != 'Inspection') {
		
	countWearCoef= countWearCoef +1
		
	println(i)
	//println(wearCoefficientOverTunnelmeter[i])
	println(wearCoefficientOverTunnelmeter[i].weartype)
	wearTypes.push(wearCoefficientOverTunnelmeter[i].weartype)
	dateFrom.push(wearCoefficientOverTunnelmeter[i].from)
	}
 }
 

println (countWearCoef)
println (countWearCoefAll)
println (wearTypes)
println (dateFrom)




WS.verifyResponseStatusCode(response, 200)

assertThat(response.getStatusCode()).isEqualTo(200)

kazurayam · December 19, 2023, 10:25pm

Do you expect to see any exception here?

I don’t understand why you expect exception here.

yakovlieva.olena · December 20, 2023, 11:16am

@kazurayam
I confused with INCOMPLETE red label on verification Log tab for this call. Other calls have PASSED green label.

kazurayam · December 20, 2023, 11:33am

I don’t know what “INCOMPLETE” means at all.

Topic		Replies	Views
Unable to parse Json response API Testing katalon-studio , api-testing	3	874	February 8, 2021
Cannot parse response content API Testing katalon-studio , api-testing	10	2618	January 31, 2019
Verify json response execution error API Testing katalon-studio , api-testing	6	3222	August 8, 2022
JSON parse error: Unexpected character ('n' (code 110)): was expecting comma to separate Object entries API Testing katalon-studio , api-testing	21	15736	December 5, 2019
How to retrieve values from nested json structures (Maps) API Testing json , katalon-studio , api-testing	37	3404	August 26, 2019

JSON Parsing. Cannot cast object with class 'java.lang.Integer' to class 'java.util.Map'

Related topics