Results for

Hi,

I managed to get Thingspeak JSON data from my channel. However, I would like to know if theres any way to convert Thingspeak's JSON string data to decimal. I would really appreciate it if anyone could tell me how to convert it to decimal.

Currently, this is my JSON: { "created_at": "2020-10-08T09:24:00.0000000Z", "entry_id": 1, "field1": "0", "field2": "12", "field3": "1", "field4": "1", "field5": "1", "field6": "1" }

May I know if it is as simple as deleting the ""? For eg,

{ "created_at": "2020-10-08T09:24:00.0000000Z", "entry_id": 1, "field1": 0, "field2": 12, "field3": 1, "field4": 1, "field5": 1, "field6": 1 }

Hello, I want to create a sort of an alert to display the temperature health like in the image below:

i have found this code:

% This script uses the Air Quality Index (AQI) calculated 
% in "particulateConcentration" to display the appropriate text associated 
% with the index. 
% Copyright 2019 The MathWorks, Inc.
readChannelID = yourChannelID;
% TODO - Replace the [] with the Field ID to read data from:
fieldID1 = 1;
% Channel Read API Key 
% If your channel is private, then enter the read API
% Key between the '' below: 
readAPIKey = yourChannelReadKey;
returnAQI = thingSpeakRead(readChannelID, 'Field', fieldID1,'ReadKey', readAPIKey);
[airCondition, conditionIdx] = returnairhealth(returnAQI);
plotairhealth(airCondition, conditionIdx)
%% Plot Air Health
function plotairhealth(airCondition, conditionIdx)
vertices = [0 0; 1 0; 1 1; 0 1];
faces = [1 2 3 4];
% Use Look Up Table and air health condition to get color for reading
faceColorPatchLUT = [0 0.83 0; 0.44 0.95 0.52; 1 0.98 0.53; 0.95 0.98 0.22; 1 0.39 0.39; 1 0 0];
faceColorPatch = faceColorPatchLUT(conditionIdx,:);
airHealthPatch = patch('Faces',faces,'Vertices',vertices,'FaceColor',faceColorPatch);
hold on 
text(0.5,0.5,airCondition,'FontSize',16,'HorizontalAlignment','center')
hold off
% Remove Axis handle
axHandle = airHealthPatch.Parent;
axHandle.YTickLabel = [];
axHandle.XTickLabel = [];
end
%% Air Health Condition
function [airCondition,conditionIdx] = returnairhealth(returnAQI)
airCondition = {'Good';'Moderate';'Unhealthy for Sensitive Groups';'Unhealthy';'Very Unhealthy';'Hazardous'};
aqiLow = [0;51;101;151;201;301];
aqiHigh = [50;100;150;200;300;500];
lutAQI = table(airCondition,aqiLow,aqiHigh,'VariableNames',{'Air_Health','AQI_low','AQI_high'});
conditionIdx = find(returnAQI >= lutAQI.AQI_low & returnAQI <= lutAQI.AQI_high);
airCondition = string(lutAQI.Air_Health(conditionIdx));
end

However, i don't know howto adapt it to my case where i have only 2 cases : if my variable = 0 : the health is good and the color of the box is green else if my viariable = 1 ==> healt is dangerous and the color is red.

Hello, I'm new to thingspeak, i want to combine 4 fields in one chart, i have used the code below

readChannelID = 1408944; % YOUR CHANNEL NUMBER
fieldID1 = 1; % YOUR FIELD NUMBER ie 1 to 8
fieldID2 = 3; % my case 1 Temp 2 Humid
readAPIKey = '19EJIJW6YBM7VS7N';
[data1, time1] = thingSpeakRead(readChannelID, 'Field',fieldID1,'NumDays',1,'ReadKey', readAPIKey);
[data2,time2] = thingSpeakRead(readChannelID, 'Field',fieldID2,'NumDays',1,'ReadKey', readAPIKey);
thingSpeakPlotYY(time1, data1, time2, data2,...
'YGrid1','on','YLabel1','% H.R.',...
'YLabel2','*C','XLabel','Fecha y hora',...
'Title','Tempix y Humix ultimas 24 horas');

