How to extract artifact discussions using WSAPI

Document ID : KB000016712
Last Modified Date : 14/02/2018
Show Technical Document Details

Exporting artifact discussions (user story or defects) is not functional in Agile Central using the built in tools or Excel Add-in. 


Q - How can discussion posts from Agile Central artifacts be exported or extracted?


A- Currently there is no mechanism to export discussions from Agile Central using the page export tools or the Excel Add-in.  However, the discussion posts can be extracted using WSAPI.



Extract the data with a WSAPI query as follows:


1.     Retrieve the Object OID for the artifact from a URL where the user story or defect is in a detailed view within the application.




2.     From the ConversationPost object in the help pages (Developers > Web Services API)  insert a query in the query string entry box in form of ( Artifact = “/Artifact/<OID>” )

For this example it would be ( Artifact = “/Artifact/82138665616” ).  There should be spaces on each end of the bracketed query and before and after the equal sign.  Additionally, check the boxes for ‘Fetch full objects’ and ‘Beautified JSON output’ as shown here. Click on the Query button outlined in blue on the page.





3.     The following (partial) output will be returned, the Discussion post output to the right of the Text: is circled. In this example, the text post is ‘123456’.