1
I need to access the tag value Message of the following xml content:
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<ExecuteResponse xmlns="http://webservice.epharma.com.br/">
<ExecuteResult>
<Epharma xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xsd.epharma.com.br/autorizador">
<Transacao>0830</Transacao>
<CodigoProcessamento>000000</CodigoProcessamento>
<NSUPos>65008</NSUPos>
<CodigoRedePBMS>009</CodigoRedePBMS>
<VersaoLayout>006</VersaoLayout>
<CodigoTerminal>-99999</CodigoTerminal>
<CodigoFarmacia>12345</CodigoFarmacia>
<CodigoResposta>41</CodigoResposta>
<Mensagem>Loja nao associada</Mensagem>
</Epharma>
</ExecuteResult>
</ExecuteResponse>
</soap:Body>
</soap:Envelope>
I’m trying to access using xpath and I’m not getting.
How can I do?
Thank you.
To be clear: where are you bringing this XML from and what is the relationship with Postgresql? You have a field with this XML in the database in Postgresql and want to access it? Are you using that language to pick up this data or is it just a database query?
– Luiz Fernando