sending data to thingsboard.io

[gdimaria]

hi, I would use the platform Thingsboard.io to send and collect value data from LM objects.

they allows to do it by 2 ways: 

HTTP request ( es.  curl -v -X POST http://demo.thingsboard.io/api/v1/eoKkkZ.../telemetry --header Content-Type:application/json --data "{temperature:25}")    or 

MQTT (es. curl -v -X POST http://demo.thingsboard.io/api/v1/eoKkkZ.../telemetry --header Content-Type:application/json --data "{temperature:25}")

how could I implement everything on LM?

Thanks in advance

Peppe

[admin]

For HTTP use this:

Code:

require('json')
require('ltn12')
require('socket.http')

body = json.encode({ temperature = 25 })
response = {}

res, code = socket.http.request({
  url = 'http://demo.thingsboard.io/api/v1/eoKkkZ6JL7UbmyOHGX9L/telemetry',
  method = 'POST',
  headers = {
    ['Content-Type'] = 'application/json',
    ['Content-Length'] = #body,
  },
  source = ltn12.source.string(body),
  sink = ltn12.sink.table(response),
})

if res and code == 200 then
  log('request ok')
else
  log('request error', code, table.concat(response))
end

For MQTT search the forum, there are many examples of how to use it. The data must be encoded using JSON, same as for HTTP requests.

[gdimaria]

For HTTP use this:

Code:

require('json')
require('ltn12')
require('socket.http')

body = json.encode({ temperature = 25 })
response = {}

res, code = socket.http.request({
  url = 'http://demo.thingsboard.io/api/v1/eoKkkZ6JL7UbmyOHGX9L/telemetry',
  method = 'POST',
  headers = {
    ['Content-Type'] = 'application/json',
    ['Content-Length'] = #body,
  },
  source = ltn12.source.string(body),
  sink = ltn12.sink.table(response),
})

if res and code == 200 then
  log('request ok')
else
  log('request error', code, table.concat(response))
end

For MQTT search the forum, there are many examples of how to use it. The data must be encoded using JSON, same as for HTTP requests.

Thank you. How to pass a object value?

Code:

value = grp.getvalue('4/1/11')


body = json.encode({ temperature = value })

That way doesn't work. What is correct syntax?

[admin]

The syntax is correct, for event scripts use event.getvalue() instead of grp.getvalue().
What kind of error are you getting?

[gdimaria]

The syntax is correct, for event scripts use event.getvalue() instead of grp.getvalue().
What kind of error are you getting?

No errors, sorry. It's all right now.

Thanks

Peppe

[gdimaria]

For HTTP use this:

Code:

require('json')
require('ltn12')
require('socket.http')

body = json.encode({ temperature = 25 })
response = {}

res, code = socket.http.request({
  url = 'http://demo.thingsboard.io/api/v1/eoKkkZ6JL7UbmyOHGX9L/telemetry',
  method = 'POST',
  headers = {
    ['Content-Type'] = 'application/json',
    ['Content-Length'] = #body,
  },
  source = ltn12.source.string(body),
  sink = ltn12.sink.table(response),
})

if res and code == 200 then
  log('request ok')
else
  log('request error', code, table.concat(response))
end

For MQTT search the forum, there are many examples of how to use it. The data must be encoded using JSON, same as for HTTP requests.

I am trying to provision an object in mqtt. Thingsboard says me to execute the command:

Code:

mosquitto_pub -d -q 1 -h demo.thingsboard.io -p 1883 -t v1/devices/me/telemetry -u "gximaxia" -P "12345678" -m "{temperature:25}"

How I can arrange it via script?

I need send data of dozen of knx objects, how I can do it without give different username and password? What is the short/best way to do it?
Thanks

Peppe

[admin]

See this example: https://kb.logicmachine.net/integration/mqtt-client/

[gdimaria]

Hi,

I would like to implement the so-called Thingsboard.io Server-side RPC (https://thingsboard.io/docs/pe/user-guide/rpc/)  to send simple commands to KNX objects (e.g. on/off, set temperature, etc.).

is it possible? How I can do?

Thanks in advance

Peppe

[Daniel]

They support MQTT so you should be good to go. You will need a broker somewhere, if it is locally then you can use LM broker app.

[gdimaria]

They support MQTT so you should be good to go. You will need a broker somewhere, if it is locally then you can use LM broker app.

What do you mean for "locally"? Thingsboard is on a VM in the cloud... is LM Broker app ok for this? Can you give me please some basic advice how to use it?

[Daniel]

If it is in the cloud then you need broker in the cloud. Our broker app wont work.

[gdimaria]

They support MQTT so you should be good to go. You will need a broker somewhere, if it is locally then you can use LM broker app.

If I put LM and Thingsboard VM under the same Zerotier network, can I use LM MQTT Broker app?

In that case, how I can let TB to send write commands to LM?

Right now I only use a script to send values to TB:

Code:

indirizzo = event.dst

tagEvento = event.tag
--log (event)

--broker = "demo.thingsboard.io"
broker = "xxx.xxx.xxx.xxx"
port = 1883
token = "xxxxxxxxxxxxxxxxxxxxx"
topic = "v1/devices/me/telemetry"


value = event.getvalue()


if value == true then
    value = 1
elseif value == false then
    value = 0
else

    numero = tonumber(value)
    if numero ~= nil and numero % 1 ~= 0 then
        value = string.format("%.1f", numero)
    end
 
end

value = tostring(value)


old_value = storage.get(indirizzo,"")


if value == old_value then
 
  --log("return")
 
  return
 
end

storage.set(indirizzo, value)


payload = '{"('..indirizzo..')":' .. value .. '}'


mqtt = require("mosquitto")
client = mqtt.new()

client.ON_CONNECT = function(status, rc, msg)
  if status then
    --log("mqtt connected: "..payload)
    client:publish(topic, tostring(payload))

  else
    log("mqtt connect failed " .. tostring(msg))
    client:disconnect()
  end
end

client.ON_PUBLISH = function()
  client:disconnect()
end

-- client:login_set(username, password)
client:login_set(token, nil)
status, rc, msg = client:connect(broker, port)

if status then
  client:loop_forever()
else
  log('connect failed: ' .. tostring(msg))
end

How should be to receive commands?

Thanks a lot!

Peppe

[Daniel]

It should work. See here for LM MQTT client script.
https://kb.logicmachine.net/integration/mqtt-client/
There are many more examples on the forum.