How to remove namespace prefix from XML node dynamically in C#?

Question

0.00/5 (No votes)

See more:

I want to remove all namespace prefix from an xml node dynamically in c#. I am able to remove the same using the replace function in a static manner.
Namespace prefix may vary. I want to remove the prefix from Node name T24EnuiryResponse in the xml updated below:

Code tried is as below:
<pre>NodeValueFromStreamWithoutNS=GetNodeValueFromStream(streamR, NodeName).Replace("ns1:", "").Replace("ns2:", "").Replace("ns3:", "");

What I have tried:

Code is as below:

NodeValueFromStreamWithoutNS=GetNodeValueFromStream(streamR, NodeName).Replace("ns1:", "").Replace("ns2:", "").Replace("ns3:", "");

Response Xml:

<?xml version='1.0' encoding='utf-8'?>
<soapenv:Envelope
	xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
	<soapenv:Body>
		<ser-root:T24EnquiryResponse
			xmlns:ser-root="https://soa.nbf.ae/Enquiry/"
			xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
			<Status>SUCCESS</Status>
			<EnquiryOutput>
				<NBFDDSLOANLOOKUP>
					<gNBFDDSLOANLOOKUPDetailType>
						<mNBFDDSLOANLOOKUPDetailType>
							<ID>MG1827000105</ID>
							<CUSTOMERID>555312</CUSTOMERID>
							<PRINLIQACCT>012001312705</PRINLIQACCT>
							<DRAWDOWNACCOUNT>012001304621</DRAWDOWNACCOUNT>
							<CURRENCY>AED</CURRENCY>
							<AMOUNT>300000.00</AMOUNT>
							<LOANSTATUS>LIQ</LOANSTATUS>
							<OVERDUESTATUS>NAB</OVERDUESTATUS>
							<DUEMONTH>202009</DUEMONTH>
							<MONTHDUEAMT>20868.73</MONTHDUEAMT>
						</mNBFDDSLOANLOOKUPDetailType>
						<mNBFDDSLOANLOOKUPDetailType>
							<ID/>
							<CUSTOMERID/>
							<PRINLIQACCT/>
							<DRAWDOWNACCOUNT/>
							<CURRENCY/>
							<AMOUNT/>
							<LOANSTATUS/>
							<OVERDUESTATUS/>
							<DUEMONTH>202008</DUEMONTH>
							<MONTHDUEAMT>19261.65</MONTHDUEAMT>
						</mNBFDDSLOANLOOKUPDetailType>
						<mNBFDDSLOANLOOKUPDetailType>
							<ID/>
							<CUSTOMERID/>
							<PRINLIQACCT/>
							<DRAWDOWNACCOUNT/>
							<CURRENCY/>
							<AMOUNT/>
							<LOANSTATUS/>
							<OVERDUESTATUS/>
							<DUEMONTH>202007</DUEMONTH>
							<MONTHDUEAMT>19501.96</MONTHDUEAMT>
						</mNBFDDSLOANLOOKUPDetailType>
						<mNBFDDSLOANLOOKUPDetailType>
							<ID/>
							<CUSTOMERID/>
							<PRINLIQACCT/>
							<DRAWDOWNACCOUNT/>
							<CURRENCY/>
							<AMOUNT/>
							<LOANSTATUS/>
							<OVERDUESTATUS/>
							<DUEMONTH>202006</DUEMONTH>
							<MONTHDUEAMT>19734.51</MONTHDUEAMT>
						</mNBFDDSLOANLOOKUPDetailType>
						<mNBFDDSLOANLOOKUPDetailType>
							<ID/>
							<CUSTOMERID/>
							<PRINLIQACCT/>
							<DRAWDOWNACCOUNT/>
							<CURRENCY/>
							<AMOUNT/>
							<LOANSTATUS/>
							<OVERDUESTATUS/>
							<DUEMONTH>202005</DUEMONTH>
							<MONTHDUEAMT>19974.83</MONTHDUEAMT>
						</mNBFDDSLOANLOOKUPDetailType>
						<mNBFDDSLOANLOOKUPDetailType>
							<ID/>
							<CUSTOMERID/>
							<PRINLIQACCT/>
							<DRAWDOWNACCOUNT/>
							<CURRENCY/>
							<AMOUNT/>
							<LOANSTATUS/>
							<OVERDUESTATUS/>
							<DUEMONTH>202004</DUEMONTH>
							<MONTHDUEAMT>20207.38</MONTHDUEAMT>
						</mNBFDDSLOANLOOKUPDetailType>
						<mNBFDDSLOANLOOKUPDetailType>
							<ID/>
							<CUSTOMERID/>
							<PRINLIQACCT/>
							<DRAWDOWNACCOUNT/>
							<CURRENCY/>
							<AMOUNT/>
							<LOANSTATUS/>
							<OVERDUESTATUS/>
							<DUEMONTH>202003</DUEMONTH>
							<MONTHDUEAMT>20447.7</MONTHDUEAMT>
						</mNBFDDSLOANLOOKUPDetailType>
						<mNBFDDSLOANLOOKUPDetailType>
							<ID/>
							<CUSTOMERID/>
							<PRINLIQACCT/>
							<DRAWDOWNACCOUNT/>
							<CURRENCY/>
							<AMOUNT/>
							<LOANSTATUS/>
							<OVERDUESTATUS/>
							<DUEMONTH>202002</DUEMONTH>
							<MONTHDUEAMT>20680.25</MONTHDUEAMT>
						</mNBFDDSLOANLOOKUPDetailType>
						<mNBFDDSLOANLOOKUPDetailType>
							<ID/>
							<CUSTOMERID/>
							<PRINLIQACCT/>
							<DRAWDOWNACCOUNT/>
							<CURRENCY/>
							<AMOUNT/>
							<LOANSTATUS/>
							<OVERDUESTATUS/>
							<DUEMONTH>202001</DUEMONTH>
							<MONTHDUEAMT>20912.82</MONTHDUEAMT>
						</mNBFDDSLOANLOOKUPDetailType>
						<mNBFDDSLOANLOOKUPDetailType>
							<ID/>
							<CUSTOMERID/>
							<PRINLIQACCT/>
							<DRAWDOWNACCOUNT/>
							<CURRENCY/>
							<AMOUNT/>
							<LOANSTATUS/>
							<OVERDUESTATUS/>
							<DUEMONTH>201912</DUEMONTH>
							<MONTHDUEAMT>75012.51</MONTHDUEAMT>
						</mNBFDDSLOANLOOKUPDetailType>
					</gNBFDDSLOANLOOKUPDetailType>
				</NBFDDSLOANLOOKUP>
			</EnquiryOutput>
		</ser-root:T24EnquiryResponse>
	</soapenv:Body>
