如何调用受Excel宏保护的kerberos网络服务？ [英] How to call a webservice that is kerberos protected from Excel Macro?

问题描述

我在Weblogic 9.2中部署了一个Web服务。 Web服务受Kerberos（SSO）保护。我需要从excel宏调用webservice。有人可以告诉我如何继续这个。我是Kerberos和Excel Macro的新手。以前我用以下方式拨打
网络服务：

I have a webservice deployed in Weblogic 9.2. The webservice is Kerberos(SSO) protected. I need to call the webservice from an excel macro. Can anybody please tell me how to proceed on this. I am new to Kerberos and Excel Macro. Previously I was calling the webservice in the following manner:

   设置objHTTP = CreateObject（" MSXML2.XMLHTTP"）

   设置xmlDOC = CreateObject（" MSXML.DOMDocument"）

    

    objHTTP.Open" POST"，strWebserviceURL，False

    objHTTP.setRequestHeader" Content-Type"，" text / xml; charset = utf-8"

    objHTTP.setRequestHeader" User-Agent"，" Jakarta Commons-HttpClient / 3.0"

       

    On Error GoTo ShowErrorMsg

    

    objHTTP.send（SOAPMessage）

    Set objHTTP = CreateObject("MSXML2.XMLHTTP")
    Set xmlDOC = CreateObject("MSXML.DOMDocument")
    
    objHTTP.Open "POST", strWebserviceURL, False
    objHTTP.setRequestHeader "Content-Type", "text/xml;charset=utf-8"
    objHTTP.setRequestHeader "User-Agent", "Jakarta Commons-HttpClient/3.0"
       
    On Error GoTo ShowErrorMsg
    
    objHTTP.send (SOAPMessage)

现在webservice已经实现了Kerberos SSO，所以现在我很困惑如何调用webservice。

Now the webservice has implemented Kerberos SSO, so now I am confused how to call the webservice.

我试过了通过将请求标头设置为：

I have tried it by setting the request header as :

objHTTP.setRequestHeader"Authorization"，"Negotiate< base64 encoding>"

objHTTP.setRequestHeader "Authorization", "Negotiate <base64 encoding>"

但是给我一个肥皂故障。

But its gives me a soap fault.

如果有人能给我一个webservice接受复杂类型的样本，那将是很棒的。

It would be great if anyone can give me a sample where the webservice accepts complex types.

提前致谢。

推荐答案

您好，

感谢您在MSDN论坛中发帖。

Thank you for posting in the MSDN Forums.

我建议您先前的一个问题，它会为您提供有关如何在VBA中调用Web服务的一些想法。请参阅此内容并在您的案例中使用它。 http： //social.msdn.microsoft.com/Forums/en/isvvba/thread/4586c62e-7e10-4b7d-923a-f18b7dc6515c 。

I would suggest a previous issue which gives you some ideas about how to call a Web Service in VBA. Please refer to this and use it in your case.http://social.msdn.microsoft.com/Forums/en/isvvba/thread/4586c62e-7e10-4b7d-923a-f18b7dc6515c.

感觉可以免费联系如果有什么不清楚的话，和我在一起。

Feel free to get into touch with me if anything is unclear.

最好的问候，

这篇关于如何调用受Excel宏保护的kerberos网络服务？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！