How to use Excel VBA script to upload test step data to a Jira "Test" issue type

[Anthony Peate]

I have worked out how to use excel VBA script to create and retrieve Jira Issues objects from Jira using Json as per the retrieval example below:-

Function GetJiraIssue(IssueKey As String) As Object
Dim JiraService As New MSXML2.XMLHTTP60
Dim sRespTxt As String
IssueURL = JIRA_URL & "/rest/api/latest/issue/" & IssueKey
bpw64 = "Basic " & EncodeBase64(JIRA_USER & ":" & JIRA_PWD)
With JiraService
.Open "GET", IssueURL, False
.setRequestHeader "Content-Type", "application/json"
.setRequestHeader "Authorization", bpw64
.setRequestHeader "Set-Cookie", sCookie '*** see Create a "Cookie"
.send ""
sRespTxt = .responseText
End With
Call CopyToClipboard(DbgJsonText(sRespTxt, 4))
Set GetJiraIssue = ParseJson(sRespTxt)
End Function

Using this script above, when I examine a retrieved Jira "Test" issue that was added in Jira with test step data, I observed the test step data is not included in sRespTxt. So I have concluded the test step data must be stored in a different object from the Jira "Test" issue object.

So is there a way to use excel VBA similar to that above to:-

1.  Retrieve test steps from a Jira "Test" issue object?
2.  Add test steps to a Jira "Test" issue object?

I want to do this from an excel VBA script without using Zephyr and I can't find any examples on line showing how to do this.

Also similarly, is there a way using an excel VBA script to manage test cycle data as follows:-

1. Create and update test cycle objects?
2. Add Test cases to a test cycle?
3. Change test execution status of test cases contained within a a test cycle?