However, an error occurs saying that the function thingSpeakPlotYY is unrecognized

There is exactly the same tutorial for my topic but I couldn't make it work. It worked like a charm on SMS service but it wasn't on call. Authentication shouldn't be a problem cause it's similar to SMS configuration. The remaining information that I've doubt is the "Body" part. I filled it like:

From={+Twilio number}&To={+myNumber}&Body=CO2 concentration is exceeding the threshold value and being at :%%channel_1372010_field_3%%

And also, the API URL is:

https://api.twilio.com/2010-04-01/Accounts/{My AuthSID}/Calls.json

I replaced my own information on the above items but It didn't make a call at all even when the TimeControl app run it. Hope to get your help.

Hi,

I am currently having this internship which we are required to send sensor data to Thingspeak as well receiving data of '0' or '1' from Thingspeak to remotely control the LED.

We have done sending of sensor values to Thingspeak and I was able to send data of '0' and '1' ( on and off) to Thingspeak using a software called "Mendix". Our job is to control the LED from a mobile app and a web dashboard by pressing a button which sends the data to Thingspeak I have created. I am using REST call API to send data to thingspeak by using these 2 URLs: https://api.thingspeak.com/update?api_key=UHVD1PPGDS2X&field1=0 or https://api.thingspeak.com/update?api_key=UHVD1PPGDS&field1=1

This is the C++ code we used to send sensor values to Thingspeak:

void setWifiMode(void){ u8 tx[]="AT+CWMODE=3\r\n"; u32 num = strlen((char *) tx); xil_printf((char *) tx); ESP32_SendBuffer(&ESP32, tx, num); usleep(100); receiveData(3); }

void connectWifi(void){ u8 tx[] = "AT+CWJAP=\"eee-iot\",\"hWV4IOcKp0JX\"\r\n";

    u32 num = strlen((char *) tx);
    xil_printf((char *) tx);
    ESP32_SendBuffer(&ESP32, tx, num);
    usleep(100);
    receiveData(30);
}

void establishConnection(void){ u8 tx[] = "AT+CIPSTART=\"TCP\",\"api.thingspeak.com\",80\r\n"; u32 num = strlen((char *) tx); xil_printf((char *) tx); ESP32_SendBuffer(&ESP32, tx, num); receiveData(10); }

