none
"The server returned an invalid or unrecognized response" from Excel macro RRS feed

  • General discussion

  • Hi Experts

    I am writing macro to Post XML for insert/update one Siebel record. In Siebel Server side I am using Upsert method of EAI Siebel Adapter BS to create record. Now in Excel macro I am using "winhttp.winhttprequest.5.1" object.  My macro is  first login into the application, POST the XML and then logging off from the application. 


    Set httpTarget = CreateObject("WinHttp.WinHttpRequest.5.1")

    httpTarget.Open "POST", "https://10.160.222.20:4443/eai_enu/start.swe", False

    httpTarget.send (?SWEExtSource=TMSiebelUpsert&SWEExtCmd=ExecuteLogin&UserName=SADMIN&Password=vfq1adm)

    dim strCookie = httpTarget.getResponseHeader("Set-cookie")

    httpTarget.setRequestHeader "content-type", "application/x-www-form-urlencoded;charset=UTF-8"
    httpTarget.setRequestHeader "cookie", strCookie

    httpTarget.Open "POST", "https://10.160.222.20:4443/eai_enu/start.swe", False
    httpTarget.setRequestHeader "content-type", "application/x-www-form-urlencoded;charset=UTF-8"
    httpTarget.setRequestHeader "cookie", strCookie

    httpTarget.send strRequest

    where strRequest is the XML which I am willing to post

    But after the last statement I am getting below error 

    "the server returned an invalid or unrecognized response"

    Need your help and suggestion to resolve the issue

    Thanks in Advance 

    Tamal Ghosh 

      

    Wednesday, August 24, 2016 3:28 PM