API - Inconsistency with Curl, when downloading a .csv of my channel

Hi,

i'm trying to download a 7 day .csv of my channel via curl, but it only seems to download part of it.

if i place the same url into the browser it gives me the full 7 days, but when using curl i only get just over a day downloaded?

Any ideas ? if anyone has a curl command that they know works flawlessly please let me know..

Answer 1

[Christopher Stapels]

You can get all the correct API calls from the Read data section of the documentation. The API limits you to only 8000 points of data per call, so you may have the correct format already.

[Chris Parker]

hi Chris, sorry for not being clearer in my original post, i seem to have the api url/command for my private channel correct as i can see all 7 days worth of information when viewed online. my question and issue relates to downloading via Curl, as the same url/command starting with 'curl -o feed.csv https//api.thingspeak.com/channels....' downloads only a couple of days records ?? (which is wierd) - any ideas ?

** sadly this forum does not not support copy/paste from an ios device so i can't share the long command. **

[Christopher Stapels]

can you give me the gist of the rest of the command? you can redact your API keys, but I would like to see what you are sending in your curl command. What parameters are you using? (average, datetime,last..)

Perhaps the timeout in the version of curl is faster so it is not getting the full data. Can you extend the timeout and see if there is a change?

--connect-timeout <seconds>

[Chris Parker]

hi chris, my curl command is as follows, plus i tried 'wget -O' and i get the same result ??!!

curl -o home/pi/shared/feed.csv https://api.thingspeak.com/channels/123456/feed.csv?api_key=V12345ABCDE123&days=7

[Christopher Stapels]

Thanks for sharing the rest of the call.

What do you mean by can see all days.. "when viewed online". Is this on your ThingSpeak field chart? How many points are in the 7 days of date, by the way?