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.

you can get your device id from settings/stations/status

8 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.

Get your device id from settings/stations/status

4 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.

1 Like

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.

1 Like

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

1 Like