RQM API - Trying to export test scripts to csv - Feed displays same 512 items on every page
I am trying to export ~44000 test scripts (with test steps) to a csv file using this article - About exporting test scripts to CSV for a test case/all test cases in a Rational Quality Manager (RQM) project area. I am able to get back 83 pages of XML data. However, when I go to each subsequent page, the data is exactly the same - it's the same 512 initial test scripts that are on the very first page. Why would this be happening? How can I fix it so that I can see the test scripts beyond the first 512 items?
3 answers
You use the "next" URL to get the URL for the next page.
I have documented this here: https://rsjazz.wordpress.com/2022/03/02/ewm-reportable-rest-api/
That is for EWM, but it works the same way for ETM.
Dependent on the browser or environment, you might have to url unencode the request or not.
Comments
Yes, I did use the next URL, along with the one marked as page 83, along with one where I just filled in a page number. Every page brings back the same results as the very first page. That is the issue. I can't get any results beyond the first 512 items, no matter which page I go to. Why would this be happening? How do I fix it in order to get subsequent results?
Do you have any updates on my questions? I use the page links to try to get the next items in the feed, but it always returns the same items as the first page. Do you know how I can fix this issue?
This is a forum, not support. If you need support, you need to open a case with support.
If you always get the same, something in the query is wrong.
As per the documentation https://jazz.net/wiki/bin/view/Main/RqmAp the paging is controlled by an advanced property. Default is 50. I changed it to 5.
https://elm.example.com:9443/qm/projectAreaMetadata
https://elm.example.com:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/_MbiPAJuBEe-u4qRaQ3950w/testcase?token=_MIkQ0LJYEe-oCYgRSQYVaA&page=0
When you get the page information you might have to url decode/encode for this to work e.g. & might have to be replaced by & or vice versa. e.g.
https://elm.example.com:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/_MbiPAJuBEe-u4qRaQ3950w/testcase?token=_MIkQ0LJYEe-oCYgRSQYVaA&page=1
So works for me, as already suggested in my first answer.
Comments
If you always get the same, maybe your query is broken.
Available headers are explained here: https://jazz.net/wiki/bin/view/Main/RqmApi#HTTP_GET_Requests the one you use is not in the list.
Abbreviate works this way for me (RESTClient)
https://elm.example.com:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/_MbiPAJuBEe-u4qRaQ3950w/testcase?abbreviate=false&page=0
Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Nov 27 '24, 6:59 a.m.If you like to get an answer, you should provide more information e.g. the request you set, the headers, information about the response you get, especially the reference to the next page etc.
1 vote
Abbey Janicek
Nov 27 '24, 9:52 a.m.Abbey Janicek
Nov 27 '24, 9:56 a.m.