Import JIRA REST API results to Excel Web Power Query

[Nigel Domaingue]

I am trying to create a Power Query feed into an Excel file that presents all the Issues listed under a given Epic.  I have already verified that the REST API URL delivers the content that I am looking for by testing it in the Restless browser plugin, and here is the query:

https://jira.XXXXXX.com/rest/api/latest/search?jql=cf[10182]=XXX-845

In Excel, I start creating a new Get Data: From Web import.  In the Advanced view, I provide my validated URL. 

Without any additional config information, I get an error 400, which I assume is because our Jira server requires authentication.  No problem, maybe it needs the same Basic authentication that the Restless plugin needed.

So, I add an HTTP header of type 'Authorization', and provide the details that the Restless client used successfully.

Next error is this: "The 'Authorization' header is only supported when connecting anonymously. [...]"

Has anyone else managed to successfully import REST API data from a Jira Server into Excel and can offer solutions for my problem, so that I can import my data feed into my Excel dashboard?

Regards,

Nigel

Jira Server 7.12

Excel is latest edition, part of a corporate 365 subscription.

[Arun Ravindran]

Hi Sopan

Thank you for using Zephyr.With regards to your query in ZAPI as per the test execution flow,if you are changing the status of an existing executed Test Case and if the new execution status is the same as that of old one you would get a message that "The Test case is already in <XXXX> status".DId you receive any error message or similar message when you changed it from PASS to PASS.

As it is by design if you change the status to another one it will be successfully done.Kind;ly send us the error message or any other relevant message when you performed the first task.

Thanks

Zephyr Support

[Sopan Sagorkar]

Hi Arun, Thanks for your response actually there is NO error message.

[Sopan Sagorkar]

Hi @Arun Ravindran Can you please tell me how can i update particular Test Case status using ZAPI. For ex: I have 4 Test Cases but i want to update status of only 2 Test Case so how it can be done !!!

[Arun Ravindran]

Hi Sopan You can refer our apiary document http://docs.getzephyr.apiary.io/#executionresourceapis And you can update the status by passing the execution id as mentioned in the API /jira_server/rest/zapi/latest/execution/{id}/quickExecute Also Sopan,it would be better if you sign up to our support site and raise a ticket with us a sour ticketing system is highly responsive and our ZAPI experts will clear all your queries via ticket. Please sign up to our support site "https://support.getzephyr.com/hc/en-us"; and use the option "Submit a case" to raise a ticket with us and an engineer will reach out to you soon Thanks ZephyrSupport

[mogalapa]

Hi ,

Is there any way i can update multiple testcases status at a time using zapi.

currently i using 

jira_server/rest/zapi/latest/execution/{id}/execute, but with this i am not able to update teststatus of more than 1 testcase at a time

[navdsharma]

Hi

Give this a go:

https://zapitest.docs.apiary.io/#reference/execution-resource-api(s)/execution/put