Dean:
I am actually the author of that application. Your question comes at a very opportune time. I had a bit of time on my hands and jus finished adding that code to the application and updated it to v1_1 as well. I will send it to you since it has not been posted yet.
Mike Love
Senior Solutions Engineer
Webtrends
I also use this this excellent Excel/VB app, could you forward me the latest version of the excel spreadsheet.
Regards
Simon:
I hope you are getting a lot out of the sample application. I have updated this version to support v1_1 of the REST API. I have also added new functionality so that you can place multiple reports on a sheet as well as do multiple queries and add new data to an existing report. I have added that new application with the updated documentation to this reply.
I am always interested in feedback on this. So, let me know what you think.
Mike
Hi,
Could you attach the spreadsheet or better publish the latest version
Cheers
Simon:
The new spreadsheet is an embedded object in the Word doc attached to my response to you blog reply. I am also attaching it here.
Mike
Hi Mike,
I downloaded your excel VBA file but my credentials did not work. Microsoft account has different generator URL so I am not sure if I need to enter additional credential information. Please advise.
Thanks,
Pinda
Pinda:
The sample application was written with the general customer in mind. I do understand that Microsoft uses a different site to access their data. If you wll provide me the domain name you use to access Webtrends via the generator, I can provide you either the changes needed to access your data or I can make the changes myself and send you a new Workbook. It is about three lines of code.
Mike
Thanks Mike:) Here is the MS Generator URL: https://msgenerator.webtrends.com/Account/Logon?ReturnUrl=%2f. I would really appreciate if you would send me the new workbook.
Thank you very much!
Pinda
Pinda:
My mistake. What I need is a sample of the REST URL from the generator when you log in and create a REST URL.
Sorry.
Mike Love
No problem:) Here is the REST URL for Referrer Site report on one of pur profiles: https://msws.webtrends.com/v1_1/ReportService/profiles/DifjitZd8G6/reports/92b64724c3ce/?totals=all&period=current_month&format=html&suppress_error_codes=true
Thanks again!
Pinda
Pinda:
A modified version is attached.
Mike
Pinda:
I am glad it works for you. I'll have to keep in mind the MS issue in future upgrades to this. To keep this as a single app I will probably add a check box on the log in to indicate which server gets the requests.
Mike