I did a GET and PUT for execution result record using RQMUrlUtility and it worked for me..

may be the xml that was being passed to do a PUT was invalid and hence the error was thrown

Below is the sample Execution Result xml that i used for updating using RQMUrlUtility -

<?xml version="1.0" encoding="UTF-8"?>
<executionresult xmlns="http://jazz.net/xmlns/alm/qm/v0.1/">
<identifier xmlns="http://purl.org/dc/elements/1.1/">https://myhost:9443/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/TEST_PROJECTAREA/executionresult/executionresult:1</identifier>
<title xmlns="http://purl.org/dc/elements/1.1/">tcase_0812_1_Rational AppScan Tester Edition_Firefox_BEA_upd</title>
<state xmlns="http://jazz.net/xmlns/alm/v0.1/">com.ibm.rqm.execution.common.state.passed</state>
<updated xmlns="http://jazz.net/xmlns/alm/v0.1/">2009-08-12T15:23:27.921Z</updated>
<owner xmlns="http://jazz.net/xmlns/alm/v0.1/">ADMIN</owner>
<machine xmlns="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1">Local Computer</machine>
<starttime xmlns="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1">2009-08-12T15:08:39.613Z</starttime>
<endtime xmlns="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1">2009-08-12T15:08:42.639Z</endtime>
<pointspassed xmlns="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1">1</pointspassed>
<pointsfailed xmlns="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1">0</pointsfailed>
<pointsattempted xmlns="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1">1</pointsattempted>
<pointsblocked xmlns="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1">0</pointsblocked>
<pointsinconclusive xmlns="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1">0</pointsinconclusive>
<pointspermfailed xmlns="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1">0</pointspermfailed>
<stepResults xmlns="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1">
<stepResult actualResult="" endTime="1250089719613" itemId="_BhmPYIdSEd6-S6-KyUglsw" result="com.ibm.rqm.execution.common.state.passed" startTime="1250089719613"/>
<stepResult actualResult="" endTime="1250089719613" itemId="_BhsWAIdSEd6-S6-KyUglsw" result="com.ibm.rqm.execution.common.state.passed" startTime="1250089719613"/>
<stepResult actualResult="" endTime="1250089719613" itemId="_BhsWAodSEd6-S6-KyUglsw" result="com.ibm.rqm.execution.common.state.passed" startTime="1250089719613"/>
</stepResults>
<testcase hr1ef="https://myhost:9443/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/TEST_PROJECTAREA/testcase/testcase:4"/>
<testscript href="https://myhost:9443/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/TEST_PROJECTAREA/testscript/testscript:2"/>
<executionworkitem href="https://myhost:9443/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/TEST_PROJECTAREA/executionworkitem/executionworkitem:13"/>
</executionresult>

use the appropriate server and Project Area containing all related artifacts like Test Case, Test Script etc

Thanks

But if I try to update that record (using the XML previously retrieved), I get an HTTP code 400:

java -jar RQMUrlUtility.jar -command PUT -user vrokosz -password <password> -filepath c:\temp\execrecFail.xml -url https://localhost:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager/executionresult/urn:com.ibm.rqm:executionresult:17

HTTP 400 response code means "Bad Request". That's normally seen when the resource URL is malformed or the specified project area does not exist. The URL in your example above looks right to me. Can you open that URL in your browser?

Seeing how the XML returned by the API uses references rather than containment, PUTing to a new server/project area can be tricky. To really succeed you need to follow the references and "doctor" them to point to the new source.
In this example you would try to PUT an executionresult, notice a labresource upon introspection, GET and PUT the dependent labresource, and then modify the labresource referred to in the executionresult to point to the new one you just created before PUTing the executionresult.
I understand you may not need labresource in this particular case but you will keep bumping into this sort of pattern in the future.
BTW, you only need to doctor the "href" and not the "id" (all references have 2 attributes: id and href).
Regards,
John

The problem turned out to be the labresource XML (I was using an execution record generated by the Command line adapter) - see below. Once I took out the labresource entry, the PUT succeeded.


<labresource>

Can anyone help me to get the RQM defect ID to a file by using command prompt or script (Perl or batch)

