Reading XML embedded within SOAP response

Just a tip: it's much easier for people here to help you out if you post code samples as text rather than as an image. That way it's possible to copy/paste the text into a workspace to experiment before answering.

That said, you can use the TextDecoder set to "XML" to decode the contents of the ax21:iData block back to proper XML, which you can then process further using e.g. the XMLFlattener etc.

Hi David, many thanks for the response.

Finally worked out that you have to use the 'code' option to insert XML text into a post!

Using the TextDecoder has been a step in the right direction but now I'm left with a file with two XML declarations (as shown in the example below);

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
	<soapenv:Body>
		<ns:getReportsResponse xmlns:ns="http://client.abc">
			<ns:return xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ax21="http://client.abc/xsd" xsi:type="ax21:Data">
				<ax21:iData><?xml version="1.0" encoding="ISO-8859-1"?><reports anon_queue="abc_default_que"><report anon_report="N"><report_id>1274643</report_id><user_id>334263</user_id><cz_title></cz_title><cz_first_name>Darren</cz_first_name><cz_last_name>Fennell</cz_last_name><cz_email>darren.fennell@mydomain.co.uk</cz_email><cz_address><user_address1>Bodlondeb</user_address1><user_address2>Bangor Road</user_address2><user_city>Conwy</user_city><user_postcode>LL32 1DU</user_postcode><user_state>Wales</user_state><user_country>United Kingdom</user_country></cz_address></report></reports></ax21:iData>
				<ax21:iDataLength>19774</ax21:iDataLength>
				<ax21:iErrorMessage xsi:nil="true"></ax21:iErrorMessage>
				<ax21:iWSCallId>7889149</ax21:iWSCallId>
			</ns:return>
		</ns:getReportsResponse>
	</soapenv:Body>
</soapenv:Envelope>

I've tried passing this output into XMLFlattener and XMLFragmenter but both complain about the duplicate XML declarations.  I've also tried using XMLXQueryExtractor to try to ignore everything except those elements within the reports element but this also complains about the duplicate XML declarations.

Do you think that I could I carry out some manipulation on the original XML before I pass it through the TextDecoder (and before the second XML declaration was created) to isolate the contents of the iData element and then pass the response through the TextDecoder?

Many thanks

Maybe I should've been more clear, but I think you first have to extract the contents of ax21:iData into a separate attribute before decoding and then passing it on to the XMLFlattener etc. Otherwise you'll just end up with an invalid XML block, like the one you just posted.

Hi David,

Definitely getting somewhere now, I used the following XQuery expression to extract the contents of the iData element;

Then used the TextDecoder to convert the encoded characters back into <, >, etc.

The result is passed into an XMLFragmenter and this appears to work well, exposing the XML elements as attributes until I get to child elements.  In the belowexample there is an element called <cz_address> and there are 6 child elements to this;

<cz_address>
	<user_address1></user_address1>
	<user_address2></user_address2>
	<user_city></user_city>
	<user_postcode></user_postcode>
	<user_state></user_state>
	<user_country></user_country>
</cz_address>

Do you know how I would expose these child elements as attributes?  I've tried the following as values for attributes to expose in the XMLFragmenter but none seem to work;

• user_address1
• cz_address_user_address1
• cz_address/user_address1

Is this a matter of syntax or do I need to carry out an additional operation to flatten the child elements first?

Many thanks

Hi David, cz_address.user_address1 was the syntax I needed, it's all working as I'd hoped now, many thanks for the help.