ThingSpeak

Segui

Sending temperature and humidity values to a thingSpeak channel using a NodeMCU(esp8266) and the ThingSpeak library. The problem is that the graphs do not update dynamically even if values are sent and received regularly. To update the graphs I have to refresh the page every time. The numeric displays and other widgets update regularly. How can I solve the problem? Graphs do not update dynamically I just did a quick scan this morning, the public view of the channel seems to udate with data for the field charts.Im not sure about the private view, it does seem to be lagging. I was able to observe this effect in an old channel I have, but not with a new channel. The recent bug that makes it impossible to change the chart settings may be at play here. If you chart was set to a slower refresh time, or had included longer averaging, the data might not refesh as you expect. When I created a brand new channel, I did not observe the same effect. So there are several temporary workarounds. I'm not sure if creating new field charts in your old channel will work, but certainly creating a completely new channel worked for me. If you do try creating new field charts in your channel, can you let us know how it goes here? The bug that is causing the effect will be removed in an upcomming release, so the need for a workaround is temporary. Thank you for your answer. At this moment the problem only affects private view. I deleted and then recreated the two graphs in private view, now it seems to work in private view too I have the same issues as the others. A channel last updated 2021-06-20 03:20 still works correctly ie charts and widgets. Another channel updated today 2024-01-22 03:14 has the issues with charts and widgets described by others. Two questions. If I delete the channel and then recreate it will I my Write and Read API Keys change? When will the update be released? From the post below, it seems you can simply delete the field plots and reinstate them to fix the problem. (I didnt try that yet) If you delete the channel, the API keys will definitely change. If I delete the charts and widgets and then recreate them it does not display as the original display. I am using MacOS 12.7.2 on a Mac Mini 2018 3 GHz 6-Core Intel Core i5 The browser is Chrome Version 120.0.6099.234 (Official Build) (x86_64) Charts do not update dynamically. Gauge widget now works correctly! The data is being uploaded each 30 sec from 2 x MKR 1010 WIFI with very similar software but different R/W API keys Attached are 3 images 1 and 2 A channel last edited/updated 2021-06-20 03:20 still receiving data uploads and displaying correctly. 2 the same channel showing the widgets correctly. 3 Another channel edited today after deleting all charts and widgets and recreating 5 of them. Previously the charts and widgets were similar to 1 and 2 (I have not edited the colours) No numeric display with the Gauge. (It displays correctly! but not in this screen shot) Yes,this make it work. Thanks. I did some try,and I find that ,if you want dynamically data view in the chart,you should set the "timescale" to "blank"(select the white space bar) and "dynamic" to "true".Otherwise ,it will not refresh the chart data. as this pic red frame indicated : You do not need to collect data for sufficient time before you set those parameters. Setting those parameters to non-null values may result in the plots only showing up once sufficient data is collected.

Hi! I'm having trouble sending data to a channel using MQTT. I'm using a program that was working perfectly until just a few days ago, but after making some minor changes yesterday, it stopped working. I’ve also tested it manually using the MQTTX client. If I send data using CURL and GET, it works fine. It’s a bit strange... Thankfully, Ernesto. Is the MQTT server experiencing any problems? same here, publish via mqtt stopped working 11 hours ago.. thanks Also having issues. Have different location and devices. All stopped working basically about 24 hours ago. It is only those that publish on the mqtt server. The one that is on restful is working. Thanks Jacques Can you please try again. A subset of MQTT devices seems to have seen an issue publishing. We've restarted nodes in the system and can confirm things are back to 100% from our dashboards. Now is working for me Working again. Thank you. Can you explain how this problem occurred? Unplanned updates on the server instances fronting ThingSpeak's MQTT API caused some nodes in ThingSpeak's high-availability MQTT cluster to get into a bad state. These changes were unrelated to ThingSpeak application code, as evidenced by the REST API working faultlessly in @Ernesto's post. We worked with the platform provider to address the issue and have confirmed things are working correctly again for all clients of the MQTT API. This issue has occurred again and has lasted for 30 minutes. not for me, all ok after they restarted nodes yea thx The additional monitoring we put in place didn't see any issues on any nodes. Did you see any effects on multiple devices? If so, can you please send me an email with the channel numbers? mqtt

Hello, i want to write the power data from my Tasmota IR Device to my channels, but it does not work. I have created 3 channels and i use the correct write API in the script. I use the following script: >D >B =>sensor53 r >S if upsecs%20==0 then =>WebSend [api.thingspeak.com] /update.json? api_key=SZFFJSLVS0SFJ6FL&field1=%sml[1]%&field2=%sml[2]%&field3=%sml[3]% endif >M 1 +1,3,s,0,9600, 1,77070100010800ff@1000,Total consumption,kWh,total_in,2 1,77070100020800ff@1000,Total feed-in,kWh,total_out,2 1,77070100100700ff@1,Power,W,power_curr,0 # I get the messages in the console that the data was send but my channels stay empty. What do i miss ? Thanks for help Writing to ThingSpeak channels with Tasmota IR Power Reader try hard coding a value in this line WebSend [api.thingspeak.com] /update.json? api_key=xxxxxxxxxxxxxxxx&field1=%sml[1]%&field2=%sml[2]%&field3=%sml[3]% like this WebSend [api.thingspeak.com] /update.json? api_key=xxxxxxxxxxxxxxxx&field1=10 then after you have confirmed that, you can test to be sure the numbers from the power meter are being printed right. Also test writing to your channel via the browser address window just to be sure you have the syntax correct. You cen get the format from the API keys tab of you channel, on the right hand side, I do have the same issue ;( Hardcoding values from the browser work in the following format: https://api.thingspeak.com/update?api_key=xxxxxxxxxxxxxxxx&field1=4104.08&field2=401.95&field3=350.00 My tasmota device sends the following corresponding data: 22:39:33.360 SCR: performs "WebSend [api.thingspeak.com] /update.json? api_key=xxxxxxxxxxxxxxxx&field1=4104.08&field2=401.95&field3=350.00" What do i miss in the my script? Hi, I run in the same error. In my case ist was a blank ( ) after the update.json? in front of the api-key. I saw that in a capture and also in the tamota-console 00:33:39.242 SCR: performs "WebSend [api.thingspeak.com] /update.json? api_key=key&field1=7.05&field2=88.18" ==> WebSend [api.thingspeak.com] /update.json? api_key I delete the blank in the script and now it works. regards Niels tasmota script channel writing

