cancel
Showing results for 
Search instead for 
Did you mean: 

Get instance status through RESTful SDK

DellSC
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

daniel_paulsen
Active Contributor
0 Kudos

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

former_member197386
Active Contributor
0 Kudos

Hello all,

In next SP of 4.1 stream, more details will be available using Raylight API (for Webi instances).

Best regards,

Anthony

DellSC
Active Contributor
0 Kudos

Unfortunately, I need it mainly for Crystal reports...

It would be really nice if there were a way to get a specific list of properties from the RESTful web services - like we're able to do in an InfoStore query in the other SDKs.

-Dell

Message was edited by: Dell Stinnett-Christy

former_member197386
Active Contributor
0 Kudos

Hello Dell,

I'm the architect of Web Intelligence webservices only... Hope the CR team will give you an answer quickly.

Best regards,

Anthony

Former Member
0 Kudos

I have the same issue, getting status of scheduled Crystal Report from RESTful

is it possible to have an answer to this post? Please could you ask your collegues to answer?

Former Member
0 Kudos

Hi Riccardo / Dell,

We are planning to enhance REST APIs for Crystal Reports and will include this requirement.

Regards

Sumitesh 

Former Member
0 Kudos

Also, can you please let me know the list of properties that you are looking from apart from status?

Regards

Sumitesh

Former Member
0 Kudos

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.

Answers (0)