Get data from SOAP API

[webportal]

I'm trying to get the data from a SOAP API.

How to convert the following JavaScript into a Power Query M query?

<script type="text/javascript">
 var xmlHttp = new XMLHttpRequest();
 xmlHttp.onreadystatechange = function() { 
 if (xmlHttp.readyState == 4 && xmlHttp.status == 200)
 console.log(xmlHttp.responseText);
 }
 xmlHttp.open("POST", 'https://login.keyinvoice.com/API3_ws.php?wsdl', true);
 xmlHttp.setRequestHeader('Content-Type', 'text/xml');
 xmlHttp.send('\<\?xml version="1.0" encoding="UTF-8"\?\> <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="urn:KI_API3" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><SOAP-ENV:Body><ns1:authenticate><apikey xsi:type="xsd:string">A SUA CHAVE API</apikey></ns1:authenticate></SOAP-ENV:Body></SOAP-ENV:Envelope>');
 </script>

Any help?

Thanks in advance!

[Mikelytics]

Hi @webportal 

Have you tried working with the web connector in advanced mode? I know it works good for http requests.

I also found the follwoing community article refering to the following video. I checked the video and their the presenter connects to a Web API in minute 19.

Connecting Power BI to REST APIs... - Microsoft Power BI Community

Working with web services in Power Query/Excel and Power BI - YouTube

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn