Question
Citi
US
Last activity: 8 Feb 2020 0:41 EST
How to convert XML into formated pretty print XML
I have a requirement to convert a string XML into a formatted XML. The requirement also says that only request and response XML properties must be displayed and also it should not be on a pop up window, when i used OOTB functions like showxmlofpage i could see all pega properties included in it like pxObjClass.
My approaches - tried to embed JavaScript and Java code
Challenges - JS i included in a text file and refered it on a button but not working
Java code is throwing errors as it is lacking some classes. am not sure how to overcome this. Please share your inputs.
Sample Java code :
javax.xml.parsers.DocumentBuilderFactory dbf =newjavax.xml.parsers.DocumentBuilderFactory.newInstance();
Existing output :
<root><tag><nested>hello</nested></tag></root>
Expected output :
<root> <tag> <nested>hello</nested> </tag> </root>
Accepted Solution
Citi
US
Thanks John, i made use of the activity and its working as expected. Thanks again for your timely input.
IQZ Systems
IN
Hi
Can you try the following code
String xml = tools.getParamValue("Data"); try{ javax.xml.transform.Transformer serializer= javax.xml.transform.sax.SAXTransformerFactory.newInstance().newTransformer(); serializer.setOutputProperty(javax.xml.transform.OutputKeys.INDENT, "yes"); serializer.setOutputProperty("{http://xml.apache.org/xslt}indent-amount", "2"); javax.xml.transform.Source xmlSource=new javax.xml.transform.sax.SAXSource(new org.xml.sax.InputSource(new java.io.ByteArrayInputStream(xml.getBytes()))); javax.xml.transform.stream.StreamResult res = new javax.xml.transform.stream.StreamResult(new java.io.ByteArrayOutputStream()); serializer.transform(xmlSource, res); tools.putParamValue("Data",new String(((java.io.ByteArrayOutputStream)res.getOutputStream()).toByteArray())); } catch ( javax.xml.transform.TransformerConfigurationException tce) { tools.putParamValue("Data",tce); } catch ( javax.xml.transform.TransformerException txe) { tools.putParamValue("Data",txe); }
I have used Data as a string parameter and set the value back to same Data parameter.
Citi
US
Hi Yathender,
Thanks for the quick response.
I have used this code snippet in Java step and passed my parameter where i have entire XML ;
It executed this Java step successfully.
But XML transformation did not happen in a pretty print fashion.
How can i debug this or what is the logic behind this transformation.
In trace - My XML String parameter remains same before and after the step.
Thanks,
Divya.
IQZ Systems
IN
Hi
The code is to get the indentation to the xml code. It basically adds two spaces to indent the xml code to get proper alignment. I think the code works fine.
You can use a textarea and set the value to it. to see the result. It is working as expected.
Can you tell me the way or scenario you want to show the pretty xml.
Citi
US
Hi Yathender, thanks for your timely input, yes this is what the output am expecting but unfortunately am not able to debug where my code is going wrong and currently am using the OOTB activity "XSLTranslate" and its working fine. Thanks again.
Pegasystems Inc.
GB
Alternative approach - use an XSLT file to re-output the input with indentation switched on.
There are some examples here.
You should be able (I haven't tried this) to the OOTB Pega Platform Activity "XSLTranslate" to apply the XSLT to your XML.
(Actually - I think the Java Code given above effectively uses the same technique - but you can avoid explicit Java Steps using an XSLT)