I am trying to create a JIRA using VBA. I am stuck at the creation step. Can anyone please guide me a bit on the same.
I have used the below sample code to create a JIRA. But I am stuck at the very last step while using the command createIssue.
Dim token As Variant
Dim newissue, updateissue As Variant
Dim issuemap As Variant
Dim b As Boolean
Set SoapClient = CreateObject("MSSOAP.SoapClient30")
'token = SoapClient.LogIn("jirauser", "jira")
If Err <> 0 Then
wscript.echo "initialization failed " + Err.Description
Dim new_xmlText, update_xmlText As String
new_xmlText = "<root>" & _
"<assignee>" & "USER" & "</assignee>" & _
"<project>" & "PROJECTNAME" & "</project>" & _
"<type>" & "Defect" & "</type>" & _
"<summary>" & "TestProject" & "</summary>" & _
"<priority>" & "High" & "</priority>" & _
Dim new_xmlDoc As New MSXML2.DOMDocument30
new_xmlDoc.async = False
If (new_xmlDoc.parseError.ErrorCode <> 0) Then
Set myErr = new_xmlDoc.parseError
Dim update_xmlDoc As New MSXML2.DOMDocument30
update_xmlDoc.async = False
Dim new_XMLNodeList As MSXML2.IXMLDOMNodeList
Dim new_root As MSXML2.IXMLDOMElement
Set new_root = new_xmlDoc.DocumentElement
Set new_XMLNodeList = new_root.ChildNodes
Dim FieldValues(1 To 1) As MSXML2.IXMLDOMNodeList
Dim update_XMLNodeList As MSXML2.IXMLDOMNodeList
Dim update_root As MSXML2.IXMLDOMElement
Set update_root = update_xmlDoc.DocumentElement
Set update_XMLNodeList = update_root.ChildNodes
Set FieldValues(1) = update_XMLNodeList
Set updateissue = SoapClient.createIssue(token, update_XMLNodeList)
I get a runtime automation error at the last step
Can you please help me out by pointing out where I might have gone wrong? I have googled the stuff quite a bit but to no avail. Thanks.
In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to have–in order to produce a reliable long-term roadmap. We're tur...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs