thingsboard / thingsboard-gateway

Open-source IoT Gateway - integrates devices connected to legacy and third-party systems with ThingsBoard IoT Platform using Modbus, CAN bus, BACnet, BLE, OPC-UA, MQTT, ODBC and REST protocols
https://thingsboard.io/docs/iot-gateway/what-is-iot-gateway/
Apache License 2.0
1.66k stars 800 forks source link

[HELP] ODBC Connector #1228

Closed mica83 closed 2 weeks ago

mica83 commented 7 months ago

Hello guys,

one simple question: Is it possible pass to methods a dynamic value coming from TB - shared attribute?

In the documentation i see some examples but just with fixed values as arguments:

"methods": [ { "name": "rpcProcOne", "args": [ "One", 2, 3.0 ], "query": "CALL procedureOne(?,?,?)" }, { "name": "functionOne", "args": [ false ] } ]

imbeacon commented 7 months ago

Hi @mica83,

Thank you for your interest in Thingsboard IoT Gateway. Yes, it is possible - just add "overrideRpcConfig": true to serverSideRpc section and send configs in params for RPC method from ThingsBoard. Please let us know about the results.