Android Question How to parse "strange" xml

[vecino]

Hi, a webservice soap returns a strange xml and I can't extract the information.
What can I use to get it?
Thank you very much.

<?xml version="1.0"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/">
  <SOAP-ENV:Body SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:NS1="urn:wsNewGES2000Intf-IwsNewGES2000">
    <NS1:PDA_DatosArticuloResponse xmlns:NS2="urn:wsNewGES2000Intf">
      <NS2:PDADatosArticulo id="1" xsi:type="NS2:PDADatosArticulo">
        <Codigo xsi:type="xsd:string">B1001</Codigo>
        <Nombre xsi:type="xsd:string">PAT. LISA FAMILIAR 260 GRS X 12 B.</Nombre>
        <Existencias xsi:type="xsd:double">0</Existencias>
        <Costo xsi:type="xsd:double">1.2</Costo>
        <Margen0 xsi:type="xsd:double">3</Margen0>
        <PVP0 xsi:type="xsd:double">1.212</PVP0>
        <Margen1 xsi:type="xsd:double">2</Margen1>
        <PVP1 xsi:type="xsd:double">1.224</PVP1>
        <Margen2 xsi:type="xsd:double">0</Margen2>
        <PVP2 xsi:type="xsd:double">1.236</PVP2>
        <Margen3 xsi:type="xsd:double">4</Margen3>
        <PVP3 xsi:type="xsd:double">1.248</PVP3>
      </NS2:PDADatosArticulo>
      <return href="#1"/>
    </NS1:PDA_DatosArticuloResponse>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

 

[emexes]

All the solutions I've seen are good,

All the solutions were XML parsing pared down to be as simple and understandable as possible that worked for your sample data.

but what would happen if the XML contains more than one element with the same name?.

The looping solutions in posts #10 and #11 would return all the elements, including elements with same name.

The access-element-by-name solutions would return the first element of that name.

 

[vecino]

????
All the solutions I've seen are good, but what would happen if the XML contains more than one element with the same name?
g.

<NS2:pDADatosArticulo id="1" xsi:type="NS2:pDADatosArticulo">
......
</NS2:pDADatosArticulo>

<NS2:pDADatosArticulo id="2" xsi:type="NS2:pDADatosArticulo">
......
</NS2:pDADatosArticulo>

Then we would have a problem, Houston
Actually in this case there is no problem because it is a matter of reading a barcode and asking for the information only for that item.

 

[emexes]

Then we would have a problem, Houston

That is not The Right Stuff attitude.

I even suspect it could be done without adding an extra line of code. ?

 

[emexes]

RIghto... this modified (but no extra lines) XML field extraction Subroutine:

