1

Coming from this question : BO 4.X Webi download report from excel

I've started to create a VBA macro sending HTTP request to BO server, my goal being to get a report in Excel format (Using webservices or converting the incoming HTML of OpenDocument).

Problem is I can't get Logon token. I end up having a 404 tomcat error.

Does anybody have a clearer vision of what would the problem be ?

Below my suppositions :

Note : Though the Javascript workaround of the first link looks interesting, I'd like to avoid implementing additionnal unsupported layer.

Community
  • 1
  • 1
Sebastien FERRAND
  • 2,110
  • 2
  • 30
  • 62

1 Answers1

2

As you indicated, the Tomcat application server (or whichever appserver you selected to deploy the BOE app) cannot be used for the REST SDK.

The REST SDK is only available on the WACS server, which usually runs on the same server as the rest of your BI deployment, on port 6405. Keep in mind that this si the default setup; your environment may very depending on how it was set up.

FYI: the WACS server is nothing more than a slimmed down, embedded version of Tomcat.

If you'd like an easy way to test your REST calls, try a tool such as Postman (available for free, requires Chrome).

DocZerø
  • 8,037
  • 11
  • 38
  • 66
  • I do use Postman :) So you mean I sould be able to query WS function anyway an there is a problem in the way I'm calling it right ? (like for instance the port number) – Sebastien FERRAND Nov 05 '15 at 12:45
  • 1
    You'll need to update your existing query and include more detail about your code in order to find the exact cause of the errors – DocZerø Nov 05 '15 at 13:21
  • I solved it. For the records and beginers like me, I connected from my browser to CMC, clicked "Application" ==> "RESTful Web Service" ==> and there was the WS URL. – Sebastien FERRAND Nov 05 '15 at 14:03