Thanks & Regard,
Adarsha

I guess I don't quite understand this. If I GET an execution record, modify it, and then PUT it back, doesn't this just update the existing record? I want to show that another execution record has been generated, IE: I executed the testcase again. It seems to me that I need to PUT a new record to show that a second test execution has occurred with new results, and I still want to see the first results, as well. But, how do I PUT a new execution record since I don't know what the executionresult ID is going to be?

I'm looking for a good example that shows how to use the RQM REST API to update records in RQM (particularly, execution records).

I can retrieve information using the RQMUrlUtility for an execution record:

java -jar RQMUrlUtility.jar -command GET -user vrokosz -password <password> -filepath c:\temp\execrecFail.xml -url https://localhost:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager/executionresult/urn:com.ibm.rqm:executionresult:17

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<<<<<RQMUrlUtility>>>>>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

RQMUrlUtility: Connected to localhost:9443 using project "Quality+Manager"
Aug 10, 2009 3:13:07 PM org.apache.commons.httpclient.HttpMethodDirector isRedirectNeeded
INFO: Redirect requested but followRedirects is disabled
RQMUrlUtility: Calling method to retrieve XML from a specified URL
RQMUrlUtility: Server Response code: 200
Aug 10, 2009 3:13:07 PM org.apache.commons.httpclient.HttpMethodBase getResponseBody
WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
RQMUrlUtility: XML string retrieved from URL : "https://localhost:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager/executionresult/urn:com.ibm.rqm:executionresult:17 " is written to file located at -: " c:\temp\execrecFail.xml "


But if I try to update that record (using the XML previously retrieved), I get an HTTP code 400:

java -jar RQMUrlUtility.jar -command PUT -user vrokosz -password <password> -filepath c:\temp\execrecFail.xml -url https://localhost:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager/executionresult/urn:com.ibm.rqm:executionresult:17

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<<<<<RQMUrlUtility>>>>>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

RQMUrlUtility: Connected to localhost:9443 using project "Quality+Manager"
Aug 10, 2009 3:17:00 PM org.apache.commons.httpclient.HttpMethodDirector isRedirectNeeded
INFO: Redirect requested but followRedirects is disabled
RQMUrlUtility: Calling method to upload XML from a specified file to URL
RQMUrlUtility: Server Response code: 400
Aug 10, 2009 3:17:00 PM org.apache.commons.httpclient.HttpMethodBase getResponseBody
WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.

I'd be interested in seeing an XML file that could be used with RQMUrlUtility to update an RQM record.....

Seeing how the XML returned by the API uses references rather than containment, PUTing to a new server/project area can be tricky. To really succeed you need to follow the references and "doctor" them to point to the new source.
In this example you would try to PUT an executionresult, notice a labresource upon introspection, GET and PUT the dependent labresource, and then modify the labresource referred to in the executionresult to point to the new one you just created before PUTing the executionresult.
I understand you may not need labresource in this particular case but you will keep bumping into this sort of pattern in the future.
BTW, you only need to doctor the "href" and not the "id" (all references have 2 attributes: id and href).
Regards,
John

The problem turned out to be the labresource XML (I was using an execution record generated by the Command line adapter) - see below. Once I took out the labresource entry, the PUT succeeded.


<labresource>

This worked for me! :) thanks!

I have facing same problem.
I used
"C:\jazz_2_0_0_2\server\jre\bin\java.exe" -jar RQMUrlUtility.jar -command GET -user asasasa@in.ibm.com -password ******* -filepath C:\XML\DownLoadTp1.xml -url https://9.126.40.182:9444/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Ansell/testplan/urn:com.ibm.rqm:testplan:1