[CODE lang="b4x" highlight="1"]
Sub GetXMLField(XML As String, RecordID As String, FieldName As String) As String
Dim Pattern As String = "<NS2.*?id=""" & RecordID & """.*?<" & FieldName & " .*?>(.*?)</" & FieldName & ">"
Dim XMLMatcher As Matcher = Regex.Matcher(Pattern, XML.Replace(Chr(10), ""))
If XMLMatcher.Find Then
Return XMLMatcher.Group(1)
End If
Return "XML record " & RecordID & " field " & FieldName & " not found" 'or whatever you prefer to signify not found
End Sub
[/CODE]

and this sample multi-record XML:

[CODE lang="b4x"]
Dim SampleXML As String = $"<?xml version="1.0"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:NS1="urn:wsNewGES2000Intf-IwsNewGES2000">
<NS1DA_DatosArticuloResponse xmlns:NS2="urn:wsNewGES2000Intf">
<NS2DADatosArticulo id="1" xsi:type="NS2DADatosArticulo">
<Codigo xsi:type="xsd:string">B1001</Codigo>
<Nombre xsi:type="xsd:string">PRIMO PAT. LISA FAMILIAR 260 GRS X 12 B.</Nombre>
<Existencias xsi:type="xsd:double">0</Existencias>
<Costo xsi:type="xsd:double"><B>1.1</B></Costo>
<Margen0 xsi:type="xsd:double">3</Margen0>
<PVP0 xsi:type="xsd:double">1.212</PVP0>
<Margen1 xsi:type="xsd:double">2</Margen1>
<PVP1 xsi:type="xsd:double">1.224</PVP1>
<Margen2 xsi:type="xsd:double">0</Margen2>
<PVP2 xsi:type="xsd:double">1.236</PVP2>
<Margen3 xsi:type="xsd:double">4</Margen3>
<PVP3 xsi:type="xsd:double">1.248</PVP3>
</NS2DADatosArticulo>
<NS2DADatosArticulo id="2" xsi:type="NS2DADatosArticulo">
<Codigo xsi:type="xsd:string">B2002</Codigo>
<Nombre xsi:type="xsd:string">SECONDO PAT. LISA FAMILIAR 260 GRS X 12 B.</Nombre>
<Existencias xsi:type="xsd:double">0</Existencias>
<Costo xsi:type="xsd:double"><B>1.2</B></Costo>
<Margen0 xsi:type="xsd:double">3</Margen0>
<PVP0 xsi:type="xsd:double">1.212</PVP0>
<Margen1 xsi:type="xsd:double">2</Margen1>
<PVP1 xsi:type="xsd:double">1.224</PVP1>
<Margen2 xsi:type="xsd:double">0</Margen2>
<PVP2 xsi:type="xsd:double">1.236</PVP2>
<Margen3 xsi:type="xsd:double">4</Margen3>
<PVP3 xsi:type="xsd:double">1.248</PVP3>
</NS2DADatosArticulo>
<NS2DADatosArticulo id="3" xsi:type="NS2DADatosArticulo">
<Codigo xsi:type="xsd:string">B3003</Codigo>
<Nombre xsi:type="xsd:string">TERZO PAT. LISA FAMILIAR 260 GRS X 12 B.</Nombre>
<Existencias xsi:type="xsd:double">0</Existencias>
<Costo xsi:type="xsd:double"><B>1.3</B></Costo>
<Margen0 xsi:type="xsd:double">3</Margen0>
<PVP0 xsi:type="xsd:double">1.212</PVP0>
<Margen1 xsi:type="xsd:double">2</Margen1>
<PVP1 xsi:type="xsd:double">1.224</PVP1>
<Margen2 xsi:type="xsd:double">0</Margen2>
<PVP2 xsi:type="xsd:double">1.236</PVP2>
<Margen3 xsi:type="xsd:double">4</Margen3>
<PVP3 xsi:type="xsd:double">1.248</PVP3>
</NS2DADatosArticulo>
<NS2DADatosArticulo id="4" xsi:type="NS2DADatosArticulo">
<Codigo xsi:type="xsd:string">B4004</Codigo>
<Nombre xsi:type="xsd:string">QUARTO PAT. LISA FAMILIAR 260 GRS X 12 B.</Nombre>
<Existencias xsi:type="xsd:double">0</Existencias>
<Costo xsi:type="xsd:double"><B>1.4</B></Costo>
<Margen0 xsi:type="xsd:double">3</Margen0>
<PVP0 xsi:type="xsd:double">1.212</PVP0>
<Margen1 xsi:type="xsd:double">2</Margen1>
<PVP1 xsi:type="xsd:double">1.224</PVP1>
<Margen2 xsi:type="xsd:double">0</Margen2>
<PVP2 xsi:type="xsd:double">1.236</PVP2>
<Margen3 xsi:type="xsd:double">4</Margen3>
<PVP3 xsi:type="xsd:double">1.248</PVP3>
</NS2DADatosArticulo>
<return href="#1"/>
</NS1DA_DatosArticuloResponse>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
"$
[/CODE]

tested using this:

[CODE lang="b4x" highlight="2"]
For RecordID = 1 To 5 'SampleXML only has records 1..4 ie no record 5
Log(RecordID & TAB & GetXMLField(SampleXML, RecordID, "Nombre"))
Next
[/CODE]

results in:

[CODE lang="html" title="Log ouput"]
Waiting for debugger to connect...
Program started.
1 PRIMO PAT. LISA FAMILIAR 260 GRS X 12 B.
2 SECONDO PAT. LISA FAMILIAR 260 GRS X 12 B.
3 TERZO PAT. LISA FAMILIAR 260 GRS X 12 B.
4 QUARTO PAT. LISA FAMILIAR 260 GRS X 12 B.
5 XML record 5 field Nombre not found
[/CODE]

Runtime efficiency is dismal ? but good enough for proof-of-concept mockup ?

 

[vecino]

Fantastic, very good work.
Thank you very much.