Get xml value through xpath

Help Studio
1

Hello,

as per title, i have an xml in output and an xpath, i should pull out a particular value, how can i handle it?

1 Like
2

depending on the XML (e.g. defining XML namespaces or not)
In general, we can use the following method:

grafik

xDoc is output from Deserialize XML
grafik

1 Like
3

Returns this error: xDoc is not a member of System.Xml.Linq.XDocument

4

pleas show us your implementation along with the Variable definitions or share your XAML uif possible

5

image

Where xmlDeserialized is output from Deserialize XML and a variable of type Xdocument

6

xmlDeserialized has to be of datatype XDocument
XPathSelectElement method requires also at least the XPath expression string as method argument

Ensure following as well:
grafik

Please complete always your implementation steps before stating that something is failing. This lets you faster progess

1 Like
7

ok, was the import of namespace, thank you…

now i have this error:

image

when i try to write in the immediate xDoc.XpathSelectElement(“path”).Value

8

you cannot use variables which are not existing / or not properly initialized.

So only use the variables which you have set up within your flow

9

I have the following xpath:

/CC2/TEST_DATA/TEST_CODE/text()

i’m not able to retrieve the following string in TEST_CODE

10

too many things a mixed up. Can you share your XML file with us? Thanks

1 Like
11

XMLT.txt (502 Bytes)

this is an example xml, i should retrieve the value of min_code

Thanks in advance

12

as introducded above:
grafik

grafik
grafik704×34 4.94 KB

grafik

The XML was to repair on the closing DD tag

grafik
grafik437×536 53.8 KB

retrieving the min_code

As an alternate we can also do:
grafik

1 Like
13

Appreciate your patience.

image

The following error appear following the instructions and fixing the xml.

The expression in log message is the same as your: xDoc.XpathSelectElement(“//MIN_CODE”).Value

where the xDoc var is of xDocument type

14

debug it and check xDoc. Ensure

  • the correct XML is read in
  • the deserialize XML has an output
  • the output from deserialize XML activity is used for your statement
  • the XPAth is correct

As you can see in the screenshots that the prototyping was working in the immediate panel, somewhere in your flow a small issue is to check and to fix

1 Like
15

works with the submitted test.xml, not with the original one unfortunately.

That one is inserted inside a soap:Body, do the instructions for getting the information from MIN_CODE change?

16

Soap is defining namespaces and it was mentioned by:

above on the first answer.

Handling XPath and namespaces have a look here:

we would recommend to share with us all relevant details directly on the begin. So we can reduce ping pongs

17

@maxena2872 Kindly help us with some test data ?

Thanks
#nK