Results for

HI! The following line works well to send my var1 value to thingspeak.

GET https://api.thingspeak.com/update?api_key=****************&field1={var1}

But I would like to send the addition of var1+var2 in the same command. I tried many differents commands like:

    GET https://api.thingspeak.com/update?api_key=****************&field1={var1+var2}

any help? Thanks

Javascript based plugins no longer working properly (in private views). Its just not displayed in channels. (Shown as field Sections are empty)

I can no longer open and view my Thingspeak results in Firefox. It gets stuck in a loop which alternates between telling me I've logged in and authenticating. I've tried clearing Thingspeak cookies and rebooting the PC.

The same page works in Chrome, but I prefer to use Firefox as my browser. Any ideas what is wrong ?

Hello

From earlier today a project i've been working on has stopped working. It was working for the last couple of weeks with no coding updates in the mean time.

The error i'm only now getting is

"from origin 'null' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource."

Im transferring four readings from thingspeak to a web page

the get command i'm using is. xhttp.open("GET", "https://api.thingspeak.com/channels/752230/feeds/last", false); xhttp.send();

Why would i only start receiving this error today. If more information is needed i will send it on.

any insights would be much appreciated.

Thanks

Trev

Hello, since today 14:00 CEST (UTC+2) (= 12:00 UTC = 4 hours ago) none of my thinkspeak clients running on Arduinos using PubSubClient are able to connect to mqtt.thingspeak.com. Until then, they have been running happily for months.

I tried to send some data manually but didn't succeed:

mosquitto_pub -d -h mqtt.thingspeak.com -u TESTTerrasseWemos -p 1883 -P xxxx -t "channels/cccc/publish/yyyy" -m "field1=10&field2=60" ; echo $?
Client mosq-xxxxxxx sending CONNECT
Error: Unknown error.
19

The exact errors differ from try to try. But I don't know if my call is definitely correct.

Any help or information what might have changed at mqtt.thingspeak.com?

Thank you very much.

Hi. Im using sim800 for sending data to thingspeak channels when connecting to api.thingspeak.com with port 80 everything is ok. But after sending" update?api_key=YYP2Q3T8UZ2WBP6H&field1=0 " by sim800 it closes the connection and 400 Bad Request error appears on the debug session. I tried this with hercules serial terminaal and same results .

Hello

I am currently having a hard time to install thingspeak server standalone on Debian 10 (Buster). I used the following docs: https://www.teracomsystems.com/blog/how-to-install-local-thingspeak-server/ https://angryelectron.com/how-to-install-a-thingspeak-server/

It breaks on "bundle install" with wrong gem dependencies, several tries to resolve the dependencies didn't work.

Anyone had luck installing thingspeak latest on Debian 10? Is there an installation documentation for thingspeak on Buster?

Thank you, Thomas

Hi - I'm currently using the code from this article: https://uk.mathworks.com/help/thingspeak/continuously-collect-data-and-bulk-update-a-thingspeak-channel-using-an-arduino-mkr1000-board-or-an-esp8266-board.html

My plan was to use this so as to update my Thingspeak server every second with data recorded on my arduino of higher than 1Hz. I am currently taking vibration sensor data that for my project requires a higher sample rate than Thingspeak is able to handle naturally - thus I found bulk updates to be the solution.

I have gotten this to work as specified in the article - updates every 2 minutes with data points at every 15 seconds. I have gotten this as far as data points every second with an update to the server every 10 second - however the system fails at any data point shorter than a second. I believe this to be a problem with using delta_t but I am not sure.

To clarify I do not have a computer science background, this is currently a project I'm working on in Mechanical engineering and I've truly hit a wall with this problem. Any help would be appreciated!

My system is an Arduino MEGA 2560 with an ethernet shield - in the sample code they use RSSI to output sample data, I simply changed this to a random number between 0-50.

