API REST METHOD POST in PHP

[AGo]

Hello,

I've got this API documentation, and I'm trying to return a table in PowerBI, is it possible to embed it in a let statement in Power Query M Language?

<?php try{ $client = new SoapClient('http://ws.site.com/soap/vrmsInputServices.php?wsdl');
$credentials = array(
"Language" => "ES", "UserName" =>
"username",
"Password" => "password" );
$criteria = array();
$request = array( "Credentials" => $credentials );
$result = $client->GetCodes($request);
print_r($result); } catch(SoapFault $e){ echo $e; }?>

Many thanks

[dax]

Hi @AGo , 

If you want to use POST in REST API, you could refer to web-services-and-post-requests-in-power-query  and postimport for details.

Best Regards,
Zoe Zhi

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

[AGo]

I try to pass the post statement in xml wit this query, I was expecting wrong credential message but it returns Values and Attribute lists for this namespace

http://schemas.xmlsoap.org/wsdl/

let
content ="<soapenv:Envelope>
<soapenv:Header/>
<soapenv:Body>
<xsd:GetAccommodationCodesRQ>
<crs:Credentials>
<crs:UserName>?</crs:UserName>
<crs:Password>?</crs:Password>
</crs:Credentials>
</xsd:GetCodesRQ>
</soapenv:Body>
</soapenv:Envelope>",

Source = Xml.Document(Web.Contents("http://ws.site.com/soap/vrmsInputServices.php?wsdl", [Content=Text.ToBinary(content)]))
in
Source

Maybe @ImkeF can help

Thanks