<?xml version="1.0" encoding="UTF-8" ?>
- <ns2:testplan xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/" xmlns="http://purl.org/dc/elements/1.1/" xmlns:ns10="http://jazz.net/xmlns/alm/qm/v0.1/executionworkitem/v0.1" xmlns:ns11="http://jazz.net/xmlns/alm/qm/qmadapter/task/v0.1" xmlns:ns3="http://jazz.net/xmlns/alm/v0.1/" xmlns:ns4="http://schema.ibm.com/vega/2008/" xmlns:ns5="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1" xmlns:ns6="http://jazz.net/xmlns/alm/qm/v0.1/tsl/v0.1/" xmlns:ns7="http://jazz.net/xmlns/alm/qm/v0.1/testscript/v0.1/" xmlns:ns8="http://jazz.net/xmlns/alm/qm/qmadapter/v0.1" xmlns:ns9="http://jazz.net/xmlns/alm/qm/v0.1/catalog/v0.1">
<identifier xmlns="http://purl.org/dc/elements/1.1/">https://9.126.40.182:9444/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Ansell/testplan/urn:com.ibm.rqm:testplan:2</identifier>
<title xmlns="http://purl.org/dc/elements/1.1/">RP-TP-1</title>
<description xmlns="http://purl.org/dc/elements/1.1/" />
<ns3:updated>2011-08-03T14:25:58.813Z</ns3:updated>
<ns3:state>com.ibm.rqm.planning.common.new</ns3:state>
<creator xmlns="http://purl.org/dc/elements/1.1/">anasirud@in.ibm.com</creator>
<ns3:owner>unassigned</ns3:owner>
<alias xmlns="http://purl.org/dc/elements/1.1/">urn:com.ibm.rqm:testplan:2</alias>
<ns2:testcase href="https://9.126.40.182:9444/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Ansell/testcase/UC_100511_Mass_Created_86_TC_1" />
<ns2:testcase href="https://9.126.40.182:9444/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Ansell/testcase/UC_100511_Mass_Created_7_TC_1" />
<ns2:template href="https://9.126.40.182:9444/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Ansell/template/testplan/com.ibm.rqm.planning.templates.testplan.default" />
<ns2:requirement href="https://9.126.40.182:9444/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Ansell/requirement/UC_100511_Mass_Created_86" />
<ns2:requirement href="https://9.126.40.182:9444/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Ansell/requirement/UC_100511_Mass_Created_7" />
</ns2:testplan>


and it got succeeded.
But when i used PUT instead of GET i got success message but the XML is identical.
Is it possible??
because when put this XML in RQM server i got error response bad request response code 400.
pls can any one help me.

I guess I don't quite understand this. If I GET an execution record, modify it, and then PUT it back, doesn't this just update the existing record? I want to show that another execution record has been generated, IE: I executed the testcase again. It seems to me that I need to PUT a new record to show that a second test execution has occurred with new results, and I still want to see the first results, as well. But, how do I PUT a new execution record since I don't know what the executionresult ID is going to be?

I'm looking for a good example that shows how to use the RQM REST API to update records in RQM (particularly, execution records).

I can retrieve information using the RQMUrlUtility for an execution record:

java -jar RQMUrlUtility.jar -command GET -user vrokosz -password <password> -filepath c:\temp\execrecFail.xml -url https://localhost:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager/executionresult/urn:com.ibm.rqm:executionresult:17

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<<<<<RQMUrlUtility>>>>>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

RQMUrlUtility: Connected to localhost:9443 using project "Quality+Manager"
Aug 10, 2009 3:13:07 PM org.apache.commons.httpclient.HttpMethodDirector isRedirectNeeded
INFO: Redirect requested but followRedirects is disabled
RQMUrlUtility: Calling method to retrieve XML from a specified URL
RQMUrlUtility: Server Response code: 200
Aug 10, 2009 3:13:07 PM org.apache.commons.httpclient.HttpMethodBase getResponseBody
WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
RQMUrlUtility: XML string retrieved from URL : "https://localhost:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager/executionresult/urn:com.ibm.rqm:executionresult:17 " is written to file located at -: " c:\temp\execrecFail.xml "


But if I try to update that record (using the XML previously retrieved), I get an HTTP code 400:

java -jar RQMUrlUtility.jar -command PUT -user vrokosz -password <password> -filepath c:\temp\execrecFail.xml -url https://localhost:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager/executionresult/urn:com.ibm.rqm:executionresult:17

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<<<<<RQMUrlUtility>>>>>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