I have a channel in thing speak with 1 field but the field visualization shows the date is yet to come "2022 </matlabcentral/discussions/uploaded_files/4532/data>

I am new to the subject but I want to learn, I wanted to know how I use my esp32 to activate a relay (to connect devices and or lamps) from a distance with my cell phone. what do I have to use for this or what procedures should I follow, thank you

how can we modify the parameters to have a value with one decimal after the comma ?

thank you in advance,

This is a very basic thing but I am just beginning and I can't find the solution. When I increase the iframe width and height, the outside frame gets bigger but the graphs itself stay the same size. I read in a forum that suggests "auto" sizing feature by changing the iframe's src URL to something like the following:

http://thingspeak.com/channels/423600_ID/charts/2?width=auto&height=auto

I did and the size of the graph did scale well. However, the Number of entries to retrieve is default, which 100. Which means that after the first 100 points, as more entries comes, the first ones disappears. Please how can i increase the number of entries, lets say to the maximum?

Thank you in advance.

Hey guys! i recentlly written a code for patient health monitoring system using arduino and configured with that thingspeak api so that i could collect the data gathered by my pulse rate sensor and temparature sensor to thingspeak cloud and things went very fine my programe is executing fine but the data is not coming on thingspeak cloud..please guys it's so urgent for me cause i have to show this project as mu finao year demonstration project please help me or call me my email is durgeshc1402@gmail.com and call me on 7355104033.. it's so urgent for me to get this project working . below is the code

#include LiquidCrystal.h

LiquidCrystal lcd(12, 11, 5, 4, 3, 2); #include SoftwareSerial.h #include ThingSpeak.h float pulse = 0; float temp= 0; SoftwareSerial ser(9,10); String apiKey = "KT8O9XXE4K5WMVWA"; // Variables int pulsePin = A0; // Pulse Sensor purple wire connected to analog pin 0 int blinkPin = 7 ; // pin to blink led at each beat int fadePin = 13; // pin to do fancy classy fading blink at each beat int fadeRate = 0; // used to fade LED on with PWM on fadePin

// Volatile Variables, used in the interrupt service routine!

volatile int BPM; // int that holds raw Analog in 0. updated every 2mS volatile int Signal; // holds the incoming raw data volatile int IBI = 600; // int that holds the time interval between beats! Must be seeded! volatile boolean Pulse = false; // "True" when User's live heartbeat is detected. "False" when nota "live beat". volatile boolean QS = false; // becomes true when Arduoino finds a beat.

// Regards Serial OutPut -- Set This Up to your needs static boolean serialVisual = true; // Set to 'false' by Default. Re-set to 'true' to see Arduino Serial Monitor ASCII Visual Pulse volatile int rate[10]; // array to hold last ten IBI values volatile unsigned long sampleCounter = 0; // used to determine pulse timing volatile unsigned long lastBeatTime = 0; // used to find IBI volatile int P = 512; // used to find peak in pulse wave, seeded volatile int T = 512; // used to find trough in pulse wave, seeded volatile int thresh = 525; // used to find instant moment of heart beat, seeded volatile int amp = 100; // used to hold amplitude of pulse waveform, seeded volatile boolean firstBeat = true; // used to seed rate array so we startup with reasonable BPM volatile boolean secondBeat = false; // used to seed rate array so we startup with reasonable BPM

