Unable to download custom time interval

[amitrica]

First, I want to thank Cayenne for this awesome product, and the community for the invaluable information.

I’m able to export data from Cayenne (in CSV format) only for predefined intervals: day, week, month. But when the data is just over a month (1month 2 weeks), I’m not able to export it:

• 3 months view would return “data not available”
• custom interval would export one row for “today”

Please help/advise.

[rsiegel]

Hi @amitrica,

Thanks for your interest in Cayenne and the nice words.

We’re working on improving the capability of the “Download Chart Data” feature you see on the history charts for your widgets. Until then, have you tried the instructions for exporting Cayenne data found in these posts (which one to use depends on your device connectivity):

Extracting widget history data (for Raspberry Pi and Arduino devices)

Please note that this does NOT apply to Raspberry Pi and Arduino devices connected as ‘Bring Your Own Thing’ (MQTT) devices. For those, or any MQTT or LoRa connected device, 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 Raspberry Pi and Arduino devices from our system. The p…

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 …

I know they are a bit of a pain compared to just clicking “download chart data”, but the steps inside should work and offer you more customizability when requesting your data. If you’d like, I’d be happy to extract data for you using these steps, if you PM me with your account credentials, and what widgets/time frame you’re looking for data from.

[amitrica]

Hello,

I tried several times, but with empty response, return code 200 so no error.
I used the code for Raspberry Pi.

The only difference I find between my URLs and those from the posts is that in your post the URL used to extract the machine and the sensor ids is:

• - Cayenne…
  mine neing like this:
• - Cayenne…

I identified imediately the required IDs and used them in the Postman GET query: no result (for a period where I have data), status 200 (no error)

Please help

[amitrica]

Hello,

Finally worked, by extracting the widget history data like for MQTT devices, even if I’m using a Raspberry PI connected as a PI (not ‘Bring Your Own Thing’) .

Thank you again for this awesome product, and I’m looking forward for updates.