MATLAB Answers

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

30 views (last 30 days)
Chris Parker
Chris Parker on 11 Feb 2021 at 23:08
Commented: Christopher Stapels on 19 Feb 2021 at 15:04
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..

  0 Comments

Sign in to comment.

Answers (1)

Christopher Stapels
Christopher Stapels on 12 Feb 2021 at 19:37
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.

  4 Comments

Show 1 older comment
Christopher Stapels
Christopher Stapels on 15 Feb 2021 at 14:11
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
Chris Parker on 15 Feb 2021 at 20:07
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
Christopher Stapels on 19 Feb 2021 at 15:04
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?

Sign in to comment.

Products

Communities

More Answers in the  ThingSpeak Community

Community Treasure Hunt

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

Start Hunting!