Data from http request - to JSON - to KNX

Data from http request - to JSON - to KNX - Printable Version

+- LogicMachine Forum (https://forum.logicmachine.net)
+-- Forum: LogicMachine eco-system (https://forum.logicmachine.net/forumdisplay.php?fid=1)
+--- Forum: Scripting (https://forum.logicmachine.net/forumdisplay.php?fid=8)
+--- Thread: Data from http request - to JSON - to KNX (/showthread.php?tid=1304)

Data from http request - to JSON - to KNX - Rune - 21.03.2018

Hi!

I need a little help with this:

I now got a energy-gateway that can send a JSON-file when requested. The way to do it, is type "http://10.0.0.xxx/output.json" in the web browser.

I then get a file called "output.json" and the string is like this:

{"0015BC001B024257":{"ApplicationHeartbeat":"1","CurrentSummationDelivered":"12812.1","CurrentSummationReceived":"0.0","Tamper":"0","InstantaneousDemand":"4342.0","Battery":"0"}}

The information I need is CurrentSummationDelivered and InstantaneousDemand and the goal is to write this to two KNX groups with 30 seconds intervals.

Any tips where to start? Thanks from a LM5-newbie. Smile

RE: Data from http request - to JSON - to KNX - Erwin van der Zwart - 21.03.2018

Hi,

Try something like this:

Code:
require('socket.http')
require('json')

socket.http.TIMEOUT = 15

data, code = socket.http.request('http://10.0.0.xxx/output.json')

if data then 
  data = json.pdecode(data)
end

if data then
  CurrentSummationDelivered = data['0015BC001B024257'].CurrentSummationDelivered
  InstantaneousDemand = data['0015BC001B024257'].InstantaneousDemand
  grp.update('1/1/1', tonumber(CurrentSummationDelivered))
  grp.update('1/1/2', tonumber(InstantaneousDemand))
end

BR,

Erwin

RE: Data from http request - to JSON - to KNX - Rune - 21.03.2018

(21.03.2018, 18:21)Erwin van der Zwart Wrote: Hi,

Try something like this:

Code:
require('socket.http') require('json') socket.http.TIMEOUT = 15 data, code = socket.http.request('http://10.0.0.xxx/output.json') if data then data = json.pdecode(data) end if data then CurrentSummationDelivered = data['0015BC001B024257'].CurrentSummationDelivered InstantaneousDemand = data['0015BC001B024257'].InstantaneousDemand grp.update('1/1/1', tonumber(CurrentSummationDelivered)) grp.update('1/1/2', tonumber(InstantaneousDemand)) end
BR,

Erwin

Something tells me that I am forgetting something? No action on the KNX-bus. (Picture attached)

RE: Data from http request - to JSON - to KNX - admin - 21.03.2018

Add log(data, code) after http request and log(data) at the end of the script, then check Logs tab for results. Do you have objects 4/0/20 and 4/0/21 created in LM?

RE: Data from http request - to JSON - to KNX - Rune - 21.03.2018

Here is the solution, thank to you that know who you are. Wink

And thanks for all the help also! Smile

Code:
sock = require('socket').tcp()
sock:settimeout(5)

res, err = sock:connect('10.0.0.112', 80)
if res then
  sock:send('GET /output.json HTTP/1.1\r\n\r\n')
  res = sock:receive('*a')
  log(res)

  if res then
    p, e = res:find('\r\n\r\n', 1, true)
    if e then
      data = res:sub(e + 1)
      data = require('json').pdecode(data)
      log(data)
    end
  end
end

if data then
  CurrentSummationDelivered = data['0015BC001B024257'].CurrentSummationDelivered
  InstantaneousDemand = data['0015BC001B024257'].InstantaneousDemand
  grp.write('4/0/20', tonumber(CurrentSummationDelivered))
  grp.write('4/0/21', tonumber(InstantaneousDemand))
end