This might be of interest for those of you sending their measurements via LoRa to TTN (or intend to do so). Telegram allows to create bot channels which can be controlled over an API. In my case I let the bot subscribe to TTN over MQTT for the lastest raw data and also implemented bot commands to retrieve visualized time series directly from our Grafana instance - all written in Python.
I also extended the code to allow for sending downlink messages to the nodes, e.g. for a longer or shorter sleep period. This depends on how the node firmware deals with downlink messages.
Some rewriting would also enable non-TTN users to retrieve the raw data by subscribing to our project server.
Next milestone is to also implement event submissions via MQTT to Kotori just with a bot command on-the-fly. They have to be in JSON format, right? I’ll probably ask you here again in case of help needed.
See this example screenshot (images in (web)app get full screen and zoomable by clicking/tapping on it):