Forum Discussion

Manuel123's avatar
Manuel123
Icon for Helper I rankHelper I
4 years ago
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.Content...
Need Help
  • Manuel123's avatar
    Manuel123
    Icon for Helper I rankHelper I
    4 years ago

    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

    • Manuel123's avatar
      Manuel123
      Icon for Helper I rankHelper I
      4 years ago

      Your solution worked, I had another mistake in my code

      • fawa's avatar
        fawa
        New Member
        4 years ago

        Hi Manuel123 

         

        Can you share your solution?