Execute project query by RTC api in c#
Accepted answer
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
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:
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
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