on 06-06-2014 7:21 PM
I am working with a client who has integrated some BO 3.1 functionality into their application using the .NET SDK. I am evaluating their code because they are upgrading to BI4.1 and a lot of the code will have to be scrapped and rewritten because they are using classes that are no longer available in the 4.1 .NET SDK.
Ideally I'd like to rewrite the code using the RESTful web services. I can see how to get folders and reports, how to schedule reports, and most of the other functionality they'll need. However, I'm trying to figure out how to get a list of instances that belong to a report (Crystal or Webi) and the status of the instance (e.g., Success, Fail, Recurring, etc.) Is this capability available in the RESTful web services? If so, what is the request URI to get it?
Thanks!
-Dell
sorry Dell, no status for crystal instances, but webi does have status.
Get details of a report:
GET http://localhost:6405/biprws/infostore/5602
This will also show a link to latest instance
To get instances (can’t get status)
GET http://localhost:6405/biprws/infostore/5602/children
To get instances that are PDF or Crystal formats (format is
same as SI_KIND)
GET http://localhost:6405/biprws/infostore/5602/children?type=Pdf
GET http://localhost:6405/biprws/infostore/5602/children?type=CrystalReport
Webi (raylight) has more details (including status):
GET http://localhost:6405/biprws/raylight/v1/documents/5487/schedules
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<schedules>
<schedule>
<id>10336</id>
<name>Formatting Sample</name>
<format type="webi"/>
<status id="1">Completed</status>
</schedule>
</schedules>
Dan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Sumitesh,
At the moment I need the status and if possible the Error message (in case of failure of course).
Anyway I think the same info returned for Webi report with the query could be helpful http://localhost:6405/biprws/raylight/v1/documents/<reportID>/schedules
Thank you,
Riccardo.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.