How to download and process json files from a web site

[RuneW 1]

We have a nice web page i Norway that returns the power prices for a given date as a json file. This is an example

 

"https://www.hvakosterstrommen.no/api/v1/prices/2023/01-09_NO5.json"

 

But even if I have done some lua programming, programming the HC2 is sucking the life force out of me...

 

I try something like this (never mind the hard coded date):

 

Please login or register to see this code.

 

But calling the function results in this:

[DEBUG] 22:53:46: Calling getPrices()

[DEBUG] 22:53:46: 2023-01-09 22:53:46.449922 [ error] Handshake error: certificate verify failed

[DEBUG] 22:53:46: 2023-01-09 22:53:46.451741 [ error] Handshake error: bad message type

[Joep 181]

The certificate can't be checked by the HC3. Is the site legit with a self signed cert you can bypass the check (security risk!!) with checkCertificate = false:

 

Please login or register to see this code.

 

[SmartHomeEddy 814]

1 minute ago, Joep said:

The certificate can't be checked by the HC3

 

I think he is on a HC2, which doesn't support https?

[Joep 181]

4 minutes ago, SmartHomeEddy said:

 

I think he is on a HC2, which doesn't support https?

 

I thought it was implemented in the latest firmware(s).

[SmartHomeEddy 814]

I am not so acquainted with the HC2. That use to be a script with the https and a VD that uses the script results. 

[RuneW 1]

Thanks for the replies! The 

Please login or register to see this code.

did the trick!