Parse this json response
I am stuck. I am new to groovy scripting. How do I parse out theOrchestrationId, CenterId and AddressId of the below response? All are unique, dynamic and generated in the application. I need these...
Forum Discussion
Hi,
You've got escaped json which isn't being read by ReadyAPI!s json parser which is why you cant use the embedded functionality to grab the values you want.
You have a couple of choices here - theres an RequestFilter.afterRequest event handler (published in soapui.org) that is pretty handy - for altering responses accordingly.
the script to remove CDATA tag handlers from xml is as follows:
def content = context.httpResponse.responseContent content = content.replaceAll( "<!\\[CDATA\\[", "" ) content = content.replaceAll( "]]>", "" ) //log.info( content ) context.httpResponse.responseContent = content
So - click on the events tab and add a RequestFilter.afterRequest handler.
Set its content to something like the following - you just need to alter this to remove the backslashes from your responses
def content = context.httpResponse.responseContent content = content.replaceAll( "\\\\\", "" ) //log.info( content ) context.httpResponse.responseContent = content
I think that's it - I always get confused how many escapes I need to do this - you might need to play with the number of backslashes in the script - but thats the basis of what you need - add that event handler in - and it should alter the content of your responses removing the backslash resulting in the response 'appearing' as non-escaped .json in your outline tab in the response resulting in you being able to use the embedded functionality to correlate/grab the dynamic session variables using normal property transfer.
hope this helps,
richie
aah - I just noticed you'll need to remove 2 instances of the double quotes on top of what I've already provided. So after running the above script I mentioned to remove the '\' chars, you'll also need to remove the " chars opening and closing the message object's contents.
Changing the below snippet
to the following:
so you need to update what I said before to something like the following:
def content = context.httpResponse.responseContent content = content.replaceAll( "\\", "" ) // to replace the '\' char with blank content = content.replaceAll( "\"{", "{" ) // to replace the "{ to { content = content.replaceAll( "\"}", "}" ) // to replace the "} to } log.info( content ) context.httpResponse.responseContent = contentAs I stated before - the json escaping confuses me - I've just read up a little and it isn't as confusing as I thought - so I think I've got the escaping correct now - but what you need is something pretty close to above.
cheers,
richie
Richie,
The response is returning in JSON, not XML. This application only sends and accepts json. I am not sure of what is wrong with the script in line 7. I have attached the request and response and the script you provided.
Thanks,
Double A
- Erm....yeah....i know the response is json...im lost...why do you think i think its xml? Cos i dont! :)
Hang on....i'm travelling at the moment.....give me half hour and i'll look at your response properly....i cant see properly using my phone
Richie,
Thank you for explaining this to me. I had not seen this anywhere before and did as much as I knew to do by parsing the response.
Thanks a million.
Double A
it's all good - I only know about that particular event handler cos someone on this forum told me!
richie
