Power Query API Question

[Kettle78]

Hi guys,

I am completely new when it comes to power query and using api (and to posting here so hello everyone). I hope this is a really simple question!

I am trying to get data from the following source http://marketinformation.natgrid.co.uk/MIPIws-public/public/publicwebservice.asmx to go into a table.

I have been provided with the following parameters:

<GetPublicationDataWM xmlns="http://www.NationalGrid.com/MIPI/">
<reqObject>
<PublicationObjectNameList>
<string>string</string>
<string>string</string>
</PublicationObjectNameList>
<FromDate>dateTime</FromDate>
<ToDate>dateTime</ToDate>
<DateType>string</DateType>
<LatestFlag>string</LatestFlag>
<ApplicableForFlag>string</ApplicableForFlag>
</reqObject>
</GetPublicationDataWM>

Alongside this, I have a data list file, specifically I require the Publication Object Name List item "SMP Buy, Actual Day".

However, I am a very very confused as to how to get this into the correctly formatted language in power query.

Anyway, thank you in advance for your help friends!

 

[Kettle78]

Apologies, these are the parameters provided

<getpublicationdatawm xmlns="http://www.NationalGrid.com/MIPI/">

<reqobject>




<string>string</string>

<string>string</string>



<fromdate>dateTime</fromdate>

<todate>dateTime</todate>

<datetype>string</datetype>

<latestflag>string</latestflag>

<applicableforflag>string</applicableforflag>

</reqobject>

</getpublicationdatawm>

 

[Kyle123]

I don't think you can all SOAP services directly with Power Pivot, I suspect that you'll need some sort of routine that gets the data and then load it into PP from there

 

[Kettle78]

Hi Kyle,

Thanks for the reply, and also for enlightening me!

Much appreciated,

Chris

 

[Kyle123]

Actually, have a look here: http://harrygates-essbase-blog.blogspot.co.uk/2016/09/power-query-how-to-connect-to-essbase.html

 

[Kettle78]

Brilliant! Exactly what I need!

Thanks Kyle!