Reading XML Tag with Specific Attribute

[ercan.nebiler]

Hi,

I’m reading a value with this;

xdoc_XML.Descendants(cac+“AccountingSupplierParty”).Descendants(cac + “Party”).Descendants(cac + “PartyIdentification”).Descendants(cbc+ “ID”).FirstOrDefault().Value

But there’s a problem. There are three ID tags. Check below;

        <cbc:ID schemeID="xxx">Number1</cbc:ID>
  </cac:PartyIdentification>
  <cac:PartyIdentification>
    <cbc:ID schemeID="yyy">Number2</cbc:ID>
  </cac:PartyIdentification>
  <cac:PartyIdentification>
    <cbc:ID schemeID="zzz">Number3</cbc:ID>

When i use my code getting Number1 because of FirstorDefault.

But i need the part schemeID=“yyy” which is Number2 value. How can i get this?

Thanks.

[ppr (Peter)]

@ercan.nebiler
I assume that you have setup correctly the namespaces and cac Varaible is e.g. on of them

give a try on:
xdoc_XML.Descendants(cac+“AccountingSupplierParty”).Descendants(cac + “Party”).Descendants(cac + “PartyIdentification”).Descendants(cbc+ “ID”).Where(Function (x) x.Attribute("schemeID").Value.Equals("yyy")).FirstOrDefault.Value

In case of it is not working please the complete xml file with us

[ercan.nebiler]

You are a LIFESAVER. Thank you so much. The best comment on this forum. Thank you so much Peter!

[ppr (Peter)]

@ercan.nebiler
Thank you. In some cases XPATH Query are nice to handle and along with the namespace manage we can also handle name space.

In case of you are interested on this let me know along with a sample xml

Happy Automation

[ercan.nebiler]

Please sir. I worked before with different xml format. Learned namespaces and this today. I will definetely look when I’m available. Good night

Edit: I read your comment like “sample xaml” If you have a sample workflow like that can you share with me?