Get xml attribute value and descriptor values

[gokul1904 (Glory 01)]

Hello team ,

I want to extract below 6 values from the attached xml .I tried many ways but could not derive a solution.

PO-00001234
eae312ffafafa
USD 3300739100
USD IE38BOFA99006156171047
1905.33
19322133

I have highlighted the positions from where they have to be taken below

PO Sample Output_01.xml (6.5 KB)

I have also attached the xml file.
Kindly help.

Regards,
Gokul

[ppr (Peter Preuss)]

we would like to remind you on the XML Namespace handling similar to your other topics

general flow:

Check and namespace handling:

Retrieval:

Getting all WID types:

Getting first one’ s value

Bank_Account:

For the other retrieval just adapt and handle it similar

[gokul1904 (Glory 01)]

Thank you ppr.
Should the variable type for all the above queries be “XElement”?

Also the usecase is I want to extract a list of all the bank accounts from the xml which is under -

In this case there are 2 bank accounts.So what should be the query to fetch all the bank accounts from a specific xml.Can you please guide me on that too?

Regards,
Gokul

[ppr (Peter Preuss)]

@gokul1904

Should the variable type for all the above queries be “XElement”?

it depends on what you have implemented.

for element retrieval, the base is XElement or the appropriate collection type
for value retrieval the appropriate datatype: string, number…

@gokul1904

o what should be the query to fetch all the bank accounts f

we showcased the for this Descendants() method as one of several options