Bulk update with thingSpeakWrite to a specified field

4 次查看（过去 30 天）
Manfred
Manfred 2023-5-4
评论： Manfred 2023-5-4
In the thingSpeakWrite documentation is an example, how to upload a table of data
....
thingSpeakWrite(writeChannelID,dataTable,'WriteKey',writeAPIKey);
This works, but the data are uploaded in Field1. How can i specifie the field - for example field 5?
thingSpeakWrite(writeChannelID,'Fields',[5],dataTable,'WriteKey',writeAPIKey);
or
thingSpeakWrite(writeChannelID,'Fields',[5],'Values',dataTable,'WriteKey',writeAPIKey);
did not work.

请先登录，再回答此问题。

采纳的回答

Christopher Stapels
编辑：Christopher Stapels 2023-5-4
myDates=datetime(2023,1,1):days(1):datetime(2023,1,10)
nullVec=string.empty(10,0);
myNums=1:10;
myTimeTable=table(myDates',nullVec,nullVec,nullVec,nullVec,myNums')
thingSpeakWrite(nnnnnnnnn,myTimeTable,'writeKey','xxxxxxxxxxxxxxxx')

更多回答（1 个）

Christopher Stapels
Make your data table with the first four columns of null values.
  1 个评论
Manfred
Manfred 2023-5-4
编辑：Manfred 2023-5-4
i tryed
dataField = [null,null,null,null,1;null,null,null,null,2;null,null,null,null,3;null,null,null,null,4;null,null,null,null,5;null,null,null,null,6;null,null,null,null,7;null,null,null,null,8;null,null,null,null,9;null,null,null,null,10];
and
dataField = [,,,,1;,,,,2;,,,,3;,,,,4;,,,,5;,,,,6;,,,,7;,,,,8;,,,,9;,,,,10];
and got the Error:
"Invalid expression. When calling a function or indexing a variable, use parentheses. Otherwise, check for mismatched delimiters."

请先登录，再进行评论。

社区

更多回答在  ThingSpeak Community

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by