RQMUrlUtility: Connected to localhost:9443 using project "Quality+Manager"
Aug 10, 2009 3:17:00 PM org.apache.commons.httpclient.HttpMethodDirector isRedirectNeeded
INFO: Redirect requested but followRedirects is disabled
RQMUrlUtility: Calling method to upload XML from a specified file to URL
RQMUrlUtility: Server Response code: 400
Aug 10, 2009 3:17:00 PM org.apache.commons.httpclient.HttpMethodBase getResponseBody
WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.

I'd be interested in seeing an XML file that could be used with RQMUrlUtility to update an RQM record.....

I used the following command
"C:\jazz_2_0_0_2\server\jre\bin\java.exe" -jar RQMUrlUtility.jar -command PUT -user anasirasadsdud@in.ibm.com -password ***** -filepath C:\XML\DownLoadTp1.xml -url https://9.126.40.182:9444/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Ansell/testplan/urn:com.ibm.rqm:testplan:1

i got the error message

2
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<<<<<----- ---->>>>>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

RQMUrlUtility: Connected to https://9.126.40.182:9444 using project "Ansell"
Aug 3, 2011 8:32:35 PM org.apache.commons.httpclient.HttpMethodDirector isRedire
ctNeeded
INFO: Redirect requested but followRedirects is disabled
RQMUrlUtility: Calling method to upload XML from a specified file t
o URL
RQMUrlUtility: Server Response code: 400
Aug 3, 2011 8:32:35 PM org.apache.commons.httpclient.HttpMethodBase getResponseB
ody
WARNING: Going to buffer response body of large or unknown size. Using getRespon
seBodyAsStream instead is recommended.

Can any one help me out from this issue.

I guess I don't quite understand this. If I GET an execution record, modify it, and then PUT it back, doesn't this just update the existing record? I want to show that another execution record has been generated, IE: I executed the testcase again. It seems to me that I need to PUT a new record to show that a second test execution has occurred with new results, and I still want to see the first results, as well. But, how do I PUT a new execution record since I don't know what the executionresult ID is going to be?

I'm looking for a good example that shows how to use the RQM REST API to update records in RQM (particularly, execution records).

I can retrieve information using the RQMUrlUtility for an execution record:

java -jar RQMUrlUtility.jar -command GET -user vrokosz -password <password> -filepath c:\temp\execrecFail.xml -url https://localhost:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager/executionresult/urn:com.ibm.rqm:executionresult:17

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<<<<<RQMUrlUtility>>>>>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

RQMUrlUtility: Connected to localhost:9443 using project "Quality+Manager"
Aug 10, 2009 3:13:07 PM org.apache.commons.httpclient.HttpMethodDirector isRedirectNeeded
INFO: Redirect requested but followRedirects is disabled
RQMUrlUtility: Calling method to retrieve XML from a specified URL
RQMUrlUtility: Server Response code: 200
Aug 10, 2009 3:13:07 PM org.apache.commons.httpclient.HttpMethodBase getResponseBody
WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
RQMUrlUtility: XML string retrieved from URL : "https://localhost:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager/executionresult/urn:com.ibm.rqm:executionresult:17 " is written to file located at -: " c:\temp\execrecFail.xml "


But if I try to update that record (using the XML previously retrieved), I get an HTTP code 400:

java -jar RQMUrlUtility.jar -command PUT -user vrokosz -password <password> -filepath c:\temp\execrecFail.xml -url https://localhost:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager/executionresult/urn:com.ibm.rqm:executionresult:17

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<<<<<RQMUrlUtility>>>>>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

RQMUrlUtility: Connected to localhost:9443 using project "Quality+Manager"
Aug 10, 2009 3:17:00 PM org.apache.commons.httpclient.HttpMethodDirector isRedirectNeeded
INFO: Redirect requested but followRedirects is disabled
RQMUrlUtility: Calling method to upload XML from a specified file to URL
RQMUrlUtility: Server Response code: 400
Aug 10, 2009 3:17:00 PM org.apache.commons.httpclient.HttpMethodBase getResponseBody
WARNING: Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.

I'd be interested in seeing an XML file that could be used with RQMUrlUtility to update an RQM record.....