Hi All,
I am trying to call a webservice with basic authentication.
I could call the webservice and load the data into qlikview ,But how can I authenticate the webservice with basic username and password.
I have tried passing the username and password in url but it doesn't give desired results.
below is my code
function getData()
Set xmlhttp = CreateObject("Microsoft.XMLHTTP")
Set objXML2 = CreateObject("Microsoft.XMLDOM")
call xmlhttp.open("GET", "http://Username:Password@url",False)
xmlhttp.setRequestHeader "Authorization", "Basic dXNlcm5hbWU6cGFzc3dvcmQ="
xmlhttp.setRequestHeader "Content-Type", "text/xml"
xmlhttp.send ""
result =xmlhttp.responseText
getData = result
ThankYou.