void setup() { lcd.begin(16, 2); pinMode(blinkPin,OUTPUT); // pin that will blink to your heartbeat! pinMode(fadePin,OUTPUT); // pin that will fade to your heartbeat! Serial.begin(115200); // we agree to talk fast! interruptSetup(); // sets up to read Pulse Sensor signal every 2mS

// IF YOU ARE POWERING The Pulse Sensor AT VOLTAGE LESS THAN THE BOARD VOLTAGE,

// UN-COMMENT THE NEXT LINE AND APPLY THAT VOLTAGE TO THE A-REF PIN

// analogReference(EXTERNAL);

lcd.clear(); lcd.setCursor(0,0); lcd.print(" Patient Health"); lcd.setCursor(0,1); lcd.print(" Monitoring "); delay(4000); lcd.clear(); lcd.setCursor(0,0); lcd.print("Initializing...."); delay(5000); lcd.clear(); lcd.setCursor(0,0); lcd.print("Getting Data...."); ser.begin(9600); ser.println("AT"); delay(1000); ser.println("AT+GMR"); delay(1000); ser.println("AT+CWMODE=3"); delay(1000); ser.println("AT+RST"); delay(5000); ser.println("AT+CIPMUX=1"); delay(1000);

String cmd="AT+CWJAP=\"durgesh\",\"eeeeeeee\""; ser.println(cmd); delay(1000); ser.println("AT+CIFSR"); delay(1000); }

// Where the Magic Happens void loop() { serialOutput(); if (QS == true) // A Heartbeat Was Found {

// BPM and IBI have been Determined // Quantified Self "QS" true when arduino finds a heartbeat fadeRate = 255; // Makes the LED Fade Effect Happen, Set 'fadeRate' Variable to 255 to fade LED with pulse serialOutputWhenBeatHappens(); // A Beat Happened, Output that to serial. QS = false; // reset the Quantified Self flag for next time } ledFadeToBeat(); // Makes the LED Fade Effect Happen delay(20); // take a break read_temp(); esp_8266(); } void ledFadeToBeat() { fadeRate -= 15; // set LED fade value fadeRate = constrain(fadeRate,0,255); // keep LED fade value from going into negative numbers! analogWrite(fadePin,fadeRate); // fade LED } void interruptSetup() { // Initializes Timer2 to throw an interrupt every 2mS. TCCR2A = 0x02; // DISABLE PWM ON DIGITAL PINS 3 AND 11, AND GO INTO CTC MODE TCCR2B = 0x06; // DON'T FORCE COMPARE, 256 PRESCALER OCR2A = 0X7C; // SET THE TOP OF THE COUNT TO 124 FOR 500Hz SAMPLE RATE TIMSK2 = 0x02; // ENABLE INTERRUPT ON MATCH BETWEEN TIMER2 AND OCR2A sei(); // MAKE SURE GLOBAL INTERRUPTS ARE ENABLED } void serialOutput() { // Decide How To Output Serial. if (serialVisual == true) { arduinoSerialMonitorVisual('-', Signal); // goes to function that makes Serial Monitor Visualizer } else { sendDataToSerial('S', Signal); // goes to sendDataToSerial function } } void serialOutputWhenBeatHappens() { if (serialVisual == true) // Code to Make the Serial Monitor Visualizer Work { Serial.print("*** Heart-Beat Happened * "); //ASCII Art Madness Serial.print("BPM: "); Serial.println(BPM); } else { sendDataToSerial('B',BPM); // send heart rate with a 'B' prefix sendDataToSerial('Q',IBI); // send time between beats with a 'Q' prefix } } void arduinoSerialMonitorVisual(char symbol, int data ) { const int sensorMin = 0; // sensor minimum, discovered through experiment const int sensorMax = 1024; // sensor maximum, discovered through experiment int sensorReading = data; // map the sensor range to a range of 12 options: int range = map(sensorReading, sensorMin, sensorMax, 0, 11); // do something different depending on the // range value: switch (range) { case 0: Serial.println(""); /////ASCII Art Madness break; case 1: Serial.println("---"); break; case 2: Serial.println("------"); break; case 3: Serial.println("---------"); break; case 4: Serial.println("------------"); break; case 5: Serial.println("--------------|-"); break; case 6: Serial.println("--------------|---"); break; case 7: Serial.println("--------------|-------"); break; case 8: Serial.println("--------------|----------"); break; case 9: Serial.println("--------------|----------------"); break; case 10: Serial.println("--------------|-------------------"); break; case 11: Serial.println("--------------|-----------------------"); break; } }

