yes it works. thank you. Now I don’t know google sheets well enough, but wouldn’t it be helpful if it automatically added a column with human readable time stamps?
Brilliant. I cant believe your post is not bombarded with love hearts. I just tried it and it works great thank you. A great starting point for quick analysis in distant history or for other reasons. Those who had been asking for something just need to come back to the forum and find your post.
I might add a link to it from the google sheets thread…
cheers Ian 
If I could ask a dumb question. I have everything working if I use the day offset 1 or 0 BUT I am not quite sure how to enter the start and end dates in the url to get the data I need.
I tried: https://swd.weatherflow.com/swd/rest/observations/device/<device_id>?&time_start=1729192564&time_end=1729192564&format=csv&token=<my_token>
but it only gives a row of headers…
I deploy weather stations in locations for 4-6 weeks and need to summarize the WXT data with other data for set time periods.
Cheers!
your start time is the same as the end time As the time is in seconds, that would give you no data, or perhaps if you are lucky a single line of data.
Ahh, I should have caught that…But is the syntax correct? I guess that is the root of my question. I updated the start and end times and it is still giving me just one row. I just Googled to convert the date to Unix
https://swd.weatherflow.com/swd/rest/observations/device/<device_id>?time_start=1725532200&time_end=1729074600&format=csv&token=<my_token>
If I do ‘day _offset=0’ it works just fine.
Yes that syntax seems correct. Perhaps first give it a try on the api page (link in the top of this page). Authorize with your token and request the observations. At least you get some error message if something is wrong
1 Like
Hi, I’m very new to tempest weather data and thank you for this technique to get the data from the device as this method works just fine and I’m able to refresh the excel and able to get most current values in new rows too.
- But I have a question how do you change the interval from 1 minute to a different interval like may be 5 minutes or so? The 60 seconds is a lot of data.
- Also, if you want to fetch data from a start date you can use time_start=, but what if you want to get data continuously without end date?
1 Like
- if I remember correctly if you use a start and end date seperated by more than a couple of days, it will automatically return data with bigger intervals.
- there is no unlimited end date. you can however request real time data using the API link in the top of this page. Hope that helps
3 Likes
Hi. Thats very useful information can I ask you one more doubt.
I have this situation to get weather data from device from 2 weeks back till now and moving forward with 1 minute interval in excel. What would be the ideal scenario to do that. It will be very helpful if I could get an opinion on that.
Thanks in advance.
depends on what you are hoping to achieve. Getting data from 2 weeks back is easy with the method mentioned above. Do you want “real time” data to make graphs? You can always use the method again whenever you want to make a graph. If you want a method for showing real time data as graphs that automatically stay up to data, there are probably better methods, like the stand alone programs that run on a raspberry pi with attached screen. Those methods use the api to get the data. search for pi console in this forum.
With the method mentioned above using the https://swd.weatherflow.com/swd/rest/observations/device/?day_offset=0&format=csv&token=
I’m only getting data for one day (1 minute interval). When i press refresh next day the previous data is cleared and new data of new day is updated in same rows.
Now when i use start and end date to fetch previous data then the interval changes.
My request is simple, I want to get data from last two weeks with 1 minute interval in excel now and if I open excel again tomorrow i need the new data in new rows (with keeping the previous data) with pressing refresh or any data fetching method.
I know there is an applet for doing the same exact thing for google sheet but i was hoping to find something for excel.
for the older data, just request data with for example a day_offset of 14 instead of 0. That should give you 1 minute data from 14 days ago.
I don’t know excel well enough, but I would load the latest data into a new sheet and append that data to the existing data (and perhaps check for duplicate timestamps and delete that data)
There is an unpublished “bucket” parameter that accepts a single character, a,b,c,d,e where a = 1 min, b = 5 min, c = 30 min, d = 180min, e =1 day. You can pass that "bucket= " parameter into the api call and it will return results with that interval. It’s worth adding that the reason it is unpublished is that if your provide a date range and a bucket interval that is too short, the call will fail because of there being too much data to return.
I’m not entirely sure what you are asking for, but if you want to get data all the way up to the most recent records, you could enter the value =NOW() in the end date.
2 Likes
Hello Sunny,
Can you help me out how to get the solar radiation W/m2 in excel sheet. Not all the data from my tempest weather station are presented in Excel. So how can I eliminate certain data and how can I add data to the Excel sheet. Appreciate your help.
I don’t know how you manage not to get the solar irradiation. Try this example:
How is your different?
Thank you for your link, but that did not solve it. In Excel after the humidity column all the following columns lux,uv, solar_radiation, precip,precip_type, strike distance etc are all zero’s.
So not all data is present in the Excel sheet from my tempest weather station. I really need the solar-radiation columns. Any help much appreciated.
ok, at least you have the columns with data. it just appears zero. assuming your sensor is working, scroll down 500 lines or so. The data starts at midnight so their isn’t any solar irradiation
2 Likes
This is really cool! Thanks for all the tips! I got mine to work right away.
2 Likes
Thank you for putting this Google Sheets together! It was the only method I got to work.
I’m aware of how to convert the Unix timestamp to an Excel date, but how do I do that with this spreadsheet?
It appears I can’t modify the fields as is. Do I have to copy the data to another tab and convert it there?