Hi experts! I am new to Power BI and i am trying to do this task from last two days but I couldn't find any solution about this.Please help me to resolve my problem.I am using this code to get data from an Soup API into my power BI Desktop.
let body = "<soapenv:Envelope xmlns:soapenv=#(0022)http://schemas.xmlsoap.org/soap/envelope/#(0022) xmlns:ebiz=#(0022)http://xxxx.ServiceModel.SOAP#(0022)>
<soapenv:Header/>
<soapenv:Body>
<ebiz:SearchTransactions>
<!--Optional:-->
<ebiz:securityToken>
<!--Optional:-->
<ebiz:SecurityId>7187bd81-23f6-4466-a993-f0008187ab9a</ebiz:SecurityId>
<!--Optional:-->
<ebiz:UserId>?</ebiz:UserId>
<!--Optional:-->
<ebiz:Password>?</ebiz:Password>
</ebiz:securityToken>
<!--Optional:-->
<ebiz:filters>
<!--Zero or more repetitions:-->
<ebiz:SearchFilter>
<!--Optional:-->
<ebiz:FieldName>OrderID</ebiz:FieldName>
<!--Optional:-->
<ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>
<!--Optional:-->
<ebiz:FieldValue>001424</ebiz:FieldValue>
</ebiz:SearchFilter>
</ebiz:filters>
<ebiz:matchAll>true</ebiz:matchAll>
<ebiz:countOnly>false</ebiz:countOnly>
<!--Optional:-->
<ebiz:start>0</ebiz:start>
<!--Optional:-->
<ebiz:limit>10</ebiz:limit>
<!--Optional:-->
<ebiz:sort></ebiz:sort>
</ebiz:SearchTransactions>
</soapenv:Body>
</soapenv:Envelope>" ,
Source = Xml.Tables(Web.Contents("https://soap.xxx.net/xxxservice.svc" ,
[Content=Text.ToBinary(body),
Headers =[ #"Accept-Encoding"= "gzip,deflate",
#"Content-Type"="text/xml;charset=UTF-8" ]])),
Table = Source{1}[Table],
Table1 = Table{0}[Table]
in
Source
