How to convert XmlElement/XmlDocument to Text? I am working on Outsystems(Java)

Back to Forums

raj k

Solved

Question

XML

How to convert XmlElement/XmlDocument to Text? I am working on Outsystems(Java)

08 Feb 2016

Vera Tiago

Staff

Solution

Good morning,
Have you tried this?

08 Feb 2016

raj k

Hey Very good morning,

Thanks for your response. Your response is helpful and worked partially.
As a first step I loaded the xml and used XmlDocument_Save() to see whether the xml document is created or not. This step is successful and I am able to see the complete document xml.

The second step is failing, may be I am dong some thing wrong. As part of second step, I am trying to retrieve the part of xml using xpath. After I used XmlDocument_SelectNodes() by providing xpath, calling XmlDocument_Save() is giving me the empty string.

I am not sure whether the call to XmlDocument_SelectNodes() has failed or XmlDocument_Save() failed converting document to xml. Appreciate your response.

08 Feb 2016

raj k

I noticed that, XmlDocument_Save() is working for XmlDocument only. Whereas, XmlDocument_SelectNodes()
is returing XmlNodes, that is the reason why I am getting empty string.

08 Feb 2016

raj k

Still my problem remains unsolved. Is there any better solution than this or any alternate solution for my problem ?

08 Feb 2016

João Santos

Hi Raj,

Once you have XmlNodes, you can use the other actions in the extension, to retrieve selected parts of those XmlNodes as text, such as XML_GetAttributeValue.

Joao

10 Feb 2016

raj k

XML_GetAttributeValue is returning only the tag values of the xml, but I want xml tags along with the values in the xml tags. I thought it would work.

16 Feb 2016

raj k

And also, I don't think XML_GetAttributeValue() can be used to get the xml in the specified xpath. This method is used to retrieve attribute values.

16 Feb 2016

Suraj Borade

Hi Raj,

Do you want to save generated xml document as one text file from selected node ?

16 Feb 2016

1 reply

16 Feb 2016

Show thread

Hide thread

raj k

Suraj Borade wrote:

Hi Raj,

Do you want to save generated xml document as one text file from selected node ?

Yes Suraj, I want merge two xmls and want to save the final xml as text.

16 Feb 2016

João Santos

Hello Raj,

You can use OTHER ACTIONS in the extension to retrieve the XML tags and use XPath expressions.
You need to look at the list of actions in the XML extension to find what you are looking for.

Joao

16 Feb 2016

1 reply

16 Feb 2016

Show thread

Hide thread

raj k

João Santos wrote:

Hey João Santos,

Thanks for your reply.

As you said may be I am missing something. My requirement is simple, I want to merge 2 xmls(xml1 and xml2).
Get subset of xml1 using xpath and append it to xml2 at a specified path and finally convert the xml3 to text.

I hope this can be achieved using XML extension. But I am going clueless by looking at the bigger picture of my goal. If possible can you give some clues?

16 Feb 2016

João Santos

I haven't done exactly what you are asking for. Looking at the XML extension methods, I would try XMLDocument_SelectSingleNode, XMLDocument_New, XMLDocument_CreateRootElement, XML_AppendChildElement, and XMLDocument_Save.
A XSL_Transform may simplify some of the steps.
That's as much as I can try to help.

16 Feb 2016

raj k

João Santos

Thanks you very much, let me try.

16 Feb 2016

raj k

HI João Santos,

I tried to achieve my goal, but it is not possible to achieve the same with XML extension methods.
Any way thanks for your reply.

17 Feb 2016

Kevin Swanson

I'm trying to do something very similar, and it's something that seems like it should be easy. The use case is returning the full outer XML of an XML element - or to clone a node. For example, if I have an XML document that looks like this:

<MyZoo>

</Animal>

<Name>Smokey</Name>

</Animal>

</MyAnimals>

</MyZoo>

Say I want to return to a user one distinct animal. I can use the XML extension to get a single element:

<Name>Smokey</Name>

</Animal>

But how do I get that XML returned is text? I don't want the entire document returned. I could technically almost rebuild the XML by creating a new XML document, cycling through the nodes of the old document, creating elements of the right name, etc. I'm not sure how I would get all of the attributes of a specific node, though. In the example case, I would lose the id attribute of the first node.

And in the real-life use case I'm working with, I don't know the structure of the XML underneath the element I'm trying to clone, so I wouldn't be able to map each attribute by name.

Is my only option to use XSL? I know how to do this in C#, but I'm trying not to write another extension.

06 May 2017

Kevin Swanson

We created a module to add some features we're missing, and this was one of them. So far we've been able to do it without any extension/C# code. My solution was to create an action that took the XML Elment as an input. It creates a temporary "tag" attribute, runs it through an XSL transform that looks for the tagged element and outputs a new document with just that element, loads it into a dom, then returns the output of an _Save. Works great.

Here's the XSL:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="3.0" xmlns:xsl="https://www.w3.org/1999/XSL/Transform" xmlns:xs="https://www.w3.org/2001/XMLSchema" xmlns:fn="https://www.w3.org/2005/xpath-functions">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:template match="/">
<xsl:apply-templates select="//*[@" + TaggerAttributeName + "]" />
</xsl:template>
<xsl:template match="*" >
<xsl:copy-of select="." />

</xsl:template>
</xsl:stylesheet>

31 May 2017

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines