With the current energy prices I want to see when it's most favorable to do energy heavy stuff.
Here in Denmark we can make API call to a data hub to see energy prices at an hourly rate for current day and for the next day.
So potentially 48h in to the future if the API call I made at 00.01 o'clock.
For this I make the API call at https://api.energidataservice.dk/dataset/Elspotprices?start=now&filter={"PriceArea":"DK2"}&sort=HourDK
[{"id":"0c9e143f916d7ede","type":"debug","z":"f6979629ded1c46f","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":1410,"y":4560,"wires":[]},{"id":"3845925bb4cff5e5","type":"http request","z":"f6979629ded1c46f","name":"","method":"GET","ret":"obj","paytoqs":"body","url":"https://api.energidataservice.dk/dataset/Elspotprices?start=now&filter={\"PriceArea\":\"DK2\"}&sort=HourDK","tls":"","persist":false,"proxy":"","insecureHTTPParser":false,"authType":"","senderr":false,"headers":[],"credentials":{},"x":1250,"y":4560,"wires":[["0c9e143f916d7ede","e69e27a90f604234","af8a879cb2b7a03b","42163f5a.825ce","4792c3d34e5a365c","8591e13802f229bf","3a8202f34b4da043","d3b5cf5afb235a3a","16042cbb2499e48f","8a6a9b0be8d02f56","4e2a7ae4eff15af9","049e024c256058ba","5279adbe98f9a23d","545f83c293705e1c"]]},{"id":"a9307deb28e64897","type":"inject","z":"f6979629ded1c46f","name":"","props":[],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","x":1530,"y":4140,"wires":[["3845925bb4cff5e5"]]}]
As you can see in this example the array is 30 because there's 6 hours left of today, and 24 of tomorrow:
What I would like to do is find the lowest "SpotPriceDKK:" in the array, and also know at what time it is.
So that way I can see that the lowest price is in x-time.
Even better if I can filter it out to what is the lowest price in a time frame I specified.
Any ideas?