My app work when I first start it up but when I want to update the data from the google spreadsheet ,I get the error The MQTT part work very nice only web1 to update sensor readings gives ne trouble when I first click to update it works but there after the problem occur
Your Web.GotText event look incorrect
Try JsonTextDecodeWithDictionaries and store the result in a global variable instead of Web.ResponseTextEncoding
Then use that global variable in your dictionary blocks marked with x
JsonTextDecodeWithDictionaries(jsonText)
Decodes the given JSON encoded value to produce a corresponding App Inventor value. A JSON list [x, y, z] decodes to a list (x y z). A JSON Object with name A and value B, denoted as {a: b} decodes to a dictionary with the key a and value b.
Taifun
