|
||||||||||||||||
|
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira |
||||||||||||||||
- [JIRA] (JENKINS-16030) Access to Jenkins C... [email protected] (JIRA)
- [JIRA] (JENKINS-16030) Access to Jenk... [email protected] (JIRA)
- [JIRA] (JENKINS-16030) Access to Jenk... [email protected] (JIRA)

I was able to find a solution to the problem that i was facing. I got reference from this issue - https://issues.jenkins-ci.org/browse/JENKINS-11944 and could convert that to Excel VB Macro. The solution for connecting from Excel macro to Jenkins server is
objWHTTP.Open "GET", url, False
UserID = "user"
UserPassword = "password"
authHeader = "Basic base64.encodestring(UserID, UserPassword)"
objWHTTP.SetRequestHeader "Authorization", authHeader
objWHTTP.SetCredentials UserID, UserPassword, HTTPREQUEST_SETCREDENTIALS_FOR_SERVER
Thanks to Orion for his python version of the solution. Have pasted the code above so that it could be helpful for folks facing the issue in future.