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!
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!