Retrieve xml element value

[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>

[burque505]

@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

[A_I · Accepted solution]

With that syntax, use Get XML element attribute instead of Get XML element value

[Anonymous]

Hello @maheshmacintosh 

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

Result:

Thank you.