Updating multiple Thingspeak fields with forced timestamp

The ThingSpeak community site has been upgraded to a new site. This site is currently in read-only mode. You can ask questions or post and read discussions on the new site.

Updating multiple Thingspeak fields with forced timestamp

July 12, 2018
10:48 am

maximelanoelle

New Member

Members

Forum Posts: 4

Member Since:
July 12, 2018

Offline

Hello
First post in this forum, let me know if I should have posted in a different location.

I am trying to send data to Thingspeak retrospectively, with a forced timestamp. I intent to use Arduino, and specifically the two functions "ThingSpeak.setField" followed by "ThingSpeak.writeFields(myChannelNumber_02, myWriteAPIKey_02);"

I understand how to send data and let Thingspeak specifies automatically the time value when the function gets called.
However, I would like to be able to retrospectively add data points in ThingSpeak for specific chosen timestamps.
Is there a way to do this?

Thanks in advance
Max

July 12, 2018
4:20 pm

cstapels

Moderator

Members

Moderators

Forum Posts: 885

Member Since:
March 7, 2017

Offline

Looks like a perfect place to post.

You can use the setCreatedAt() in the ThingSpeak Communication library.
i.e. ThingSpeak.setCreatedAt("2017-01-06T13:56:28");

You can find the documentation for all the available functions in your Arduino libraries folder, then look in thingSpeak , extras and then class_thing_speak_class.html
here is the partial path:
/Arduino/libraries/ThingSpeak/extras/documentation/class_thing_speak_class.html

July 17, 2018
6:16 pm

maximelanoelle

New Member

Members

Forum Posts: 4

Member Since:
July 12, 2018

Offline

Thanks for the help :). This was exactly the command I was after. Now I just need to figure out how to convert my RTC time to the format you specified.
Cheers. Max

July 17, 2018
8:04 pm

cstapels

Moderator

Members

Moderators

Forum Posts: 885

Member Since:
March 7, 2017

Offline

search for an arduino time library. There are a bunch of libraries that help you do almost any crazy time operation you want to do. You just have to sift through the doc or examples, but they have it. Time formatting is the stuff of many of my recurring programming nightmares.

You can also just do string manipulation on it yourself, but I guarantee it will be wrong after daylight savings or every other leap year, etc. (not recommended)
And thanks for letting us know it worked!

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
30 Guest(s)

Currently Browsing this Page:
1 Guest(s)