Parse xml file

Hello! I have xml structure:

<1List1>
//<1Organization Code=“111” Name=“Test_1”>
////<1Organization ID=“87654321” Code=“12345670” Name=“AA_Test”>
//////<1Subdivision ID=“12345678” Code=“12345679” Name=“Manager”>
/////////<Worker ID=“00009999” TabelNum=“00006666” FIO=“TTEST”
/////////<Worker ID=“00009998” TabelNum=“00006667” FIO=“TTEST_2”
////</1Organization>
////<1Organization ID=“999999999” Code=“22222222” Name=“BB_Test”>

And i need to find “FIO” from string. I have “TabelNum” How i can get “FIO” ?

I use “Read Text File” and read xml, then “Deserialize XML” and read Text.

please use the </> button from editior when sharing the XML. Currently it is broken. It also looks like a fragment, as the root element is missing

Try with Execute Xpath with //Worker[@TabelNum=‘12345’]/@FIO. you need to provide correct XML format. TabelNum can be parameterize here.

Here example of my structure:
And i need to find “FIO” from string. I have “TabelNum” How i can get “FIO” ?

Hello,
In this video, at minute 23:50 I show how to deserialize a XML:

Thanks,
Cristian

1 Like