Bom dia se alguém puder me ajudar, meu código abaixo, não estou conseguintdo conectar o meu Esp8266 ao ThingSpeak, o erro tá na conexão. Estou usando o MicroPython e NodeMCU na plataforma Pytohn o sistema operacional Ubuntu 20 # DHT11 -> ESP8266/ESP32 # 1(Vcc) -> 3v3 # 2(Data) -> GPIO12 # 4(Gnd) -> Gnd import time, network, machine from dht import DHT11 from machine import Pin from umqtt.simple import MQTTClient print("Iniciando...") dht = DHT11(Pin(12, Pin.IN, Pin.PULL_UP)) estacao = network.WLAN(network.STA_IF) estacao.active(True) estacao.connect('xxxxxxx', 'xxxxxxxxx') while estacao.isconnected() == False: machine.idle() print('Conexao realizada.') print(estacao.ifconfig()) SERVIDOR = "mqtt.thingspeak.com" CHANNEL_ID = "XXXXXXXXXXXXXXXXX" WRITE_API_KEY = "XXXXXXXXXXXXXXXXXXXXX" topico = "channels/" + CHANNEL_ID + "/publish/" + WRITE_API_KEY cliente = MQTTClient("umqtt_client", SERVIDOR) try: while True: dht.measure() temp = dht.temperature() umid = dht.humidity() print('Temperatura: %3.1f °C' %temp) print('Umidade: %3.1f %%' %umid) conteudo = "field1=" + str(temp) + "&field2=" + str(umid) print ('Conectando a ThingSpeak...') cliente.connect() cliente.publish(topico, conteudo) cliente.disconnect() print ('Envio realizado.') time.sleep(600.0) except KeyboardInterrupt: estacao.disconnect() estacao.active(False) print("Fim.") ***************************************************************************************************** No shell aparece como resposta: MPY: soft reboot Iniciando... Conexao realizada. ('192.168.0.23', '255.255.255.0', '192.168.0.1', '8.8.8.8') Temperatura: 29.0 °C Umidade: 63.0 % Conectando a ThingSpeak... Traceback (most recent call last): File "<stdin>", line 38, in <module> File "umqtt/simple.py", line 67, in connect OSError: -2 linha 38 é cliente.connect() Erro ao conectar: cliente.connect() It appears you're connecting to an incorrect server, mqtt.thingspeak.com instead of mqtt3.thingspeak.com. Start by modifying this example. python ubuntu

I am trying to calculate the daily median across a range of channels and write the result to a new field for each channel. The code seems to run sometimes, but runs into rate limitation other times. I'm not sure why since I am only writing once and to different channels? Error using Median calcs (line 39) Requests are too frequent. For further information, see Limitations in the documentation. My code is: % Sensor/channel configuration sensors = [ struct('name', 'McKinley','channelID', 28xxxx, 'writeKey', 'G3WPJ586M55Gxxxx') struct('name', 'DPI', 'channelID', 80xxxx, 'writeKey', 'S0E0LB45GQLMxxxx') struct('name', 'Bryony','channelID', 29xxxx, 'writeKey', '2BPCI0IOAINPxxxx') ]; % Define date range (last 24 hours to midnight) endTime = dateshift(datetime('now'), 'start', 'day'); startTime = endTime - hours(24); % Preallocate a results array results = []; % Step 1: Read and calculate all medians for i = 1:length(sensors) s = sensors(i); % Read Field 1 for the past 24 hours [weight, ~] = thingSpeakRead(s.channelID, 'DateRange', [startTime, endTime], 'Fields', 1); % Compute median, ignoring NaNs medianWeight = round(median(weight, 'omitnan'),2); % Store in results results(i).name = s.name; results(i).channelID = s.channelID; results(i).writeKey = s.writeKey; results(i).value = medianWeight; end % Step 2: Display results for i = 1:length(results) r = results(i); fprintf('%s (Channel %d) → 24hr Median: %.2f\n', r.name, r.channelID, r.value); end % Step 3: Write results thingSpeakWrite(results(1).channelID, 'Fields', 6, 'Values', {results(1).value}, 'WriteKey', results(1).writeKey); thingSpeakWrite(results(2).channelID, 'Fields', 6, 'Values', {results(2).value}, 'WriteKey', results(2).writeKey); thingSpeakWrite(results(3).channelID, 'Fields', 6, 'Values', {results(3).value}, 'WriteKey', results(3).writeKey);