Read Node Value from SOAP response in ASP.Net using C# and VB.Net

NuwZ

SOLVED CLOSED ACTIVE ANSWERED
User: NuwZ
Posted: on May 24, 2021 05:32 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 16565

hi,

I try to browse a SOAP XML return, to extract the result, but after hours of testing I admit defeat.

I can't find the right methodology to access the different nodes, do you have any leads?

Thank you, Have a good day

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
    <SOAP-ENV:Header/>
    <SOAP-ENV:Body>
        <ns1:IdentificationResponse xmlns:ns1="urn:Blurbe">
            <IdentificationResult>
                <e>
                    <r>
                        <agence>0001</agence>
                        <client blocage="N" groupement="3">0012</client>
                        <nom_soc>CLIENT DIVERS</nom_soc>
                    </r>
                </e>
            </IdentificationResult>
        </ns1:IdentificationResponse>
    </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Private Function XmlDatasReader_Identification(pStr As String) As String
    Dim output As String = ""
 
    Try
        Dim xmlDoc As New XmlDocument()
        xmlDoc.LoadXml(pStr)
 
        Dim nsManager = New XmlNamespaceManager(xmlDoc.NameTable)
        nsManager.AddNamespace("ns1", "urn:Blurbe")
        nsManager.AddNamespace("xsd", "http://www.w3.org/2001/XMLSchema")
        nsManager.AddNamespace("xsi", "http://www.w3.org/2001/XMLSchema-instance")
        nsManager.AddNamespace("SOAP-ENV", "http://schemas.xmlsoap.org/soap/envelope/")
 
        Dim nodes As XmlNodeList = xmlDoc.SelectNodes("//SOAP-ENV:Envelope/SOAP-ENV:Header/SOAP-ENV:Body/ns1:IdentificationResponse/IdentificationResult/e/r/", nsManager)
        Dim agence As String = "", client As String = "", nom_soc As String = ""
        ' ///////////////////////////////
        For Each node As XmlNode In nodes
            If (node.SelectSingleNode("ns1:agence", nsManager) IsNot Nothing) Then agence = node.SelectSingleNode("ns1:agence", nsManager).InnerText
            If (node.SelectSingleNode("ns1:client", nsManager) IsNot Nothing) Then client = node.SelectSingleNode("ns1:client", nsManager).InnerText
            If (node.SelectSingleNode("ns1:nom_soc", nsManager) IsNot Nothing) Then nom_soc = node.SelectSingleNode("ns1:nom_soc", nsManager).InnerText
 
            output &= "agence : " & agence & " / " & "client : " & client & " / " & "nom_soc : " & nom_soc
            output &= "<br/>"
        Next
        ' ///////////////////////////////
        ' If output = "" Then output = "OuterXml : " & xmlDoc.OuterXml
    Catch ex As Exception
        output = ex.ToString
    End Try
 
    Return output
End Function

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 4

Reply
ANSWER
User: dharmendr
Replied: on May 28, 2021 12:33 AM
Report

Hi NuwZ,

Check this example. Now please take its reference and correct your code.

XML

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
	<SOAP-ENV:Header/>
	<SOAP-ENV:Body>
		<ns1:IdentificationResponse xmlns:ns1="urn:Blurbe">
			<IdentificationResult>
				<e>
					<r>
						<agence>0001</agence>
						<client blocage="N" groupement="3">0012</client>
						<nom_soc>CLIENT DIVERS</nom_soc>
					</r>
				</e>
			</IdentificationResult>
		</ns1:IdentificationResponse>
	</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Namespaces

using System.IO;
using System.Linq;

VB.Net

Imports System.IO
Imports System.Linq

Code

public string GetXMLResponseValue()
{
    var serviceResult = string.Empty;
    var xmlStr = File.ReadAllText(Server.MapPath("XMLFile.xml"));
    var doc = XDocument.Parse(xmlStr);
    XNamespace ns = "urn:Blurbe";
    var result = doc.Root.Descendants(ns + "IdentificationResponse")
                    .Descendants("IdentificationResult")
                    .Descendants("e")
                    .Descendants("r")
                    .Descendants("agence");

    if (!string.IsNullOrEmpty(result.ToString()))
        serviceResult = result.FirstOrDefault().Value;

    return serviceResult;
}

VB.Net

Public Function GetXMLResponseValue() As String
    Dim serviceResult = String.Empty
    Dim xmlStr = System.IO.File.ReadAllText(Server.MapPath("XMLFile.xml"))
    Dim doc = XDocument.Parse(xmlStr)
    Dim ns As XNamespace = "urn:Blurbe"
    Dim result = doc.Root.Descendants(ns + "IdentificationResponse") _
                    .Descendants("IdentificationResult") _
                    .Descendants("e") _
                    .Descendants("r") _
                    .Descendants("agence")

    If Not String.IsNullOrEmpty(result.ToString()) Then
        serviceResult = result.FirstOrDefault().Value
    End If

    Return serviceResult
End Function

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Read Node Value from SOAP response in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us