void cipsend(float temp, u16 co2, u8 light, float humidity){ u8 command[150]; u8 finalcmd[50]; //field1 Ph field2 Temp field3 co2 field4 humidity field5 light sprintf((char*)command, "GET http://api.thingspeak.com/update?api_key=CE8E8ZJNGZM8&field1=0&field2=%d.%02d&field3=%d&field4=%d.%02d&field5=%d\r\n" ,(int) temp_degc,((int) (temp_degc * 100)) % 100,co2,(int) hum_perrh,((int) (hum_perrh * 100)) % 100,light); u32 length = strlen((char*)command); sprintf((char*)finalcmd, "AT+CIPSEND=%d\r\n", (int)length); u32 cmdlength =strlen((char*)finalcmd); xil_printf("Length %d\r\n", length); xil_printf((char *)finalcmd); ESP32_SendBuffer(&ESP32, finalcmd, cmdlength); sleep(1); xil_printf((char *)command); ESP32_SendBuffer(&ESP32, command, length); receiveData(4); }

We are using a FPGA hardware called Zybo if that helps. I will really appreciate it if anyone could guide us on this as we are just students. My teammate is doing this alone while I am doing the mobile app and web dashboard alone as well and it is quite taxing for us to achieve this without any professional help.

Our difficulty right now is that we are unable to receive data '1' or '0' from Thingspeak to our FPGA hardware, Zybo. We are using Pmod ESP32 for wifi communication and we are currently using C++ language.

The timestamp for the ThingSpeak Alerts I create look like this: "Time: 2021-06-01 06-21-45.001 -04:00" Using a dash (-) instead of a colon (:) between the hour and minutes and minutes and seconds seems very non-standard to me. I've always seen it with a colon.

Is there any way to change the dashes in the time part of the stamp to colons so the above looks like 06:21:45.001? (I presume this is set in "HeaderFields" but don't know how to change it.

Thanks.

Through sensors collect the body vitals and upload it on the cloud and anylsis of that body vitals. How to do analysis

Hello everyone! i'm Chung and i am a student. My major is electrical engineering and I'm learning how to use matlab to load flow analysis. i have a problem with my math problem. It is "matlab code for load flow analysis using newton raphson method". Can you help me write a matlab program that calculates the required problem using the newton-raphson method? I hope to get help from everyone.

Thanks you so much!

Is there a way via MQTT to access the talkback. I want to read the talkback variable using MQTT and not REST. I have a ESP8266 which I am logging data, but also have a relay which I want to switch. I am using MQTT to log the data, but don't wanna use REST to access/read the talkback. Hope there is a way which I missed. Thanks so long.

Hello everyone. Yesterday i started my project and now im trying to export data files (CSV) but it is empty. It cointains just the headers and last read (i think). Anyone knows what is happening?

Example CSV exported created_at,entry_id,field1,field2,field3,latitude,longitude,elevation,status 2021-05-26 19:39:23 -03,1,25.00,"43.00

",,,,, 2021-05-26 19:39:39 -03,2,24.80,40.00"

ThingSpeak includes an integration with The Things Stack to support collection of data over a long range network. I made a short presentation for this upcoming conference that shows you how to add the ThingSpeak integration to your Things Stack project. The agenda seems to be filled with other useful IoT talks. Here is the information on the conference:

Discover the next-generation #LoRaWAN deployments at The Things Stack Conference. Explore advanced LoRaWAN features, cloud integrations and the next-generation #IoT devices at #TheThingsConference - TheThings Stack Edition, online on 28 May 2021!

Registrations are now open: – ow.ly/I1PZ30mNt0I

#TheThingsConference #TheThingsNetwork #LoRaWAN

If you go and see something you like, please feel free to share in this discussion.

'nanmean' requires one of the following: Financial Toolbox Statistics and Machine Learning Toolbox

Error in Custom (no starter code) 1 (line 15) avghumidity= nanmean(humidity);

how to remove this error?

Via a particle photon and webhook, i am sending data to THINGSPEAK. The channel indicates entries e.g. 1239 entries but the graphs are empty. Can anyone help me to fix this? Thanks

Hi, I have an AIOT project on vertical farming project. Currently, I am using Thingspeak to store sensor values. I am planning to do the followings:

1) do an analysis on the data collected for each sensors on their max, min and median (50%) to determine that the sensor value is currently ok for the plants. I am aware that Thingspeak is able to calculate these and I am learning about this now.

2) I would like to predict the sensor values collected ( eg temperature/humidity etc). I feel that this is a cool feature to have in my project but I am not sure how do I go about this. For experts in Thingspeak, do you think this is a must have for an internship project on vertical farming and how do I apply this in my project? I am not sure if this is manageable for a single student to do this and I really appreciate it if anyone would guide me along.

Hallo all Did anyone tried to send data from siemens wincc scada to a chanell. From me experiance wincc VBA works but from wincc VBS no way? Any comment or experiance to share

Our ThingSpeak channels stopped updating their dashboards at 20:08 BST. We can see other public channels aren't updating too from this time.

Our code for writing to ThingSpeak is returning a 202 success, indicating it is successful, suggesting that data is still being written.

Are any ThingSpeak services down?

When I log in to my account the display just constantly cycles/refreshes about every 2 seconds, with a message at the top saying "authenticating". So I can't view anything.

I can't edit charts with the pencil icon, tried different sort of webbrowsers in windows 10 and also different pc's. When i try it on my android phone it does work perfectly with the same wifi connection? When i inspect the pencil object in the chrome browser it shows some warnings, see picture

Hello, I want to read the instant GPS data from Thingspeak Cloud and show it on the folium map, but I could not do the integration. Do you have Any suggestions?

Hello, was hoping to share my Public Sharing page with others without the need for them to log in. In Chrome, it works only if I open a page in Incognito Mode, then I can view without logging in.

Also, from FB Messenger, I can click the link and it will open a page on my Iphone without needing login, but some others, including me in Chrome click the link and it says I need to log in first.

Any ideas how to fix that?