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

Question

Iftikhar 2021-11-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1588234-at-what-point-in-thingspeak-data-upload-created_at-timestamp-is-added-to-channel-data

评论： Iftikhar 2021-11-17

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Vinod 2021-11-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1588234-at-what-point-in-thingspeak-data-upload-created_at-timestamp-is-added-to-channel-data#answer_833054

编辑：Vinod 2021-11-17

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.