Hi need some help. New to this sorry
Spreadsheet does not populate. I have a Aeotec smart switch 6 attached to my dryer and a Samsung socket on my living room lamp.
Exception shown in app “called monitor”
Steps done…
Got spreadsheet to work fine under testing as per the instructions.
Added Script api key into section (“Google Sheets”) { in My Smartapps code
Created new smart app in smartthings app on phone and added api key
Set to log switches and dimmer switches in smartthings phone app
Live logging shows…
LogsClear
ea43ccda-4e5f-4804-be30-a551b6d867d7 22:15:55: debug 'zw device: 02, command: 2003, payload: FF ’ parsed to [[name:switch, value:on, descriptionText:Dryer was turned on, isStateChange:false, displayed:false, linkText:Dryer], [name:level, value:255, unit:%, isStateChange:false, displayed:false, linkText:Dryer, descriptionText:Dryer level is 255%]]
App log shows
LogsClear
9d791589-fce1-4a67-a154-b6ec24d519d3 22:15:28: error Error sending value: groovyx.net.http.ResponseParseException: Not Found
9d791589-fce1-4a67-a154-b6ec24d519d3 22:15:18: debug https://script.google.com/macros/s/AKfycbzKkT1rM4xc6H31UOC2mlzfhMzf1bMqHNUvk4yws0B4KYc-Er77/exec?Time=3%2F29%2F2017+19%3A00%3A08&Dryer+energy=0.035&Dryer+switch=on&Living+Room+Lamp+power=3.2&Dryer+level=255&Dryer+power=2
9d791589-fce1-4a67-a154-b6ec24d519d3 22:15:18: debug url [https://script.google.com/macros/s/AKfycbzKkT1rM4xc6H31UOC2mlzfhMzf1bMqHNUvk4yws0B4KYc-Er77/exec?]
9d791589-fce1-4a67-a154-b6ec24d519d3 22:15:18: debug Processing Queue