Get Data From a XML - Issue

[Farid (Farid Belmiloude)]

Hi guys,
I’m facing some issue to extract data from XML. I tried to find solution with this link but I’m still stuck when I want to extract data from a complexer XML

Method:
1- Read text
2- Deserialize XML
3-xmlDoc.Element(“InfeedMeasurements”).Element(“Payload”).Element(“InfeedHeadpoin”).Element
(“EanGsrn”).Value.ToString

As a attachment the xml i tried to parse.

OutputXML.xml (40.3 KB)

Ty for your help!

[Vijay_Tulsalkar (Vijay Kumar C Tulsalkar)]

@Farid

use Xpath

Activities

Iterate XPath Result Object

I have to iterate on the result of “Execute XPath” Activity. The challenge I’m facing is the Execute XPath returns “Object” Datatype. How to validate the returned Object has data ? I tried to do ToString but it does not give me any readable text… For which datatype I need to cast this to so that I can iterate and get values My XML <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <TestRoot> <Data> <Item>1</Item> <Item>1</Item> <Item>1</Item> <Item>1</Item> </Data> </TestRo…

[garywjd91]

xpath with namespace.xaml (9.3 KB)

refer to this

[garywjd91]

the xpath has already been placed. just need to change the filepath

[garywjd91]

why would the filepath be correct since we have different systems

[Farid (Farid Belmiloude)]

Like you can see in my precedly screenshot, I changed the path

[garywjd91]

Can you do a debug and see results from write line in output panel

[Farid (Farid Belmiloude)]

i checked, and it just skipped the for “each invoke node” step… (I put “yes” to check it )

[garywjd91]

can’t help you much from here as you can see from my screenshot, the workflow which i gave you extracts what you need. Not sure where did you went wrong

[Farid (Farid Belmiloude)]

Np ty for your help