It's all about the answers!

Ask a question

REST API Syntax: Export ALL Test Scripts with Steps from RQM


MK Skelton (2515) | asked Feb 13 '19, 1:38 p.m.
Hello,

I am able to successfully export one script with its steps via a REST API added to Chrome. The GET result is an XML file, which I have not been able to successfully convert into a CSV file, yet. -Different problem

How can I capture all 23,000 scripts including their steps -I can export the scripts from RQM, but the steps aren't included, hence the REST GET:

https://rqmserver:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/projectarea/executionscript/urn:com.ibm.rqm:executionscript:2134

This example captured test script 2134 and its steps.

Thank you,
Matt

2 answers



permanent link
Paul Slauenwhite (8.4k12) | answered Feb 15 '19, 6:04 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

Matt, you can use a feed request (see https://jazz.net/wiki/bin/view/Main/RqmApi#feedUrl_for_interaction_with_a_f).  Make sure you pass the abbreviate=false request parameter (see https://jazz.net/wiki/bin/view/Main/RqmApi#abbreviate).


permanent link
MK Skelton (2515) | answered Feb 15 '19, 12:32 p.m.
Thanks Paul.  We found a manual way to get this, though very manual:

  1. In RQM, under “Planning”, select a test plan.
  2. Once the plan is open, then select the “PDF EXPORT” with “Export Comprehensive”.
  3. This can be done on all plans and it will list the scripts and steps which can be transferred (via the pdf export).
  4. Open it in Acrobat Pro > File > Export To > Spreadsheet > Microsoft Excel Workbook.

Comments
Paul Slauenwhite commented Feb 19 '19, 7:31 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

This appears to be a solution for the CSV conversion issue. In this case, consider CSV export (see Exporting test-artifact list views as CSV files). 


MK Skelton commented Feb 19 '19, 10:33 a.m.
Hi Paul,

If you export the Test Plans via the "export as .csv", it will not capture the Test Scripts' Steps, unfortunately.  But, the four-step sequence above allows you to get that granular.

Thanks 

Your answer


Register or 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.