void sendDataToSerial(char symbol, int data ) { Serial.print(symbol); Serial.println(data); } ISR(TIMER2_COMPA_vect) //triggered when Timer2 counts to 124 { cli(); // disable interrupts while we do this Signal = analogRead(pulsePin); // read the Pulse Sensor sampleCounter += 2; // keep track of the time in mS with this variable int N = sampleCounter - lastBeatTime; // monitor the time since the last beat to avoid noise // find the peak and trough of the pulse wave

if(Signal < thresh && N > (IBI/5)*3) // avoid dichrotic noise by waiting 3/5 of last IBI { if (Signal < T) // T is the trough { T = Signal; // keep track of lowest point in pulse wave } } if(Signal > thresh && Signal > P) { // thresh condition helps avoid noise P = Signal; // P is the peak } // keep track of highest point in pulse wave // NOW IT'S TIME TO LOOK FOR THE HEART BEAT // signal surges up in value every time there is a pulse if (N > 250) { // avoid high frequency noise if ( (Signal > thresh) && (Pulse == false) && (N > (IBI/5)*3) ) { Pulse = true; // set the Pulse flag when we think there is a pulse digitalWrite(blinkPin,HIGH); // turn on pin 13 LED IBI = sampleCounter - lastBeatTime; // measure time between beats in mS lastBeatTime = sampleCounter; // keep track of time for next pulse

