Issue in JIRA VBA Code

[AthmanArumugam]

Hi All,

I used the below code to connect to JIRA hosted in cloud in my organization.
It connects but the response I get is not complete.
I get incomplete response. But when executed using postman, I get lot many projects.
Could anyone let me know what is the issue.

Also sometimes I get an error message

Response:-
{"expand":"projects","projects":[]}



Code Used:

As many times, You've gotten a note >>> use code - tags <<<

    Set objHTTP = CreateObject("WinHttp.WinHttpRequest.5.1")
    Url = "https://track.autozone.com/rest/api/2/issue/createmeta/"
    objHTTP.Open "GET", Url, False
    objHTTP.setRequestHeader "Content-Type", "application/json"
    objHTTP.setRequestHeader "Accept-Encoding", "gzip, deflate,br"
    objHTTP.setRequestHeader "Accept-Encoding", "identity, deflate"
    objHTTP.setProxy 2, "proxy:80", ""
    objHTTP.send " {""username"" : """ & JIRA_USER & """, ""password"" : """ & JIRA_PWD & """}"
    strResponseStatus = objHTTP.Status
    strResponseText = objHTTP.ResponseText
    strResponseText = VBA.Strings.StrConv(objHTTP.ResponseText, vbUnicode)
    strResponseText = CStr(strResponseText)

 

[AthmanArumugam]

Hi,

I am getting the below error. Could anyone let me know how to solve it.
Actually I am working to connect with JIRA using excel macro.

 

[AthmanArumugam]

HI,

Has anyone worked in getting JIRA data using excel VBA. I am struggling for the past few months. I would be immensely grateful if anyone can help me here.