Downloading historic data

[paul2]

Follow the instructions in this thread

Extracting widget history data (for MQTT and LoRa devices)

Please note that this post only applies to MQTT (‘Bring Your Own Thing’) and LoRa connected devices. For non-MQTT Raspberry Pi and Arduino devices, you want this sister post. I’ve found that the “Download Chart Data” button doesn’t always satisfy everyone’s needs to pull data which has been logged to Cayenne out of the system. The purpose of this post is to show you how you can extract the raw sensor data for LoRa and MQTT (‘Bring Your Own Thing’) devices from our system. The process is a …

It seemed to work for me. A bit fiddly the first time but then it’s just a matter of changinjg the date/time or device.
Note that the unix time needs to be in milliseconds not seconds.