Forum Discussion

Gkm's avatar
Gkm
Contributor
9 years ago

Soapui Script Assertion, when Json response return as string

  My Json response(which return as string),   "[{\"sysSerial\":5,\"policyName\":\"hold\",\"uploadPolicyTypes\":[{\"sysSerial\":36,\"uploadPolicyId\":5,\"type\":null,\"isUploadMetaData\":true}]}]" ...
  • Gkm's avatar
    Gkm
    9 years ago

    So I have fixed my own problem by simple regular expressions , Thank you nmrao  once again for giving me an idea.

    Here is the code,

     

    //imports
import groovy.json.JsonSlurper

//grab the response
def ResponseMessage = messageExchange.response.responseContent

// replace "(starting&ending), [](starting&ending) and \ with space from response
def TrimResponse =ResponseMessage.replaceAll('^\"|\"$','').replaceAll('^\\[|\\]$','')replaceAll('\\\\','')

//define a JsonSlurper
def jsonSlurper = new JsonSlurper().parseText(TrimResponse)

//verify the slurper isn't empty
assert !(jsonSlurper.isEmpty())

assert jsonSlurper.sysSerial != null
assert jsonSlurper.sysSerial == 5
assert jsonSlurper.uploadPolicyTypes[0].sysSerial == 36

    Cheers,

    Geeta

     

nmrao's avatar
nmrao
Champion Level 3
Gkm,
If the error message is noticed, it explains the reason. i.e., what you are receiving is not a valid json, hence the that error.

I would suggest you to contact the service provider (if external) or your team (if internal). A potential application defect.
Gkm's avatar
Gkm
Contributor
9 years ago

I validated response using http://jsonlint.com/ and it is a valid JSON.

  • jimmibond's avatar
    jimmibond
    New Member
    9 years ago

    Please use JSON Validator for validating JSON data and also share with others for data validation or analysis.

  • nmrao's avatar
    nmrao
    Champion Level 3
    9 years ago

    Though the response appears to be valid i.e., JSONArray, it is difficult to reproduce this issue for others.

     

    And not sure why response is wrapped in double quotes and slashes.

     

    If possible try to check with your team and see the possibilities to work smoothly which is in your hands rather than going around why soapui is not working and you can't control it.

    More over, even if this service made available to your customers or end users, it should be smooth and should work with different tools and one can't control which tool to use or not.

     

    If the response is changed as below(without wrapping into double quotes), and your script works:

     

    [{
	"sysSerial":5,
	"policyName":"hold",
	"uploadPolicyTypes":[
		{
			"sysSerial":36,
			"uploadPolicyId":5,
			"type":null,
			"isUploadMetaData":true
		}
	]
}]
    • Gkm's avatar
      Gkm
      Contributor
      9 years ago

      Thank you so much nmrao.

      I told the development team but for this release I have to create the cases.

      Can't I control this by replacing all slash, opening & closing double quotes and square brackets ?
       
      "[{\"sysSerial\":5,\"policyName\":\"hold\",\"description\":\"\",\"lastTimeStamp\":\"00000000000121ac\",\"uploadPolicyTypes\":[{\"sysSerial\":36,\"uploadPolicyId\":5,\"type\":null,\"dataUploadConnection\":\"1,2,3\",\"metaDataUploadConnection\":\"1,2,3\",\"defaultPriority\":0,\"isUploadMetaData\":true}]}]"

      Replaced all slash, opening & closing double quotes and square brackets,

      {"sysSerial":5,"policyName":"hold","description":"","lastTimeStamp":"00000000000121ac","uploadPolicyTypes":[{"sysSerial":36,"uploadPolicyId":5,"type":null,"dataUploadConnection":"1,2,3","metaDataUploadConnection":"1,2,3",
      "defaultPriority":0,"isUploadMetaData":true}]}

      By using this code,

      import groovy.json.JsonSlurper
def ResponseMessage = messageExchange.response.contentAsString
def response = ResponseMessage.replaceAll("\","").replaceAll(""[","").replaceAll(""]","")
def jsonSlurper = new JsonSlurper().parseText(response)
assert !(jsonSlurper.isEmpty())

      But now I'm getting syntax exception here, I will be very thankful if you correct this code.

      Thanks
    • Gkm's avatar
      Gkm
      Contributor
      9 years ago

      Thank you so much nmrao.

      I told the development team but for now I have to create test cases.

      I'm trying to replace starting and ending double quotes and backslash with blank space, I think it will resolve the issue.

      import groovy.json.JsonSlurper
def ResponseMessage = messageExchange.response.responseContent
// trim starting and ending double quotes
def TrimResponse =ResponseMessage.replaceAll('^\"|\"$','').replaceAll('/\\/','')
def jsonSlurper = new JsonSlurper().parseText(TrimResponse)
assert !(jsonSlurper.isEmpty())
      But still I'm getting backslash error,
       

      Please tell me how to fix this,
      Thanks

       

      • Gkm's avatar
        Gkm
        Contributor
        9 years ago

        So I have fixed my own problem by simple regular expressions , Thank you nmrao  once again for giving me an idea.

        Here is the code,

         

        //imports
import groovy.json.JsonSlurper

//grab the response
def ResponseMessage = messageExchange.response.responseContent

// replace "(starting&ending), [](starting&ending) and \ with space from response
def TrimResponse =ResponseMessage.replaceAll('^\"|\"$','').replaceAll('^\\[|\\]$','')replaceAll('\\\\','')

//define a JsonSlurper
def jsonSlurper = new JsonSlurper().parseText(TrimResponse)

//verify the slurper isn't empty
assert !(jsonSlurper.isEmpty())

assert jsonSlurper.sysSerial != null
assert jsonSlurper.sysSerial == 5
assert jsonSlurper.uploadPolicyTypes[0].sysSerial == 36

        Cheers,

        Geeta