Excel trick to get data directly from tempest

Did you know you can get your data of your tempest directly into Excel?

First you need to generate a personal token. Sign in to the Tempest Web App at tempestwx.com, then go to Settings → Data Authorizations → Create Token, then copy that token.

Open a blank new document in Excel. Click on Data (in the menu bar at the top), select (in the top left corner) Get Data → from other sources → from the web
paste the following url in the popup window and use your device id (not your station id!) and the token you just created
https://swd.weatherflow.com/swd/rest/observations/device/<your device id>?day_offset=0&format=csv&token=<your token>
Presto, data is now in Excel. Day_offset=0 returns today’s data collected sofar, Day_offset=1 returns all of yesterday’s data.

4 Likes

I get a 401 error? :frowning:
{“status”:{“status_code”:401,“status_message”:“UNAUTHORIZED”}}

I just tested it and for me it loaded +/- 400 lines of data nicely formatted with headers. The update button even appends the new readings …

That’s weird. You did create a new personal token and used it together with your own station_id?
It should look something like this (but this token is not my valid token ;-), so it won’t work)

https://swd.weatherflow.com/swd/rest/observations/device/15033?day_offset=0&token=843785ca-1c6a-4c19-b942-10b4dba3618e

Maybe you can get mine to work?
https://swd.weatherflow.com/swd/rest/observations/device/22950?day_offset=0&token=bcf4754a-886b-4b84-9ce7-5b70c22e5299
I took your format and changed my 2 reference, still new error:
{“status”:{“status_code”:404,“status_message”:“NOT FOUND”}}

sure… you were using the wrong device_id. You used the station_id
Try:

https://swd.weatherflow.com/swd/rest/observations/device/168731?day_offset=0&format=csv&token=bcf4754a-886b-4b84-9ce7-5b70c22e5299

edit: I had forgotten the format=csv part

A better call could be
(https://swd.weatherflow.com/swd/rest/observations/device/168731?day_offset=0&format=csv&token=bcf4754a-886b-4b84-9ce7-5b70c22e5299)
Make sure you set “do not detect data types” as otherwise the values get all screwed up

2 Likes

Sunny, thank you for this. It is rather useful, and for many owners I would guess

1 Like

Hi

It doesnt work for me

I tried this https://swd.weatherflow.com/swd/rest/observations/device/71289?day_offset=0&format=csv&token=84f7e20e-ee09-4006-9e5f-a8422117e844

I get the following error

We encountered an error while trying to connect.

Details: “Web.Contents failed to get contents from ‘https://swd.weatherflow.com/swd/rest/observations/device/71289?day_offset=0&format=csv&token=84f7e20e-ee09-4006-9e5f-a8422117e844’ (404): Not Found”

I dont know why

Regards

Graham

Try https://swd.weatherflow.com/swd/rest/observations/device/192115?day_offset=0&format=csv&token=84f7e20e-ee09-4006-9e5f-a8422117e844

Hi Gary

Yes yours works -mine doesnt

Regards

Graham

I was getting the errors at first too. I realized I was entering my Station ID, not the Device ID. When I changed to Device ID it worked.

Hi jimyouse

Thank you so much - its all working now

I was using station ID too - just shows it pays to read more thoroughly

Regards

Graham

I’m a new Tempest owner as of yesterday. I was able to get my first download just now. Great information! Thanks to all.

Just a question how long does a “Token” last?

Mike

forever, or until you delete it yourself. You can do that on the same page you request a token.

Hi I have tried this download a number of times but get the following response, any help would be appreciated.


Thanks in advance

Mike

https://swd.weatherflow.com/swd/rest/observations/device/193846?day_offset=0&format=csv&token=0ffo3075-2114-4652-9efe-6059fd89af38

Sorry forgot this bit!,
Mike

make sure your device id is correct and that you used the token that you generated. Currently it is not a valid token for that device. The device id should be that of the tempest, not the hub.

This worked well for me. But how does one convert the “timestamp” data to a Date/GMT format. Or alternatively, does the data download include a reference Date/GMT reference to which the “timestamp” data can be related?

it counts in second from the first jan 1970. many online converters are available. Here is one: Unix time converter - Time.is