Create vba jira in excel
Hi,
If your jira version is 4.4.1 now let’s create a jira issue via VBA+SOAP+XML (first shall install soap toolkit, and invoke msxml dll ) the code will successfully "create a jira issue”, but it will fail to update the issue.
Here are the suggestions on how to resolve an issue via excel.
Dim token As Variant
Dim new issue, update issue As Variant
Dim issue map As Variant
Dim b As Boolean
Dim Soap Client
Set Soap Client = Create Object("MSSOAP.SoapClient30")
SoapClient.mssoapinit ("http://192.168.xx.xx:8079/rpc/soap/jirasoapservice-v2?wsdl")
'token = SoapClient.LogIn("jirauser", "jira")
Token = SoapClient. Log In ("dev", "123")
If Err <> 0 Then
wscript.echo "initialization failed” + Err. Description
End If
Dim new_xmlText, update_xmlText As String
new_xmlText = "<root>" & _
"<assignee>" & Range("A2") & "</assignee>" & _
"<project>" & Range("B2") & "</project>" & _
"<type>" & Range("C2") & "</type>" & _
"<summary>" & Range("D2") & "</summary>" & _
"</root>"
update_xmlText = "<root>" & _
"<id>summary</id>" & _
"<values>" & Range("F3") & "</values>" & _
"</root>"
Dim new_xmlDoc As New MSXML2.DOMDocument30
new_xmlDoc.async = False
new_xmlDoc.LoadXML (new_xmlText)
If (new_xmlDoc.parseError.ErrorCode <> 0) Then
Dim my Err
Set my Err = new_xmlDoc.parseError
MsgBox (myErr.reason)
Go To My End
Else
'MsgBox new_xmlDoc.xml
End If
Dim update_xmlDoc As New MSXML2.DOMDocument30
update_xmlDoc.async = False
update_xmlDoc.LoadXML (update_xmlText)
Dim new_XMLNodeList As MSXML2.IXMLDOMNodeList
Dim new_root As MSXML2.IXMLDOMElement
Set new root = new_xmlDoc.DocumentElement
Set new_XMLNodeList = new_root.ChildNodes
'Set new issue = SoapClient.createIssue(token, new_XMLNodeList)
Dim Field Values(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 Field Values(1) = update_XMLNodeList
Set update issue = SoapClient.updateissue(token, Range("C3"), Field Values)
The update issue error will be:org.xml.sax.SAXException: Found the character data inside an array element while desterilizing. You have to learn about issue syntax of jira update Remote Issue update Issue (java.lang.String token, java.lang.String issueKey, RemoteFieldValue [] actionParams).
This is the list's failed transfer cause the error or something else?
