Faing issue with getting xml node value

[Agarwal_Chandresh]

I am not able to get “d:name” nodes values from the attached xml file. Kindly help with steps on how to get it.-----

[
3a20141d-6c4a-4fa0-bb08-63cea1f95c40

2025-02-28T11:40:34Z https://zoetis.sharepoint.com/sites/BOTInfoNonProd/_api/Web/GetFolderByServerRelativePath(decodedurl='/sites/BOTInfoNonProd/Shared Documents/Essbase Refresh Power BI/Revenue OP/Test') 2025-02-28T11:40:34Z true true true false 0 Test /sites/BOTInfoNonProd/Shared Documents/Essbase Refresh Power BI/Revenue OP/Test 2025-02-28T04:56:43Z 2025-02-28T04:56:43Z 9990d2e3-4ca3-4bc9-a340-27cdf53c73f6 https://zoetis.sharepoint.com/sites/BOTInfoNonProd/_api/Web/GetFolderByServerRelativePath(decodedurl='/sites/BOTInfoNonProd/Shared Documents/Essbase Refresh Power BI/Revenue OP/Test1') 2025-02-28T11:40:34Z true true true false 0 Test1 /sites/BOTInfoNonProd/Shared Documents/Essbase Refresh Power BI/Revenue OP/Test1 2025-02-28T04:53:20Z 2025-02-28T04:53:20Z 4708a607-0362-41e4-b6e8-e9b5ced85528 ]

[kristopherk (Kristopher Kim)]

Hi @Agarwal_Chandresh,

Can you share the xml file please?

d: is typically a namespace and you would need to add that XML Namespace prefix before manipulating one of those nodes, similar to this example

Xml file with xmlns value

Hi, Can you try the following steps. First, define System.XML.Linq.XNamespace type variable (Let’s say xns) and set namespace which is defined the element in xmlns attribute to it. xns = "http://xxxxxxxxxx" Then the following will work. xDoc.Descendants(xns+"Jv-Ins-Reinsurance ") Regards,

Extract data xml file with namespace

ensure that element Parcel is fetched and retrieve from it the value from Attribute: CadastralNumber try: xDoc.Root.Descendants(nsKZVU+“Parcel”)(0) and retrieve value from attribute: YourXlementVar.Attribute("CadastralNumber”).Value.toString As we found in your code: xDoc.Root.Descendants(nsKZVU+“CadastralNumber”)(0) we do see a link to the wrong taken output as it fetchs the first CadastralNumber

Xml Namespace breaking my xpath! - Stack Overflow

Thanks

[ppr (Peter Preuss)]

XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types)

Going ahead Serializing the XML - output: xDoc | DataType: XDocument: [grafik] Checking if we have to handle XML namespaces [grafik] We do have: [grafik] Checking for some children: [grafik] Defining Namespace Variable [grafik] In some cases, we can also do: Assign Activity - xnsDefault = xDoc.Root.Name.Namespace Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</…