if(secondBeat) { // if this is the second beat, if secondBeat == TRUE secondBeat = false; // clear secondBeat flag for(int i=0; i<=9; i++) // seed the running total to get a realisitic BPM at startup { rate[i] = IBI; } } if(firstBeat) // if it's the first time we found a beat, if firstBeat == TRUE { firstBeat = false; // clear firstBeat flag secondBeat = true; // set the second beat flag sei(); // enable interrupts again return; // IBI value is unreliable so discard it } // keep a running total of the last 10 IBI values word runningTotal = 0; // clear the runningTotal variable for(int i=0; i<=8; i++) { // shift data in the rate array rate[i] = rate[i+1]; // and drop the oldest IBI value runningTotal += rate[i]; // add up the 9 oldest IBI values } rate[9] = IBI; // add the latest IBI to the rate array runningTotal += rate[9]; // add the latest IBI to runningTotal runningTotal /= 10; // average the last 10 IBI values BPM = 60000/runningTotal; // how many beats can fit into a minute? that's BPM! QS = true; // set Quantified Self flag // QS FLAG IS NOT CLEARED INSIDE THIS ISR pulse = BPM; } } if (Signal < thresh && Pulse == true) { // when the values are going down, the beat is over digitalWrite(blinkPin,LOW); // turn off pin 13 LED Pulse = false; // reset the Pulse flag so we can do it again amp = P - T; // get amplitude of the pulse wave thresh = amp/2 + T; // set thresh at 50% of the amplitude P = thresh; // reset these for next time T = thresh; } if (N > 2500) { // if 2.5 seconds go by without a beat thresh = 512; // set thresh default P = 512; // set P default T = 512; // set T default lastBeatTime = sampleCounter; // bring the lastBeatTime up to date firstBeat = true; // set these to avoid noise secondBeat = false; // when we get the heartbeat back } sei(); // enable interrupts when youre done! }// end isr void esp_8266() { // TCP connection AT+CIPSTART=4,"TCP","184.106.153.149",80 String cmd = "AT+CIPSTART=4,\"TCP\",\""; cmd += "184.106.153.149"; // api.thingspeak.com cmd += "\",80"; ser.println(cmd); Serial.println(cmd); if(ser.find("Error")) { Serial.println("AT+CIPSTART error"); return; } String getStr = "GET /update?api_key="; getStr += apiKey; getStr +="&field1="; getStr +=String(temp); getStr +="&field2="; getStr +=String(pulse); getStr += "\r\n\r\n"; // send data length cmd = "AT+CIPSEND=4,"; cmd += String(getStr.length()); ser.println(cmd); Serial.println(cmd); delay(1000); ser.print(getStr); Serial.println(getStr); //thingspeak needs 15 sec delay between updates delay(3000); } void read_temp() { int temp_val = analogRead(A1); float mv = (temp_val/1024.0)*5000; float cel = mv/10; temp = (cel*9)/5 + 32; Serial.print("Temperature:"); Serial.println(temp); lcd.clear(); lcd.setCursor(0,0); lcd.print("BPM :"); lcd.setCursor(7,0); lcd.print(BPM); lcd.setCursor(0,1); lcd.print("Temp.:"); lcd.setCursor(7,1); lcd.print(temp); lcd.setCursor(13,1); lcd.print("F"); }

I'm trying upload data on thingspeak it is not getting updated. We are getting readings on serial monitor. Please advice

Hello:

I am trying to read the position (latitude and longitde) from thingSpeakRead and the terror appears: Dot indexing is not supported for variables of this type

This is my code from MATLAB Visualizations code:

data = thingSpeakRead(1299642, 'location',true)
lon = data.Longitude;
lat = data.Latitude;
figure
geoplot(lat,lon,'red-*')
geobasemap("topographic")
title("Ground Truth Trajectory")

And this is the output: data =

     []

Dot indexing is not supported for variables of this type.

Error in Posicion (line 3) lon = data.Longitude;

Someone knows what is happening?

Thank you

Dear Community Staff

I have two channels, the first is working good the second not working, my license is free, I don't know what happens.

The configuration is the same, Somebody has any idea? how to solve this?

thank you

Rafael

how can i update my thingspeak using mit app (sending value through mit app to thingspeak for a particular fiels)

Hello community, I am trying to subscribe using the MQTT protocol.

The problem occurs when I try to request the subscribe, I send the subscribe and my connection with the server is closed.

where is the problem in this code, please help me..

esp 01 code-

#include "ThingSpeak.h" #include ESP8266WiFi.h

char ssid[] = "xxxxx"; // SSID here char pass[] = "xxxxxxx"; // Passowrd here

unsigned long Channel_ID = xxxxxxx; // Channel ID const char * myWriteAPIKey = "xxxxxx"; // Write API key

const int Field_Number_1 = 1; const int Field_Number_2 = 2; const int Field_Number_3 = 3; const int Field_Number_4 = 4; const int Field_Number_5 = 5; String value = ""; int value_1 = 0, value_2 = 0, value_3 = 0, value_4 = 0, value_5 = 0; WiFiClient client;

void setup() { Serial.begin(115200); WiFi.mode(WIFI_STA); ThingSpeak.begin(client); internet(); }

void loop() { internet(); if (Serial.available() > 0) { delay(100); while (Serial.available() > 0) { value = Serial.readString(); if (value[0] == '*') { if (value[11] == '#') { value_1 = ((value[1] - 0x30) * 10 + (value[2] - 0x30)); value_2 = ((value[3] - 0x30) * 10 + (value[4] - 0x30)); value_3 = ((value[5] - 0x30) * 10 + (value[6] - 0x30)); value_4 = ((value[7] - 0x30) * 10 + (value[8] - 0x30)); value_5 = ((value[9] - 0x30) * 10 + (value[10] - 0x30)); }

      }
    }
  }
  upload();
}

void internet() { if (WiFi.status() != WL_CONNECTED) { while (WiFi.status() != WL_CONNECTED) { WiFi.begin(ssid, pass); delay(5000); } } }

void upload() { ThingSpeak.writeField(Channel_ID, Field_Number_1, value_1, myWriteAPIKey); delay(15000); ThingSpeak.writeField(Channel_ID, Field_Number_2, value_2, myWriteAPIKey); delay(15000); ThingSpeak.writeField(Channel_ID, Field_Number_3, value_3, myWriteAPIKey); delay(15000); ThingSpeak.writeField(Channel_ID, Field_Number_4, value_4, myWriteAPIKey); delay(15000); ThingSpeak.writeField(Channel_ID, Field_Number_5, value_5, myWriteAPIKey); delay(15000); value = ""; }

arduino code -

#include dht.h #define soilWet 56 #define soilDry 50

const int LM35 = A0; // Soil Temperature pin

// lowest and highest sensor readings (Rain Detection) const int sensorMin = 0; // sensor minimum const int sensorMax = 1024; // sensor maximum

#define sensorPower 5 // Motor pin

int obstaclePin = 10; // IR sensor pin 7 int hasObstacle = HIGH; // High means no obstacle

const int trigger = 34; const int echo = 35; long T; float distanceCM;

dht DHT; #define DHT11_PIN 30 int humi,temp;

void setup(){ pinMode(sensorPower, OUTPUT); // Initially keep the Motor OFF digitalWrite(sensorPower, HIGH);

pinMode(obstaclePin, INPUT);

pinMode(trigger, OUTPUT); pinMode(echo, INPUT); Serial.begin(9600); }

void loop() { int moisture = (100 - ((analogRead(A1)/1023.00)*100));

digitalWrite(trigger, LOW); delay(10); digitalWrite(trigger, HIGH); delayMicroseconds(10); digitalWrite(trigger, LOW); T = pulseIn(echo, HIGH); distanceCM = T * 0.034; distanceCM = distanceCM / 2;

int ADC; float tempS; ADC = analogRead(LM35); tempS = (ADC * 4.88); tempS = (tempS / 10);

int sensorReading = analogRead(A2); // Rain detection pin A2 int range = map(sensorReading, sensorMin, sensorMax, 0, 3); // Rain detection

switch (range) { case 0: // Sensor getting wet Serial.println("Rain Status : **Raining**"); break; case 1: // Sensor getting wet Serial.println("Rain Status : *Rain Warning*"); break; case 2: // Sensor dry - To shut this up delete the " Serial.println("Not Raining"); " below. Serial.println("Rain Status : Not Raining"); break; }

DHT.read11(DHT11_PIN); humi=DHT.humidity; temp=DHT.temperature;

Serial.print("Air Temperature = "); Serial.print(temp); Serial.println("°C "); Serial.print("Air Humidity = "); Serial.print(humi); Serial.println(" %"); Serial.print("Distance = "); Serial.print(distanceCM); Serial.println("cm"); Serial.print("Soil Temperature = "); Serial.print(tempS); Serial.println("°C"); Serial.print("Soil Moisture = "); Serial.print(moisture); Serial.println(" %");

if (moisture < soilWet) { Serial.println("Status: Soil is too wet"); } else if (moisture >= soilWet && moisture < soilDry) { Serial.println("Status: Soil moisture is perfect"); } else { Serial.println("Status: Soil is too dry - time to water!"); }

if (moisture < 35) { digitalWrite(sensorPower, HIGH); // turn ON motor Serial.println("Motor is ON"); } if (moisture > 35 && moisture < 37) { digitalWrite(sensorPower, HIGH); //turn ON motor Serial.println("Motor is ON"); } if (moisture > 38) { digitalWrite(sensorPower, LOW); // turn OFF motor Serial.println("Motor is OFF"); }

 hasObstacle = digitalRead(obstaclePin); //Reads the output of the obstacle sensor from the 7th PIN of the Digital section of the arduino   
if (hasObstacle == LOW) //LOW means something is ahead
{
Serial.println("Something is ahead !!!");
}
else {
Serial.println("Path is clear");
}

Serial.println("--------------------------------------------------------------------------"); Serial.println("");

delay(3000); }

please help me to make this working for multiple sensors data.

Hi,

Has anybody seen a discussion on interfacing Samsung watch Active 2 with Thingspeak ?

Regards,

Mario