Execute project query by RTC api in c#
Hi
I have a problem with get query result from my project. How can i do this?
For ex.
Result of my query:
Id Name
--------------------
1 Josh
2 Jack
3 Thomas
I want to write it to DataTable.
Greetings |
Accepted answer
Ralph Schoon (63.4k●3●36●46)
| answered Nov 08 '21, 11:31 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER I am sorry, but this is by no means enough as a question to be able to answer. Please be aware of https://rsjazz.wordpress.com/2013/03/14/what-apis-are-available-for-rtc-and-what-can-you-extend/ and https://jazz.net/wiki/bin/view/Deployment/CLMProductAPILanding . With C# you will most likely want to use the OSLC or the reportable REST API https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI#Reportable_REST_API .
Also see another option: https://jazz.net/wiki/bin/view/Main/ResourceOrientedWorkItemAPIv2#Querying_Work_Items
Krzysztof Płazio selected this answer as the correct answer
|
2 other answers
Hi.
In my project i have Work Item Query, and i want to execute it and write data from my query result to DataTable in my C# program.
For ex. my query select ID and Name from type Defect, and result of this query is:
Id Name
--------------------
1 Josh
2 Jack
3 Thomas
and I want to write this data to DataTable variable by REST API.
What should I do? I found something like this:
https://<url>.<domain>/ccm/resource/itemOid/com.ibm.team.workitem.query.QueryDescriptor/<queryId>?_mediaType=text/csv
It's result, which i want to get, but in *.csv file. I want to get the same result like in this csv file, but write into DataTable by API.
Kind regards
|
Ralph Schoon (63.4k●3●36●46)
| answered Nov 09 '21, 6:26 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER I have provided you with all links you can use for self enablement I can. The links include how to run queries. In the example above use a different media type such as text/xml to get the data in the response and not as csv file. |
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.