發表文章

目前顯示的是有「http」標籤的文章

LoraWAN TTN http data to gsheet

圖片
this one work, and can parsing field data with json, it first has to run setup.  also change your payload based on the data field. The problem I met is that the decode data is not shown, same as the down link url https://blog.squix.org/2017/07/thethingsnetwork-how-to-use-google-spreadsheet-to-log-data.html this one is another version originated form above.: https://github.com/Uspizig/Ttn-gooogle-script Nice one: https://github.com/avbentem/libelium-waspmote-lorawan  is a well documented project, there is a section of http to google sheet and run on latest V8 runtime of google app script. https://github.com/avbentem/libelium-waspmote-lorawan/blob/master/src/google-sheets/README.md the code will send email to sheet owner in case of any error. So make sure you adjust the field property correctly.  After modification of  row.push fields. part, it works pretty well. my little question is that since few days, my sensor node always resend 3-4 times as retry. I will look int...