How do I parse the body of a Postman response?

Question

Using Postman I have created a POST and received a successful response which is:

    <?xml version="1.0" encoding="UTF-8"?><!DOCTYPE cXML SYSTEM "http://xml.cXML.org/schemas/cXML/1.2.009/cXML.dtd"><cXML payloadID="1291738556051.1748803078966128712@site.com" timestamp="2017-10-23 10:47:05" version="1.2.009" xml:lang="en-US"><Response><Status code="200" text="Success - Valid PunchIn" xml:lang="en-US" /><PunchOutSetupResponse><StartPage><URL><![CDATA[**https://somesite.com/shopcust_sso.asp?strfirstname=test&strlastname=test&strphone=585-427-8190&stremail=email@email.com&straccountno=test&expdate=2017-10-23 10:48 AM&straddress=274 North Goodman&strcity=Rochester&strState=NY&strzipcode=14607&payloadID=1291738556051.1748803078966128712@sciquest.com&frompunchoutURL=https%3a%2f%2fuitweb.sciquest.com%2fapps%2fRouter%2fCXMLReceive%3fsupplierId%3d13232821%26punchoutOperation%3dcreate&token=0M1d0UaQOl1XuOAbeF74%2fg%3d%3d**]]></URL></StartPage></PunchOutSetupResponse></Response></cXML>"

From this body I need to parse out:

I need to parse out the following:

https://somesite.com/shopcust_sso.asp?strfirstname=test&strlastname=test&strphone=585-427-8190&stremail=email@email.com&straccountno=test&expdate=2017-10-23 10:48 AM&straddress=274 North Goodman&strcity=Rochester&strState=NY&strzipcode=14607&payloadID=1291738556051.1748803078966128712@sciquest.com&frompunchoutURL=https%3a%2f%2fuitweb.sciquest.com%2fapps%2fRouter%2fCXMLReceive%3fsupplierId%3d13232821%26punchoutOperation%3dcreate&token=0M1d0UaQOl1XuOAbeF74%2fg%3d%3d

Then use it in a browser URL.

Thanks for the help.

Answer 1

I'm a bit confused about what you're asking. Depending on which language you are using, there are several libraries that will allow you to parse XML responses and pull out data you need. You can find an example on how to that here (with JS): Parse XML using JavaScript.

Once you get the URL out, you'll also need to format, since it looks like you have spaces in there. This can be done with something like Javascript's encodeURIComponent() function.

Answer 2

Using xml_grep :

xml_grep --text_only URL file.xml | sed -r 's/^\*{2}//; s/\*{2}$//'

You need to install XML::Twig

Answer 3

you could use postman's xml2json function and then parse the json. have a look here

like

// get the response body
var Json_responseBody = xml2json(responseBody);
var jsonData = JSON.parse(Json_responseBody);

and then use jsonData to extract whatever you need

I haven't tried it though ...