authentication in calling a webservice

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

topic authentication in calling a webservice in QlikView