BusinessObjects Board

How to use REST to query CMS (CI_INFOOBJECTS) V4.1 SP4

other Business Query
#1

Hey guys/gals,
I hope I am posting this in the appropriate area. I have searched and searched and am not having any luck. I am not a fan of the “Query Builder” at least not its interface and am building an app that will pretty much do the same thing it does just with a more friendly UI (at least thats the plan). The issue I am running into is trying to find out what URL to push the query to.

It looks like with BoBj 4.2 I can use “http://:/biprws/v1/cmsquery” and then use the Body to push the query (ex. SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND = ‘CrystalReport’). Is there a URL similar to the one mentioned previously for BoBj 4.1 SP4?

Any assistance you can provide will be greatly appreciated!!

Thanks,

Tom

tomvpr79 (BOB member since 2017-12-05)

#2

No, cmsquery is new in BI4.2.

What language are you working in? Querying the CMS is supported in all of the other SDKs: Java, .NET, COM.

joepeters :us: (BOB member since 2002-08-29)

#3

Thanks for the reply! I am using VB, but can use Java. Building a windows application, just not sure how to place a the call to CMS.

Thanks again!

tomvpr79 (BOB member since 2017-12-05)

#4

Which part? Submitting the CMS query?

joepeters :us: (BOB member since 2002-08-29)

#5

I think I am doing a poor job of explaining what I am trying to do! :slight_smile:

This is how I am thinking it should go…

  1. Create a post request to get logontoken (http://:/biprws/logon/long)
  2. Logon to cms and execute query (ex. SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND = ‘CrystalReport’) Pretty much just duplicating what querybuilder does using the query box.
    I am thinking I should be able to do this using C# or VB.

The second step is where I am having difficulty. I can get my logontoken and logon successfully, but I just cannot figure out how to submit the query.

Another option I am thinking about is using the Raylight and/or Infostore. I have been able to get results using them, I cannot seem to find a complete list of all their available options.

Any assistance would be appreciated!!

tomvpr79 (BOB member since 2017-12-05)

#6

What you’ve described is certainly feasible in BI4.2 with cmsquery, but that simply can’t be done with the REST API in BI4.1

However, there are Java, .NET, and COM libraries for interfacing with BO, that do not use the REST API, and therefore can be used to perform CMS queries (and a lot more). In fat, if you look at the source of Query Builder, it is actually using the Java SDK – you could rip out that code and build your utility from there.

Here is more info on the SDKs: https://archive.sap.com/documents/docs/DOC-27465

joepeters :us: (BOB member since 2002-08-29)