</soapenv:Envelope>

Posted 12-Apr-22 22:10pm

Member 7513082

Updated 13-Apr-22 2:50am

v2

Add a Solution

Comments

Rajeev Jayaram 13-Apr-22 4:55am

What do you mean by "Since Namespace prefixes came different in another environment"?

Member 7513082 13-Apr-22 6:23am

namespace prefix may com as ns3: or as ser-root etc for the node T24EnquiryResponse. I need to remove the namespace prefix whichever it may be for this node name alone.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2022-04-13T02:50:00

Solution 1

It is a SOAP response packet, so I am not sure why you would want to do that.

This may point you in the right direction: [Solved] How to read soap response in c#? - CodeProject[^]

Posted 13-Apr-22 2:50am

Graeme_Grant

Comments

Member 7513082 18-Apr-22 7:36am

I am able to remove the namespace with below code but the data with in the node are lost, I need to keep the node data as such even after removal of the namespace
var soapBody = doc.GetElementsByTagName("soapenv:Body")[0];
string innerObject = soapBody.InnerXml;
if (innerObject.Contains("T24EnquiryResponse"))
{
XElement xElement = new XElement(XElement.Parse(innerObject).Name.LocalName);
string test = xElement.Name.ToString();
string test1= xElement.Name.LocalName;
xElement.Name = xElement.Name.LocalName.ToString();

xElement = new XElement(xElement.Name.LocalName, XElement.Parse(innerObject).Elements().Select(el => RemoveAllNamespaces(el)));
//xmlDocumentWithoutNs = xElement;
txtRequest.Text = xElement.ToString();
}