So, on the first part, when I click the first “Get”, and before I hit “try it out”, I get the not found error.
Could it be that I haven’t shared the station publicly? I just saw the knowledgebase article on finding station ID and it mentions setting it to shared publicly.
No, I guess not. I just looked and that is set by default apparently.
or you can go to settings/stations/status it will list the device id
1 Like
Okay, so 119813 I think is the device ID of the hub. The body of text referenced 298688 and that is the devide ID under the Tempest device. Going to try that.
Bingo! That worked! Again, I think instructions in your inital post regarding how to find the device ID would be most helpful! Thanks again!
You need to use the device ID of the Tempest device.
just copy paste in a browser and hit return, will download the csv file.
I’ve used the formula given to convert unix timestamp and it works fine. My timestamp in the first row of data is 10/2/2023 12:00am as expected but, the last entry says 3:34PM but it’s only 11:43AM as I write this. My timezone is GMT-5:00. I’ve tried using "-18000) where you have 7200 in the formula in this post but then all I get are “#” in the cells meaning Excel can’t interpret the data according to the format. Any ideas?
=(($D2+7200)/86400)+DATE(1970,1,1)
make your column wider (the answer doesn’t fit your column) and make sure you format the column as a date.
I did not have an option for 4-digit year with time. I think that was the issue. I’ve got it working now but with 2-digit year. Thanks for all you help! You’ve been great!
I want to download my weather data to a Microsoft Windows Excel spreadsheet. Can someone point me to the information? Thank you.
Regards,
as simple as using the search option with the word Excel … and voilà … I even added your post to the end of it. Happy reading
1 Like
Hi Sunny! I am Kimhuy, a new user of Tempest station.
Thanks Sunny for your useful link to download the data from Tempest. I wonder if we can download data from Tempest station for a specific duration using your provided link. For example from 01/Jan/2024 to 01/Mar/2024
Regards,
Kimhuy
you can by using the time_start and time_end options instead of day_offset, but the resolution of the data might be reduced. Click an the API button on top of this page to get info on how to use that. You’ll have to enter the times in unix time. for example midnight 01/jan/2024 would be 1704067200
Thanks for a great trick to get this data, I managed to do so with ease thanks to everyone who has contributed their advice. I’m most interested in air temperature, for which this script imports in degrees C to the nearest tenth…does anyone have a clue as to how I can either a) import it as F (i doubt it) or b) import as C but to the hundredth’s or thousandth’s place?
P.S. Thank you @sunny for your suggestion of the time_start and time_end tip…I referenced the API like you said at it works great…what a lucky time for me to stumble upon this thread a day after you mentioning it lol
1 Like
you should be able to convert it to Fahrenheit in excel, and no, you cannot have temperatures with a precision of 0.001. You will have a hard time finding a consumer device that does that.
3 Likes
To add on to this thread a little. I made a dynamic Google Sheets doc that accepts any time/date start/end range to return any values between those two time stamps. Just enter your access token and Device ID and adjust the dates to your liking
3 Likes
why not share your file? currently it is set to private.
It’s shared…it should be available for anyone with the link to view. If I open an incognito window and browse to it not logged into Google, it pulls up just fine. You can’t edit it, but you can download a copy of it and edit it that way. Does it not pull up for you?