BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

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


 
Search this topic... | Search Business Query... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Business Query  Previous TopicPrint TopicNext Topic
Author Message
tomvpr79
Forum Member
Forum Member



Joined: 04 Dec 2017

Posts: 3



PostPosted: Mon Dec 04, 2017 8:33 pm 
Post subject: How to use REST to query CMS (CI_INFOOBJECTS) V4.1 SP4

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://<SERVER>:<PORT>/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
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6232
Location: Connecticut, USA


flag
PostPosted: Tue Dec 05, 2017 8:04 am 
Post subject: Re: How to use REST to query CMS (CI_INFOOBJECTS) V4.1 SP4

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.
Back to top
tomvpr79
Forum Member
Forum Member



Joined: 04 Dec 2017

Posts: 3



PostPosted: Wed Dec 06, 2017 9:33 am 
Post subject: Re: How to use REST to query CMS (CI_INFOOBJECTS) V4.1 SP4

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!
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6232
Location: Connecticut, USA


flag
PostPosted: Wed Dec 06, 2017 3:05 pm 
Post subject: Re: How to use REST to query CMS (CI_INFOOBJECTS) V4.1 SP4

Which part? Submitting the CMS query?
Back to top
tomvpr79
Forum Member
Forum Member



Joined: 04 Dec 2017

Posts: 3



PostPosted: Fri Dec 08, 2017 4:03 pm 
Post subject: Re: How to use REST to query CMS (CI_INFOOBJECTS) V4.1 SP4

I think I am doing a poor job of explaining what I am trying to do! icon_smile.gif

This is how I am thinking it should go...
1. Create a post request to get logontoken (http://<SERVER>:<PORT>/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!!
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6232
Location: Connecticut, USA


flag
PostPosted: Fri Dec 08, 2017 7:26 pm 
Post subject: Re: How to use REST to query CMS (CI_INFOOBJECTS) V4.1 SP4

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
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Business Query  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0107 seconds using 17 queries. (SQL 0.0026 Parse 0.0002 Other 0.0078)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo