Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to pull WebTrends data into QV using their REST URL data extraction methodology. However, you cant embed an ID and PW in the REST URL and QV doesnt prompt for a login (unlike Excel which knows to prompt for a login.)
Does anyone know how to authenticate from a REST URL call?
I'm trying to do the same with some success. I haven't finished my module yet but it is half way there.
Basically, I set my username and password as variables which can be set in the module or the values can be added into the app.
Then in my module I simply have:
Set g_objHttp=CreateObject("MSXML2.XMLHTTP")
g_objHttp.Open"GET","https://WEBTRENDSDOMAIN/v2_0/ReportService/profiles/?format=xml",false,loginName,loginPassword
g_objHttp.send()
g_objResult=g_objHttp.responseText
At the moment, I'm just using this to create an output file and use it in LOAD script immediately after.
I use Webtrends OnPremise but I guess it would be more or less the same for Ondemand
Hope this helps