Error when i excecute VBA macro that import information from JIRA issue

[ozaidris]

Hi community,

Please if someone can help me to fixe this ussue,

 I get the error below when i execute an VBA macro that i develop since 3 month using SOAP30, the problem is that the macro worked well, i test other Macro in VBA that use the same way (SOAP30) and also i get the same error in the same line of the code, really i don't know what's the problem is because the MSSOAP30.DLL is imported in references also i install the SOAP Toolkit 3.0 but every time the same error. I test the Macro in the computer of 2 of my colleagues and the Macro worked well.

the error apear in this part of the code :

LogIn = client.wsm_login(jiraUser, password)

Thank you so Much !!

[Nic Brough -Adaptavist-]

We can't really help you with this because:

1.  JIRA no longer has a SOAP interface, it went away several versions ago.  It doesn't look like it to me, but is it possible that the target JIRA has been upgraded to one that has no SOAP?

2.  If you are still using a version that does have the SOAP interface, the error you're seeing is in your VBA code.  We're a community of Atlassian users, not VBA people.  Some of us might know it, but it's a long shot.  You should really be asking in a VBA forum.

Of course, the correct thing to do here is forget it.  Upgrade the JIRA to a supported version and code for a REST interface.

[ozaidris]

Hi nic 

The macro worked for two of my collegue and we use the same vesion of jira, the macro worked since 3 month so i think the vba code is not a reason, there is something wrong in the jira configuration or something like this 

I need To solve this issue the earliest possible 

Thanks !!

[Nic Brough -Adaptavist-]

I'm afraid that doesn't change the answer. 

If it connects to JIRA over SOAP, then you have an old version of JIRA.

That is not the problem though, if you say it's working for other people, then it's absolutely somethin on your machine, not the JIRA side.

[ozaidris]

Yes, i Will try To perform the same code using rest api, a know how to create an issue using this aproach.. if i remenber i tried To update an issue using rest api but does not worked .. the response of the resquest show me that there is a problem so can you show me how it s look like ?

Otherwise i will be so thanksfull if you give me some helpfull vba codes.

Many thanks !!

[Nic Brough -Adaptavist-]

"It doesn't work" does not give us any information to go on.

Have a look through https://developer.atlassian.com/jiradev/jira-apis/jira-rest-apis/jira-rest-api-tutorials/jira-rest-api-version-2-tutorial to get started on how to use REST.