How can you get data from WebTrends Via their REST URLs?

[#1]

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?

[Glenn_Renwick]

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