Forum Discussion

MisterB's avatar
MisterB
Champion Level 3
4 years ago

Export Excel Datasheet with Timestamp

Hi, I have test cases that are being executed multiple times a day.  I can see the date and timestamp of the executions in the reports on-screen but when I export to the related dataset to Excel for...
  • MisterB's avatar
    MisterB
    4 years ago

    Sharing the partial workaround recommended by the support team 

     

    ===================================================

     

    I am sorry to hear you are not getting enough information from the raw dataset. I will add this issue to our backlog and will get back to you as soon as we have it addressed.

     

    In the meantime, I can provide the following workaround if you are used to programming -

     

    If you usually execute tests on Test Cycles and given you know its keys, you can make a request to the following REST API endpoint and use the results according to your needs.

    • GET /testrun/{testRunKey}/testresults

     

    On our REST API, "testrun" means "Test Cycle". That means you will need to replace {testRunKey} with the Test Cycle key (for example, "YOURPROJ-C1").

     

    ===================================================

     

    As an example, the red text would be replaced the square brackets.  Below that, I've added an example of how it could look (note: the white spaces after "projectKey" are required)

     

    https://[YOUR JIRA INSTANCE]/rest/atm/1.0/testrun/[YOUR TEST CYCLE KEY]/testresults

     

    e.g. https://jira.abclimited.com/rest/atm/1.0/testrun/ABC-C100/testresults

     

     

     

MisterB's avatar
MisterB
Champion Level 3
4 years ago

Sharing the partial workaround recommended by the support team 

 

===================================================

 

I am sorry to hear you are not getting enough information from the raw dataset. I will add this issue to our backlog and will get back to you as soon as we have it addressed.

 

In the meantime, I can provide the following workaround if you are used to programming -

 

If you usually execute tests on Test Cycles and given you know its keys, you can make a request to the following REST API endpoint and use the results according to your needs.

  • GET /testrun/{testRunKey}/testresults

 

On our REST API, "testrun" means "Test Cycle". That means you will need to replace {testRunKey} with the Test Cycle key (for example, "YOURPROJ-C1").

 

===================================================

 

As an example, the red text would be replaced the square brackets.  Below that, I've added an example of how it could look (note: the white spaces after "projectKey" are required)

 

https://[YOUR JIRA INSTANCE]/rest/atm/1.0/testrun/[YOUR TEST CYCLE KEY]/testresults

 

e.g. https://jira.abclimited.com/rest/atm/1.0/testrun/ABC-C100/testresults