Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

SOAP Call XML Response 417 Expectation Failed

Dear Forum,

 

I receive an error when requesting an XML as dataset via SOAPCall (endpoint hosted locally) under Windows 10.

Same call executed with SOAP-UI or Python (requests/XMLResponse) on the same Windows 10 maschine responding no issues...

 

Error-Message:

DataSource.Error: Web.Contents failed to get contents from 'http://endpoint-URL/' (417): Expectation Failed
Details:
    DataSourceKind=Web
    DataSourcePath=http://endpoint-URL/
    Url=http://endpoint-URL/

 

Query:

let
    Source = Xml.Tables(Web.Contents("http://endpoint-URL:80",[Content=File.Contents("c:\env\Envelope.xml"),Headers=[#"Accept-Encoding"="gzip,deflate", #"Content-Type"="text/xml;charset=UTF-8"]])),
    #"Expanded Table" = Table.ExpandTableColumn(Source, "Table", {"Name", "Table"}, {"Table.Name", "Table.Table"}),

.......

 

The same query works when PBI-Desktop is running under Windows 7.

 

Any idea?

  • Hi Anonymous,

     

    For this problem, I would suggest you submit a support ticket for further analysis.

     

    Regards,

    Yuliana Gu

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Anonymous,

     

    For this problem, I would suggest you submit a support ticket for further analysis.

     

    Regards,

    Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable

    Still have this issue...

    Does .net under Win10 behave different from Win7?

     

    SOAP-UI and Python showing no problems.

    • Anonymous's avatar
      Anonymous
      Not applicable

      After checking the trace files and asking Mr. Internet I found the reason for....

      I had to set a proxy exception within the IE LAN-settings. .net, what's running under the hood of PBI behaves different to Python SOAP-Calls out of VS Code...