Forum Discussion

AAB's avatar
AAB
Regular Contributor
5 years ago

ReadyAPI - How to compare quoted array with unquoted array

Hello,   For my test I have a REST Request that gives back a json response.     [{ "nationalId": "01050110250", "driverLicences": [{ "model": "BC", ...
  • HimanshuTayal's avatar
    HimanshuTayal
    5 years ago

    AAB : As i can see you are just logging the value not storing the value in the variable. Just assign the value in the variable as below

     

    def rrn = holder.getNodeValue( "//data[1]/ResponseBody-data[1]/DataSubject-01[1]" )
rrn = rrn.toString().replace("\"","")

     

    Hope this will work.

     

richie's avatar
richie
Community Hero
5 years ago

Hey AAB 

 

first thing that  pops in my head that if you're comparing a json to xml - have you tried using an 'Accept' header (with value 'application/json') on the request that generates the XML to convert the request's XML response to json?  Ive found this quite handy to do this before now - unsure if it would make a differerence in your example however, as your NationalId values in your XML are contained within an array, whereas the NationalId values in the json are just multiple separate name/value pairs.

 

ignoring that for now - when you say compare quoted array against  unquoted array Im misunderstanding a little - currently you have a json response with text NationalId values that are quoted to represent that the values are text values and your XML includes a Datasubject tag and the value for this tag is an an array, right?

 

My way is slower and less efficient than the other forum members would probably use - but I'd extract each of the values from the json to individual properties within a Properties step and I'd extract the individual values from the Datasubject tag value's array into individual properties within the Properties step and then running the comparison's fairly straightforward, right?  The complication in this scenario is that you are trying to compare individual name/value pairs to comma separated values within a single array.  I dont see how to do this other than to split them out into a map, specific properties - but obviously my groovy's rubbish relative to the others.

 

I've no doubt the other fellas will cough up something whizzy, but if they dont respond within a day or so, I'll publish my clunky version!

 

ta

 

rich

  • AAB's avatar
    AAB
    Regular Contributor
    5 years ago

    Hi richie 

     

    Thanks for your time!... once again  🙂

    A little bit of nerdy explanation in what I do know in coding (not much but I handle it  🙂  ....  At least I'm trying  😄   )

     

    For starters, this is not a simple REST Request, this is an HTTP request. (I've should have mentioned that maybe...?) This said, the response that I'm receiving is an HTML page that can be read as an XML. So your proposition

    "tried using an 'Accept' header (with value 'application/json')" is not do-able for me. (I've tried but this gives me a 'bad message' error  😉   )

     

    " as your NationalId values in your XML are contained within an array, whereas the NationalId values in the json are just multiple separate name/value pairs. "
    not true in this case, this is a json array 😉 watch the " {[ ]} ". Json always starts with " { } " but it can go on with lists or it can contain arrays " [ ] ". And as the answer is giving me [nr1, nr2, nr3, etc..] it means that the response is an array. With jsonSlurper you can read the values in that array, so no problems there, but with XmlSlurper apparently it also gives the quotes. Like said in the description, I've tried to omit the quotes with regex but it doesn't work. I think because this code is in an assertion script code....? don't know. 

     

    To the groovy guru's: any idea? preferred code wise as I already have code to fetch other ID's in this response.

     

    nmrao     HimanshuTayal   

     

    Thanks in advance,

    AboveAndBeyond