Is there an API available to directly pull RTC dat

问题:

Is there a way to programmatically access Rational Team Concert data through Excel VBA? I currently need to manually log into RTC, run a public query, then manually select the "Export to CSV" option. Ideally, I'd like to bypass all of these manual steps and access RTC data directly (or the set of data returned from a defined query with RTC).

回答1:

There is an API, a Java one.
This thread mentions there actually two APIs (detailled in this blog post, once you have setup those API):

• The Server API that is used in the server part of RTC (and JTS)
• The Client API that is used by the Eclipse Client and the Plain Java Client Libraries

The Plain Java Client Libraries are considerably smaller than the Client SDK and provide you with only a limited subset of the API.

But only the client SDK one seems to include the com.ibm.team.workitem.rcp.ui.internal.wizards.inport.WorkItemImportWizard class you would need.

That means you would need to:

create an extension to the Eclipse client and reuse the code used in the export wizard, similar to this blog post.