Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How consume jazz Reportable REST API programmatically using java

Hi,

I need to do some queries in Jazz and load the results into my company data warehouse. Someone have a example of a call simple query?

0 votes


Accepted answer

Permanent link
 Hi Rodrigo,

I think you can make use of OSLC Workshop materials. 

https://jazz.net/library/article/635

https://jazz.net/wiki/bin/view/Main/OSLCWorkshopDownload


I modified Example03.java to call https://localhost:9443/ccm/rpt/repository/workitem?fields=workitem/workItem/id API like below. I hope this might help you. Cheers.


public static void main(String[] args) {

//============== Code to adapt to your own configuration =============//

String server = "https://localhost:9443/ccm"; // Set the Public URI of your RTC server

String login = "clmadmin"; // Set the user login 

String password = "clmadmin"; // Set the associated password

//============== -------------------------------------- =============//

String reportAPI = server + "/rpt/repository/workitem?fields=workitem/workItem/id";

// Setup the HttClient

HttpClient httpclient = new DefaultHttpClient();

HttpUtils.setupLazySSLSupport(httpclient);

// Setup the rootServices request

HttpGet reportDoc = new HttpGet(reportAPI);

reportDoc.addHeader("Accept", "application/rdf+xml");


try {

// Request the Root Services document

HttpResponse reportResponse = HttpUtils.sendGetForSecureDocument(

server, reportDoc, login, password, httpclient);

HttpUtils.printResponseBody(reportResponse);

reportResponse.getEntity().consumeContent();



Rodrigo Gonzato selected this answer as the correct answer

3 votes

Comments

Thanks  Kohji, Work!

Another question:

The Reportable REST API have a operator similar"oslc.searchTerms"?

I need to do a search based on the content of comments , Like This: https://localhost:9443/ccm/rpt/repository/workitem?fields=workitem/workItem//comments[content contains "pattern"]/comments/content
its possible?

Hi Rodrigo,


I am not an expert of XPath, but I am guessing you might be able to use XPath syntax. 

I have been trying like below, however, it doesn't work.

Looking at the XPath specification is right. But, do not work for me too.

No problem...
I'll take the full content of comments and search programmatically
.

Thanks for the trouble.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 235
× 137

Question asked: Nov 16 '15, 7:32 a.m.

Question was seen: 3,885 times

Last updated: Nov 20 '15, 12:21 p.m.

Confirmation Cancel Confirm