Retrieve xml element value

Like (1) Share

Report

Posted on 9 Apr 2021 09:50:41 by maheshmacintosh

Hi,

Below is the xml and need to retrieve only market value.

I tried providing "root/documents/document/market" in XPath query in "Get XML element value" but it retrieves nothing.

Please help me in this regard. Thanks in advance.

<?xml version="1.0" encoding="utf-8"?>
<root>
<documents>
<document>
<isSpecimen value="False" />
<report value="ReportTest" />
<type value="Parent" />
<market value="CountryTest" />
</document>
</documents>
</root>

All responses (3)

Answers (1)

Community Power Pla... on 06 Oct 2021 at 13:35:20

Like (1)

Report

Re: Retrieve xml element value

Hello @maheshmacintosh

As @A_I already said, you have to use action "Get XML element attribute" for this purpose.

Result:

Thank you.
Verified answer

A_I 16 on 05 Oct 2021 at 22:44:51

Like (1)

Report

Re: Retrieve xml element value

With that syntax, use Get XML element attribute instead of Get XML element value
burque505 398 on 09 Apr 2021 at 19:34:40

Like (1)

Report

Re: Retrieve xml element value

@maheshmacintosh, I believe you have discovered a bug.
I ran a small test with the file 'books.xml' from Microsoft available here.
I also viewed the video at this link. At approximately 4:49 in the video, the following screen is shown:
Obviously this is based on a different XML file, but we should still get a list of properties. We don't.
For the file 'books.xml',
after running and clicking on the variable, we get only a single property':
The single property '.XmlNode' is shown. Clicking 'more' we get this:
In short, it appears to me that this Action is not functioning properly. I feel it is safe to assume the remainder of the XML Actions may also not be functioning properly.
Regards,
burque505