It's all about the answers!

Ask a question

How to update TSER with multiple results of test cases in RQM using REST API


0
1
Rachel Rogoway (1117) | asked Feb 23 '17, 1:09 a.m.

   Hi,


we are use in RQM for our automation. We have test suite that contains tests case.
and we are updating the results alone.
1.
I need to create/ update state of Test Case Execution Record. I need to update multiple results of test cases at once(- in one PUT request, by REST API), Is that possible?
 I can only successfully create TCER (and update state of TCER), but I want to create multiple TCERs and update multiple TCERs.
(this my PUT request for create TCER:
..../service/com.ibm.rqm.integration.service.IIntegrationService/resources/${project_area}/executionworkitem/urn:com.ibm.rqm:executionworkitem:ID)
2. 
Is that possible to create TCER with reference to the one TSER using REST API request?


Thank's
Rachel

7 answers



permanent link
Rachel Rogoway (1117) | answered Sep 03 '17, 10:48 a.m.

sure,

The XML can be obtained with a GET request:
(request url = '{serverURL}/service/com.ibm.rqm.integration.service.IIntegrationService/resources/{project name}/executionresult/urn:com.ibm.rqm:executionresult:{123=Any ID of TCR- testcaseresult})

sample XML:
<?xml version="1.0" encoding="UTF-8"?>
<ns2:executionresult xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/" xmlns:ns1="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:ns10="http://open-services.net/ns/core#" xmlns:ns11="http://open-services.net/ns/qm#" xmlns:ns12="http://jazz.net/xmlns/prod/jazz/rqm/process/1.0/" xmlns:ns13="http://www.w3.org/2002/07/owl#" xmlns:ns14="http://jazz.net/xmlns/alm/qm/qmadapter/v0.1" xmlns:ns15="http://jazz.net/xmlns/alm/qm/qmadapter/task/v0.1" xmlns:ns16="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1" xmlns:ns17="http://jazz.net/xmlns/alm/qm/v0.1/catalog/v0.1" xmlns:ns18="http://jazz.net/xmlns/alm/qm/v0.1/tsl/v0.1/" xmlns:ns20="http://jazz.net/xmlns/alm/qm/styleinfo/v0.1/" xmlns:ns21="http://www.w3.org/1999/XSL/Transform" xmlns:ns3="http://schema.ibm.com/vega/2008/" xmlns:ns4="http://purl.org/dc/elements/1.1/" xmlns:ns5="http://jazz.net/xmlns/prod/jazz/process/0.6/" xmlns:ns6="http://jazz.net/xmlns/alm/v0.1/" xmlns:ns7="http://purl.org/dc/terms/" xmlns:ns8="http://jazz.net/xmlns/alm/qm/v0.1/testscript/v0.1/" xmlns:ns9="http://jazz.net/xmlns/alm/qm/v0.1/executionworkitem/v0.1">
   <ns2:projectArea href="{projectArea_url}" alias="{projectAlias_url}" />
   <ns4:identifier>{result_url}</ns4:identifier>
   <ns2:webId>746328</ns2:webId>
   <ns4:title>{result_name}</ns4:title>
   <ns2:creationDate>2017-08-24T13:37:22.515Z</ns2:creationDate>
   <ns6:updated>2017-08-24T13:37:22.655Z</ns6:updated>
   <ns6:state>com.ibm.rqm.execution.common.state.failed</ns6:state>
   <ns4:creator ns1:resource="{creator_url}">{creator_userName}</ns4:creator>
   <ns6:owner ns1:resource="{owner_url}">{owner_userName}</ns6:owner>
   <ns2:locked>false</ns2:locked>
   <ns16:approvalstate ns1:resource="{server_url}/service/com.ibm.rqm.integration.service.IIntegrationService/process-info/_YlEkMaGWEeanZ-X-zBjfQw/workflowstate/com.ibm.rqm.process.testcaseresult.workflow/com.ibm.rqm.planning.common.new">com.ibm.rqm.planning.common.new</ns16:approvalstate>
   <ns2:variables />
   <ns16:iterations>1</ns16:iterations>
   <ns16:starttime>2017-08-24T13:37:10.628Z</ns16:starttime>
   <ns16:endtime>2017-08-24T13:37:21.843Z</ns16:endtime>
   <ns16:weight>100</ns16:weight>
   <ns16:pointspassed>0</ns16:pointspassed>
   <ns16:pointsfailed>100</ns16:pointsfailed>
   <ns16:pointsattempted>100</ns16:pointsattempted>
   <ns16:pointsblocked>0</ns16:pointsblocked>
   <ns16:pointsinconclusive>0</ns16:pointsinconclusive>
   <ns2:stateid>_W7oHGYjREeeghrRwe7jNZA</ns2:stateid>
   <ns2:pointspermfailed>0</ns2:pointspermfailed>
   <ns2:pointsdeferred>0</ns2:pointsdeferred>
   <ns16:isCurrent>false</ns16:isCurrent>
   <ns16:testcasestateatexecution ns1:resource="{server_url}/service/com.ibm.rqm.integration.service.IIntegrationService/process-info/_YlEkMaGWEeanZ-X-zBjfQw/workflowstate/com.ibm.rqm.process.testcase.workflow/com.ibm.rqm.planning.common.new">com.ibm.rqm.planning.common.new</ns16:testcasestateatexecution>
   <ns16:testscriptstateatexecution ns1:resource="{server_url}/service/com.ibm.rqm.integration.service.IIntegrationService/process-info/_YlEkMaGWEeanZ-X-zBjfQw/workflowstate/com.ibm.rqm.process.testscript.workflow/com.ibm.rqm.planning.common.new">com.ibm.rqm.planning.common.new</ns16:testscriptstateatexecution>
   <ns16:testedby>
      <ns16:tester ns1:resource="{tester_user_url}">{tester_user_name}</ns16:tester>
   </ns16:testedby>
   <ns16:stepResults />
   <ns2:testcase href="{testCase_url}" />
   <ns2:testsuitelog href="{testSuiteResult_url}" elementindex="0" />
   <ns2:testscript href="{testScript_url}" />
   <ns2:labresource href="{labresource_url}" />
   <ns2:executionworkitem href="{testCaseExecutionRecord_url}" />
   <ns2:attachment href="{attachment_url}" />
   <ns2:alias type="string">urn:com.ibm.rqm:executionresult:746328</ns2:alias>
</ns2:executionresult>


Good Luck!
Rachel


permanent link
Ajay Gera (3137) | answered Sep 01 '17, 7:31 a.m.

Hello Rachel,

Do you have any sample xml which we need to pass in post method?

Thanks,
Ajay Gera


permanent link
Rachel Rogoway (1117) | answered Aug 23 '17, 10:09 a.m.
ok.
in order to create TCR, you need its TCER url. (to set in xml data)
I don't know how to create TCER. I created via Excel.
but-

in order to get TCERs url,

you have to make GET request to all TCERs and link each TCR its TCER 
(request url = '{serverURL}/service/com.ibm.rqm.integration.service.IIntegrationService/resources/{project name}/executionworkitem')

and now-
You can post the TCRs with the xml attachment.
(request url = '{serverURL}/service/com.ibm.rqm.integration.service.IIntegrationService/resources/{project name}/executionresult')

goodLuck!
rachel


permanent link
Ajay Gera (3137) | answered Aug 23 '17, 9:30 a.m.

Rachel - Actually I am facing issues in creating new TCER and updating the result via REST API that's why I asked for sample code. please share the sample code (if you can).

My requirement is to create a new result without execution and update its status via REST API

Ajay


permanent link
Rachel Rogoway (1117) | answered Aug 23 '17, 9:16 a.m.

 Oh, that's irrelevant.

Finally- I created the TCER via Excel, while uploading tests cases to RQM.
good luck!
Rachel


permanent link
Ajay Gera (3137) | answered Aug 23 '17, 8:27 a.m.

Hello Rachel - Can you please post the example for creating new TCER and updating the result via REST API?



permanent link
Paul Slauenwhite (8.4k12) | answered Mar 01 '17, 6:41 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
  1. You can create multiple test artifacts in a single POST request using bulk upload (see https://jazz.net/wiki/bin/view/Main/RqmApi#Bulk_Upload).  However, each update operation has to be a different request.  Note, test cases are not associated to test results (see https://jazz.net/products/rational-quality-manager/api-doc-6.0.3/schemas/qm_xsd/complexTypes/abstract-testcase.html).  The reference is from test result to test case case execution record to test case.

  2. There aren't references between TCER and TSER (see https://jazz.net/products/rational-quality-manager/api-doc-6.0.3/schemas/qm_xsd/complexTypes/abstract-executionworkitem.html and https://jazz.net/products/rational-quality-manager/api-doc-6.0.3/schemas/qm_xsd/elements/suiteexecutionrecord.html).

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.