Problem getting values xml soap

[dyuonn.bakker (John Bakker)]

Hi There,

I’m trying to get a certain value out of an xml doc which comes from an soap request.
I am trying to get for example the adress within the xml, can anybody give me some feedback on my workflow. I am doing something wrong with the namespaces i guess.
Main.xaml (9.3 KB)

Would really help!
The xmlfile looks like this:

[<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <s:Header xmlns:s="http://schemas.xmlsoap.org/soap/envelope/" />
  <soap:Body>
    <checkVatResponse xmlns="urn:ec.europa.eu:taxud:vies:services:checkVat:types">
      <countryCode>BE</countryCode>
      <vatNumber>0843562775</vatNumber>
      <requestDate>2021-09-23+02:00</requestDate>
      <valid>true</valid>
      <name>BV FORFARMERS BELGIUM</name>
      <address>Zuidkaai 6
8770 Ingelmunster</address>
    </checkVatResponse>
  </soap:Body>
</soap:Envelope>]

To get the value i tried this:

XMLdoc.Element(EnvNamesp+“Envelope”).Element(EnvNamesp+“Body”).Element(SecondNames+“checkVatResponse”).Element(“Address”).Value

Thanks!

[ppr (Peter Preuss)]

@dyuonn.bakker

ensure the closing / on end of xnsEnvelope
ensure the spelling of address witten with lower case letters