authentication in calling a webservice

[Anonymous]

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.