Problem with generate XML in QlikView

Tue, 27 Aug 2013 14:00:18 GMT

Hi guys, i'm new in community, and new user in qlikview, and i need to answer a question:

above all, i'm not know writing English.. i'm using Google Translate.

well...

i have this code:

sub testeRildomar

set val=ActiveDocument.Fields("Ticker").GetPossibleValues

sStockID = val.Item(0).Text

xmlToSend = ""

xmlToSend = xmlToSend & "<?xml version='1.0' encoding='utf-8'?>"

xmlToSend = xmlToSend & "<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'>"

xmlToSend = xmlToSend & "<soap:Body>"

xmlToSend = xmlToSend & "<Clientes xmlns='http://feixeweb.feixe.com.br/'>"

xmlToSend = xmlToSend & "<login>administrator</login>"

xmlToSend = xmlToSend & "<senha>mypassword</senha>"

xmlToSend = xmlToSend & "</Clientes>"

xmlToSend = xmlToSend & "</soap:Body>"

xmlToSend = xmlToSend & "</soap:Envelope>"

set txt1 = ActiveDocument.Variables("vXMLSent")

txt1.setContent xmlToSend, true

'Create xmlhttp opject

Set xmlhttp = CreateObject("Microsoft.XMLHTTP")

'xmlhttp.open "POST", "http://www.webservicex.net/stockquote.asmx?op=GetQuote", false

xmlhttp.open "POST", "http://wfx2.feixe.com.br/Services/FeixeWeb.asmx?WSDL", false

xmlhttp.setRequestHeader "Content-Type", "text/xml"

xmlhttp.setRequestHeader "SOAPAction", "http://feixeweb.feixe.com.br/Clientes"

xmlhttp.send xmlToSend

result = xmlhttp.responseText

result = replace(result, ">", ">")

result = replace(result, "<", "<")

set txt2 = ActiveDocument.Variables("vXMLReceived")

txt2.setContent result, true

set st = ActiveDocument.getSheetObject("CH01")

File = activedocument.Evaluate("'Cliente.xml'")

st.ExportEx File,1

end sub

this code is a simple query with a WebService and the result is displayed in a Document. okay.

But when I try to record in XML using this piece of code:

set st = ActiveDocument.getSheetObject("CH01")

File = activedocument.Evaluate("'Cliente.xml'")

st.ExportEx File,1

it generates as follows:

"<?xml version=""1.0"" encoding=""utf-8""?>

<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>

     <ClientesResponse xmlns=""http://feixeweb.feixe.com.br/"">

          <ClientesResult>

               <Cliente>

                    <CNPJ>54968573671234</CNPJ>

                    <RazãoSocial>Padaria do seu zé</RazãoSocial>

                    <NomeFantasia>Pão Doce</NomeFantasia>

               </Cliente>

          </ClientesResult>

     </ClientesResponse>

</soap:Body>

</soap:Envelope>"

If we analyze, we will realize that it ta put "at the beginning, and everywhere we have." example:

<? xml version = ""

and everywhere .. How to solve?

topic Problem with generate XML in QlikView in Water Cooler

Problem with generate XML in QlikView