Forum Discussion

Manal's avatar
Manal
Regular Visitor
10 years ago

How to get data from a SOAP WS with Power BI

Hello,   I have an application with a SOAP wb and I want to create Dashboards using Power BI Desktop. How do I get data using the SOAP wb ?  I know that Power BI has a REST API and it says that i...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I ve got the same issue

with the query:

 

 

 

   let
    body="<soapenv:Envelope xmlns:soapenv=#(0022)http://schemas.xmlsoap.org/soap/envelope/#(0022) xmlns:csv=#(0022)http://www.csv.org#(0022)>
   <soapenv:Header/>
   <soapenv:Body>
        <csv:ReportTransactions>
         <csv:DateFrom>2020-01-01</csv:DateFrom>
         <csv:DateBy>2020-01-04</csv:DateBy>
         <csv:UNP>691759953</csv:UNP>
      </csv:ReportTransactions>
   </soapenv:Body>
</soapenv:Envelope>",

    Source = Xml.Tables(Web.Contents("http://XXXXX.1cws?wsdl",
    [Content=Text.ToBinary(body), 
    Headers =[
        #"Authorization" = "basic XXXX",
        #"Accept-Encoding"= "gzip,deflate",
        #"User-Agent"= "Apache-HttpClient/4.1.1 (java 1.5)",
        //#"Content-Length"="360",
        //SOAPAction="#(0022)http://www.csv.org#JI_WScsv:ReportTransactions_DD#(0022)",
        #"Content-Type"="application/soap+xml;charset=UTF-8;action=#(0022)http://www.csv.org#JI_WScsv:ReportTransactions_DD#(0022)",
        #"Connection"="Keep-Alive"]]))
in
    Source

 

 

it works in SOAP UI 

but it returns result  like no parameters are posted to service. Expanding of these tables does not give needed result

 

fiddler's header after SOAP UI  (when SOAP gives needed result)

 

Can anybody help whith it?

 

 
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have solved the problem

 

I needed in URL of WSDL - remove in the end "?wsdl"

 

let
    body="<soapenv:Envelope xmlns:soapenv=#(0022)http://schemas.xmlsoap.org/soap/envelope/#(0022) xmlns:csv=#(0022)http://www.csv.org#(0022)>
   <soapenv:Header/>
   <soapenv:Body>
        <csv:ReportTransactions>
         <csv:DateFrom>2020-01-01</csv:DateFrom>
         <csv:DateBy>2020-01-04</csv:DateBy>
         <csv:UNP>691759953</csv:UNP>
      </csv:ReportTransactions>
   </soapenv:Body>
</soapenv:Envelope>",

    Source = Xml.Tables(Web.Contents("http://XXXXXXXXXXX/ws/ws_csv.1cws",
   
   // NOT http://XXXXXXXXXXX/ws/ws_csv.1cws?wsdl - 
   // this ending ?WSDL stopped the recieving of the response!


   [Content=Text.ToBinary(body), 
	Headers =[
        #"Authorization" = "basic XXXXXXXXXX",
        #"Accept-Encoding"= "gzip,deflate",
        #"Content-Type"="text/xml;charset=UTF-8"
           ]])),
    Table = Source{1}[Table],
    Table1 = Table{0}[Table],
    Table2 = Table1{0}[Table]
in
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Jonas1 

    juliovidigal 

    Yggdrasill 

    amitchandak 

    Hi All 

    I am facing issues while accessing the token bassed SOAP WSDL in Power BI.

    Also any other way to accomplish this task part from Zapsys ODBC

    Error 

    DataSource.Error: Web.Contents failed to get contents from 'https://sync.severa.com/webservice/S3/API.svc' (500): Internal Server Error
    Details:
    DataSourceKind=Web
    DataSourcePath=https://sync.severa.com/webservice/S3/API.svc
    Url=https://sync.severa.com/webservice/S3/API.svc

     

    Code in Advance Editor 

    let

    Source = Xml.Tables(Web.Contents("https://sync.XXXXXX/S3/API.svc"
    ,[Content=File.Contents("C:\XX\post.xml"),Headers=[#"Accept-Encoding"="gzip,deflate", #"Content-Type"="text/xml;charset=UTF-8"]]))
    in
    Source

     

    post.XML

    <?xml version="1.0"?>

    -<soapenv:Envelope xmlns:soap="http://soap.severa.com/" xmlns:ns1="http://soap.severa.com/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">-<soapenv:Header>

    <ns1:WebServicePassword>Api Token Key</ns1:WebServicePassword>

    </soapenv:Header>-

      <soapenv:Body>-

        <soap:GetHourEntriesByDate>

     

          <soap:startdate>2020-04-12T09:00:00</soap:startdate>

    <!--Optional:--></soap:GetHourEntriesByDate>

    </soapenv:Body>

    </soapenv:Envelope>

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Have you tried to get data with SOAP UI or POSTMAN software?

      If it is OK - then I recommend to watch carefully for the headers in POST metod.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Yes its working in SOAP UI and I have created above mentioned xml and query by following this thread.