Forum Discussion
Solved
Dynamic Datasource automatic refresh
Dear Helpers,
I hope there is a solution to my issue:
I have an API Call that gets the latest energy prices from ENTSO-E Platform. I call the API as follows:
Source = Xml.Tables(Web.Contents("https://transparency.entsoe.eu/api?securityToken=" & "MYTOKEN" & "&documentType=A44&" & "in_Domain=" & #"ENTSO-E-Zone-DE" & "&out_Domain=" & #"ENTSO-E-Zone-DE" & "&periodStart=" & "202112312300" & "&periodEnd=" & Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow()),-1),"yyyyMMdd")&"2300", [Headers=[#"Content-Type"="application/xml"]])),When I publish it to the service it says, that it can't refresh automatic as I use a dynamic datasource. I guess that the calculated period end is the problem. Is there any way to solve this issue or a best practice with dynamic API calls?
I look forward to your suggestions
Best regards
Manuel
4 Replies
Dear arvindsingh802 ,
thank you very much for your reply. I have now this code, however get a 404 error message as I don't know where to put the [Headers=[#"Content-Type"="application/xml"]] Part:
Xml.Tables( Web.Contents( "https://transparency.entsoe.eu/api", [ RelativePath="", Query= [ securityToken="MYTOKEN", documentType="A75", processType="A16", in_Domain=#"ENTSO-E-Zone-DE", periodStart="202112312300", periodEnd=Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow()),-1),"yyyyMMdd")&"2300" ] ] ) )Can you help me out?
Best regards
Manuel
Your solution worked, I had another mistake in my code
