0

Akhil Kumar (11●1) | asked Mar 11 '22, 6:53 a.m. Hi, Once a reported is exported using 'Export the Report to Microsoft Excel', it also gives me a URL which can be access using the browser.  We are intending to use that URL to import the data into a different system. URL syntax is  https://<domain name>/rs/query/121/dataservice?report=113&limit=-1&basicAuthenticationEnabled=true The above URL brings back all the records in the reports. The 'limit' parameter in the above link allows to set positive integer value. For example , the following URL will bring back 10 records  https://<domain name>/rs/query/121/dataservice?report=113&limit=10&basicAuthenticationEnabled=true Is there a way we could use paging here so I could also send a parameter link 'startRecord'. So something like as below (which does not work): https://<domain name>/rs/query/121/dataservice?report=113&startRecord=1&limit=10&basicAuthenticationEnabled=true https://<domain name>/rs/query/121/dataservice?report=113&startRecord=11&limit=10&basicAuthenticationEnabled=true etc This will allow me to bring back only certain number of records. My second question which is related to paging only, is it possible to amend the above URL to get total number of records in the report ? For example something like below: https://<domain name>/rs/query/121/dataservice/count?report=113&basicAuthenticationEnabled=true I have tried to search for documentation for how these endpoints are constructed but unable to so a link to some documentation would be helpful.

One answer

---

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