Reading Data from awattar API

[Erwin van der Zwart]

Hi,

Try this:

Code:

-- Load needed libs
require("ssl.https")
require('json')

-- Fetch data from API
data, code = ssl.https.request('https://api.awattar.de/v1/marketdata')

-- Check if data is received and decode JSON to LUA table
if data then
  tabledata = json.pdecode(data)
else
  -- No data recieved, exit script
  return
end

-- Check if decoded data is available
if tabledata then
  if type(tabledata.data) == 'table' then
    cheapest = tabledata.data[1].marketprice
    cheapestindex = 1
    -- Iterate tabledata to find the cheapest hour
    for key, value in pairs(tabledata.data) do
      -- find cheapest hour
      if value.marketprice < cheapest then
        cheapest = value.marketprice
        cheapestindex = key
      end
      -- Create & Add timestamps in human readable format
      tabledata.data[key].start_timestamp_hr = os.date('%A %d %B %H:%M',math.floor(tabledata.data[cheapestindex].start_timestamp/1000 + 0.5))
      tabledata.data[key].end_timestamp_hr = os.date('%A %d %B %H:%M',math.floor(tabledata.data[cheapestindex].end_timestamp/1000 + 0.5))
    end
   
    -- Log received table
    log(tabledata.data)
   
    -- Cheapest hour
    log(tabledata.data[cheapestindex])
   
    -- Write hour to KNX object as byte value
    grp.checkwrite('1/1/1', os.date('*t', math.floor(tabledata.data[cheapestindex].start_timestamp/1000 + 0.5)).hour)
   
  end
end

BR,

Erwin