And since you’re in Excel the page gives you the formula to use if you want to convert it automagically
2 Likes
yep, that’s the way to do it 
so the formula to convert unix time to date/time in excel is =(($D2+7200)/86400)+DATE(1970,1,1) and in order to display the date and time, format the column to have a custom format “dd/mm/jjjj uu:mm” Note I added 7200 seconds in order to compensate for the right time zone. You might want to add/subtract according to your time zone.
Where does one find the device ID?
I found it, nevermind…
2 Likes
como puedo hacer para tenet paquetes de datos mensuales y no diarios ?
just get all days of the month in excel and use excel do create month average, max, min etc etc.
entoces tengo que sacarlo dia por dia ? no puedo sacar el mes completo con un comando?
On the top of this webpage you see API, select the rest api. After authorization you end up on a page where you can play with the api. One of the things you can do is get the observations (be sure to use your device id, not station id, if you don’t know it, the api has the get_station option on that same page to tell you it). Get_observations does allow you to specify start time and end time, which is probably what you are looking for.
1 Like
no me sirvio necesito sacar todos los datos de un mes juntos no sacarlos por dia
that’s why, after you got all the data in excel, you let excel do the work for you and combine all the data of one month into monthly values.
Can we get the excel data for stations belonging to other? Or for the past month?
no, you cannot ask for other station’s data (perhaps if you used the non-free subscription). And you can request other data if you give it a start date and an end date, instead of a day offset.
If you don’t use Excel and are a Google person… It’s a little bit easier in Google Sheets. There is a function called IMPORTDATA, that will do the same.
In cell A1, simply type =IMPORTDATA("https://swd.weatherflow.com/swd/rest/observations/device/<DEVICEID>?day_offset=0&format=csv&token=TOKEN")
And it’ll do the same thing
4 Likes
Hi @mabeatty1978 ,
That is brilliant thank you!
For those who might try it you may find this thread useful
Cheers Ian
I’m getting ready to shut my station down due to moving house, but I have three+ years worth of data I would like to get out. Is there a way to pull this data in batches larger than one day?
1 Like
sure, just give it a start date and an end date, but larger batches give you lower resolution data (not as many data points per day)
Remember that you can use the same account at your new place so you won’t lose any of that data. Just update the location and height above ground once you get you station set up. The backend WF servers will know the location changed so it won’t mess anything up.
5 Likes
How do you phrase that query? Everything works fine if I change the day offset=0 but I’m not sure how to get it to take two dates.
click on the API button in the top right, authorize and see how you can get data using time_start and time_end
2 Likes