Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
<!-- received --> "<?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>"
<!-- received -->
"<?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?