ttn | The Things Network Stack V2 | Networking library

I have a dockerised telegraf (influxdata-docker/telegraf/1.21 at master · influxdata/influxdata-docker · GitHub) and influxdb (influxdata-docker/Dockerfile at master · influxdata/influxdata-docker · GitHub).

I’m trying to send data to influxdb from ttn but without any success. The config file for telegraf is:

Im using TTN to send data as JSON to a cell in sheets, but all the data is ofc in one cell. how would I extract only the data I need into a cell for each data point. the JSON file looks like this. The data I need is all the decoded.payload

{"end_device_ids":{"device_id":"carls","application_ids":{"application_id":"prove"},"dev_eui":"A861A3032496B11","join_eui":"0000000000000000","dev_addr":"260BDF9"},"correlation_ids":["as:up:01FXJ2E9J1PDY7QPR8DPM69NMK","gs:conn:01FXHWEX62T1MBPBP0MX9JJJ95","gs:up:host:01FXHWEX6GK8F3ZKYTZNC7GEJ","gs:uplink:01FXJ29BDR6AK5R9D5P5R1T3","ns:uplink:01FXJ2E9BPAQMTQBBRTQCKFRC","rpc:/ttn.lorawan.v3.GsNs/HandleUplink:01FXJ2E9B2M1Y63PR0DV5BZW7","rpc:/ttn.lorawan.v3.NsAs/HandleUplink:01FXJ2E9J0DXKCP7KV5F00DK9"],"received_at":"2022-03-07T11:32:41.665432609Z","uplink_message":{"session_key_id":"AX9t/rec6yxiPpfOgbbw==","f_port":2,"f_cnt":2,"frm_payload":"AWBYQEtA7s=","decoded_payload":{**

"I1I_Overflade":3.59,"I2I_Dybde":3.53,"I3I_Klarhed":3.01,"I4I_Lys":9.55

**},"rx_metadata":[{"gateway_ids":{"gateway_id":"carls-gateway","eui":"58A0CFFFE80127"},"time":"2022-03-07T11:32:41.363879919Z","timestamp":1974812332,"rssi":-111,"channel_rssi":-111,"snr":-7,"location":{"latitude":55.284274413402,"longitude":14.7813155831094,"source":"SOURCE_REGISTRY"},"uplink_token":"ChsKGQoNYFybHMt2F0ZXdheRIIWKDL//6AGycrP3UrQcaDjZ2peRBhD5jufSASDgn/PfvLYBKgwI2dXkQYQ7vBrQE="}],"settings":{"data_rate":{"lora":{"bandwidth":125000,"spreading_factor":8}},"coding_rate":"4/5","frequency":"86500000","timestamp":1974812332,"time":"2022-03-07T11:32:41.363879919Z"},"received_at":"2022-03-07T11:32:41.443074303Z","consumed_airtime":"0.113152s","locations":{"user":{"latitude":52.282073015039,"longitude":12.7818470012207,"source":"SOURCE_REGISTRY"}},"version_ids":{"brand_id":"arduino","model_id":"mkr-wan-1310","hardware_version":"1.0","firmware_version":"1.2.0","band_id":"EU_863_870"},"network_ids":{"net_id":"000013","tenant_id":"ttn","cluster_id":"ttn-eu1"}}}

I some have trouble representing API data to my templates.

Some info: The API data is send to context_processors.py in my app dir.

I'm struggling with constructing an object that is populated by the results of a number of If statements. The If statements should fill in the params object where a value for a key is available and leave null for keys without a value. Unfortunately I get null no matter what even though there is certainly data available for some of the keys (e.g. humidity, temperature, etc)

I am parsing pdf files using tika and then converting the output to a txt file. This gives me a large txt file with many spaces in between the lines. After reading in the text file, I get a list like below:

I have a functional. In which I make a request to Get. Then I parse the answer from this query (json), and this data is displayed in my widget. It all works. But if I press the button again. Data will not be updated. And the updated data that I will receive will be added to those that are already in the widget list. I would like that on the button the data are updated (that is that the data were written down only those which I took away with request GET last time, and the old data were deleted). My request:

In TTN they are no longer supporting large decoders.

I know what the decoder needs to be in TTN, it is in my DECODER function, but dont know how to execute it in the function node.

If you use inject Payload [1,2,3] RAW, it injects the raw payload that is msg.payload.payload.uplink_message.frm_payload into the decoder.

The DECODER needs to decode the raw payload and output it in msg.payload.uplink_message.decoded_payload

If you use inject Payload [1,2,3] Decoded in the flow you see how the end result needs to look like and the decoded msg.payload.uplink_message.decoded_payload

I am still learning JavaScript.

The code in the function node

I just built and tested connection with ttn using single channel lorawan gateway as per thing4U/esp-1ch-gateway and a single channel node both based on TTGO-ESP32Lora and eventually configured both on www.thethingsnetwork.org. Everything works nicely but I do not understand why despite the node sends data at pace of 2 minutes, the gateway detects and send over to ttn just one packet out of three. I.E.: packet 0,3,6,9 etc. so the data at ttn are updated every 6 minutes instead of 2. Any help / suggestion is appreciated.

I am trying to fetch array data from two tables columns and compare if it matches. If the two results are the same return a message and if not save the form data to the database.