At what point in thingspeak data upload created_at timestamp is added to channel data?

13 views (last 30 days)
Hi,
I am analysing sensor data downloaded from thingspeak API and my goal is to somehow take all 4 channels data and merge them into 1. Does anyone know at what point thingspeak server (during data upload from device) attached created_at?
  • At the time when data received at the server?
  • At the time when we data is ingested into thingspeak data store?
I am assuming that there can be delay between data being received at thingspeak server vs. data ingested into thingspeak data store.

Accepted Answer

Vinod
Vinod on 16 Nov 2021
Edited: Vinod on 17 Nov 2021
The created_at is set at the time the data is received by the ThingSpeak API server. If you are using MQTT, or static IP - which are essentially just forwarders to api.thingspeak.com, then created_at is when the data is received by api.thingspeak.com (not when it hits the MQTT or static IP).
Note that you can specify created_at as one of the parameters when you update the channel. This is particularly useful if your device has a real-time clock and you want to eliminate the network latencies from affecting when the data was actually recorded.
Note also that you can use the bulk ingest API to send data to ThingSpeak and in this case you can specify the timestamp of when the data was recorded. In this case ThingSpeak keeps the timestamp specified by you.

More Answers (0)

Communities

More Answers in the  ThingSpeak Community

Categories

Find more on Read Data from Channel in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!