Forum Discussion

Aerospace1's avatar
Aerospace1
New Contributor
5 years ago

TM4J - Test case export and import

1) Export test case from TM4J to Excel: Is it possible an exported test case can include attachments or screenshots contained in TM4J ? If so, how would I do that? Note: the spreadsheet would be d...
MisterB's avatar
MisterB
Icon for Champion Level 3 rankChampion Level 3
5 years ago

For item 1)

 

Has anyone tried using the Attachments endpoint in the Zephyr API to try and resolve this requirement?

 

The API library is here: Zephyr Scale Server API (v1) (smartbear.com)

 

In the example JSON data of a successful execution, it does seem to indicate that a URL link could be clicked to access the attachments

MisterB's avatar
MisterB
Icon for Champion Level 3 rankChampion Level 3
5 years ago

Regarding question 2)

 

I guess it might be possible to convert your Excel file into JSON data, and if that were the case, I'm also guessing that you could use the API to update the test steps in your test cases - although I'm not sure about attachments.

 

We discussed this a little in this post: Not able to add teststep - SmartBear Community

 

And perhaps dsaju might be able to advise on their experience with importing results in this way?

 

 

  • lblivnat's avatar
    lblivnat
    New Contributor
    5 years ago

    Any advise in using the API in this way would be appreciated. My group has played with it a bit, but was never successful in getting screenshots to export from test executions in Word or PDF - any ideas from the community?

    • MisterB's avatar
      MisterB
      Icon for Champion Level 3 rankChampion Level 3
      5 years ago

      Hi

       

      I ran a test using the endpoint below and was able to return details including the path of attachments in a test execution.  That path successfully opens the attachment.

       

      For attachments to a test result:

      /testresult/{testResultId}/attachments

       

      For attachments to a step:

      /testrun/{testRunKey}/testcase/{testCaseKey}/testresult

       

      To implement:

      https://jira.[your instance].com/rest/atm/1.0/testresult/[testResultID]/attachments

       

      Thank you to Assis from the support team for providing info on how to find the testResultID:

       

      "You can find the testResultId in the following scenarios:

      • If you want to see the last execution of a Test Case, you will find it In the id of the result of {{ GET /testcase/ {testCaseKey}/testresult/latest }}
        * If your Test Execution is part of a Test Cycle, you can find it In the id of each item from the results of GET /testrun/{testRunKey}/testresults }}
        * When you create a Test Execution using one of the POST endpoints below, the response will return it in the id field
        ** {{ /testrun/{testRunKey}/testresults
        ** {{ /testrun/{testRunKey}/testcase/{testCaseKey}"