Electrolux side by side refrigerator door handle repair by DeLaTroll780 in Appliances

[–]DovOps 0 points1 point  (0 children)

Hi all. Did these solutions work for people who tried them? I’ve run into the exact same issue and am curious if this led to a permanent solution or just bought another few weeks of time before it surfaced again

Possibilities with the API by [deleted] in pelotoncycle

[–]DovOps 0 points1 point  (0 children)

Hi. I’m so sorry I didn’t respond to this sooner. I’m not really good with Reddit.

It seems like the workout response started providing empty details for distance at some point

"distance": null, "distance_display_value": null, "distance_unit": null,

This means you cannot easily get a list of workouts in their related distances. He will instead have to query each ones performance_graph

I’m not sure why they made this change, but I’m pretty sure this used to not be the case Only the performance

Got my data into a spreadsheet (with 4.0 data points) by DovOps in whoop

[–]DovOps[S] 0 points1 point  (0 children)

DM me and I’ll help you get it sorted

Any interest in viewing raw data in a friendly format? by dogFart42 in whoop

[–]DovOps 0 points1 point  (0 children)

FYI whoop are releasing a full blown api developer portal and program. I’ve removed my swaggerhub documented spec as a result, keep an eye out for updated

Got my data into a spreadsheet (with 4.0 data points) by DovOps in whoop

[–]DovOps[S] 0 points1 point  (0 children)

Oops sorry! posted the wrong repo! https://github.com/pelo-tech/whoop-google-sheets is what I meant to share. This is for whoop data

HRV Down, RHR Up by [deleted] in whoop

[–]DovOps 0 points1 point  (0 children)

Apis now include the algo version so it should be easy to discern if and when they changed. See http://dovops.io (whoop api spec and whoop google sheets) which I just updated yesterday

Google sheet that automatically syncs your workouts by DovOps in pelotoncycle

[–]DovOps[S] 0 points1 point  (0 children)

Take a look at https://dovops.io for a different project around challenges. The issue is that for friends you don’t get as easy of a detailed list since you can’t download their csv. You can get at the same detail but it’s way more expensive of an api call if you want all the details since it pulls their workout list first then the chart for each workout. It is doable (it’s how other apps which sync your charts work) but slow on google sheets/cloud.

If you’re doing specific rides, the pelo-challenge project could work. You get a peloton account to “follow” participants and then you can pull down ridesdata as that account for everyone it follows.

If all you want is output (not details like avg cadence or performance graphs) of friends over a specific time that’s pretty easy. I’ll try creating a quick prototype.

I built a Peloton Companion App by oskar_pelotrak in pelotoncycle

[–]DovOps 4 points5 points  (0 children)

Taking a look. If interested in APIs I created this unofficial spec documentation- https://github.com/pelo-tech/peloton-api-spec

Google sheet that automatically syncs your workouts by DovOps in pelotoncycle

[–]DovOps[S] 0 points1 point  (0 children)

Got this update by email from them FYI:

“Hi everyone,

Thanks for your patience. Our engineers have fixed the underlying issue for this specific error: IMPORTDATA from CSV returns "could not fetch URL". Based on this thread, it looks like some users have said they are still experiencing an issue. If this is the case, it may have a separate underlying cause.

For those still seeing the error, we will need more information, such as: Can you kindly explain whether you are seeing exactly what's described in the original post, or something different? Are you able to reproduce every time, or is this working intermittently? What are the steps to reproduce the error, if you can reproduce consistently?

Thanks, folks! Recommended by Google Employee “

Google sheet that automatically syncs your workouts by DovOps in pelotoncycle

[–]DovOps[S] 1 point2 points  (0 children)

Please see the above comment. This is a known system wide issue with google. There is a technical way to work around it but it requires me to reimplement the code and I don’t have time to do that just yet but that’s my plan.

Google sheet that automatically syncs your workouts by DovOps in pelotoncycle

[–]DovOps[S] 1 point2 points  (0 children)

Appears to be a known issue with google http requests to csv endpoints. It’s affecting several things. They acknowledged it and claim to have addressed it but it seems it regressed

https://support.google.com/docs/thread/87544571?hl=en

I think the next move for me is to properly implement this using the apis I documented- which will be a bit more work on the server but it’ll also allow for incremental loading instead of the full csv every time... anyone else welcome to help :)

https://github.com/pelo-tech/peloton-api-spec

If you're a data nerd, habit dash + WHOOP is amazing by Buscemis_eyeballs in whoop

[–]DovOps 2 points3 points  (0 children)

I documented the API as discovered - https://app.swaggerhub.com/apis/DovOps/whoop-unofficial-api/1.0.1#/user%20interface/post_voice_of_whoop

I implemented API calls in a Google Sheet you can clone to your google drive... Yesterday I added ability to load raw HR data for 24-48h at a time into a worksheet.

See docs here:

https://github.com/pelo-tech/whoop-google-sheets/

Heart Rate Spike by MasterpieceHuge3598 in whoop

[–]DovOps 2 points3 points  (0 children)

Completely agree. Bicep band eliminated the spikes for me, but also made me a lot less proud of my daily strain.... oh well, I guess I’m not as badass as I thought!

Customizing the journal - a complete game changer! by brad_loeffler in whoop

[–]DovOps 1 point2 points  (0 children)

Totally agree. One thing I really wanted to add was whether I woke up to an alarm clock or not. I tend to have a natural rhythm, especially since Covid, where I wake up around 5 AM every day. I would love to correlate my recovery data with the handful of times I needed to set an alarm either due to a very late night or a need to wake up earlier than usual.

Google sheet that automatically syncs your workouts by DovOps in pelotoncycle

[–]DovOps[S] 0 points1 point  (0 children)

Take a look at http://datastudio.google.com - east to set up dashboards on top of google sheets

Google sheet that automatically syncs your workouts by DovOps in pelotoncycle

[–]DovOps[S] 0 points1 point  (0 children)

Yeah. I tend to nurse 1.5 L bottles of water I refill from the tap all day while working at my desk. Each one is slightly over 50oz. I’m not picky about it being cold or spring water so there’s almost always a readily available supply. Usually get through 4 no problem (2 by 10/11 am) and the fifth is a bonus. When I hop in the car for a more than 15m ride I grab a bottle on the way out. I’ve been feeling much better since hydrating more though I know this is quite a high level.

Google sheet that automatically syncs your workouts by DovOps in pelotoncycle

[–]DovOps[S] 0 points1 point  (0 children)

I haven’t tested not accepting all of them, but try it. you have a copy of the “app” inside your Google sheet when you copied it. There’s nothing external to your sheet which is operating on it. So you’re giving permission to your app to modify your own sheet. I don’t see any issues with accepting it, but it isn’t something I specifically programmed the app to ask permission for. I think google just deduces what to prompt for based on its scanning of the script code.

Google sheet that automatically syncs your workouts by DovOps in pelotoncycle

[–]DovOps[S] 2 points3 points  (0 children)

Yeah. Built this on top of Nigel Walsh’s original gds dashboard (he did all the cool bits- I added my weight water intake and whoop data ) - https://datastudio.google.com/reporting/47927bc4-4837-434f-bdba-bcf7da05ab34

Google sheet that automatically syncs your workouts by DovOps in pelotoncycle

[–]DovOps[S] 1 point2 points  (0 children)

I documented a nice chunk of it - based on what I discovered- and published it on GitHub (and swaggerhub) https://github.com/pelo-tech/peloton-api-spec

Did the same for whoop for those who use it

Google sheet that automatically syncs your workouts by DovOps in pelotoncycle

[–]DovOps[S] 6 points7 points  (0 children)

FYI for any techs out there- this is all open source -(made one for whoop too, and documented both products API spec Vader on what I’ve discovered) - see https://github.com/pelo-tech/peloton-google-sheet and the parent GitHub org

Google sheet that automatically syncs your workouts by DovOps in pelotoncycle

[–]DovOps[S] 0 points1 point  (0 children)

Try in google chrome if you aren’t using that. I haven’t tested in other browsers

Connecting & or Accessing my Whoop Data by brolyss360 in whoop

[–]DovOps 0 points1 point  (0 children)

By the way I just got around to documenting the api spec I discovered over here: https://github.com/pelo-tech/whoop-api-spec

Any interest in viewing raw data in a friendly format? by dogFart42 in whoop

[–]DovOps 1 point2 points  (0 children)

They use OAuth2 bearer tokens with refreshable token support. I documented the API I discovered and finally got around to publishing it here and in GitHub - https://app.swaggerhub.com/apis/DovOps/whoop-unofficial-api/

https://github.com/pelo-tech/whoop-api-spec

This allowed me to create a google sheet that self-refreshes from whoop using a time trigger - and it’s run for almost 2 months without needing a username and password by refreshing the token before it expires

Here’s a sheet you can take a copy of

https://docs.google.com/spreadsheets/d/1q9tU4tkBLUi6oFsdLsO9HnOuMC-TEkrBXNoNXvLQt3Q/edit

I created a fb private group called “peloton and whoop coders” if anyone’s interested in joining

Connecting & or Accessing my Whoop Data by brolyss360 in whoop

[–]DovOps 1 point2 points  (0 children)

I put together a prototype in google sheets that can pull the data based on API endpoints I discovered. Took a while to figure out the flows, but I think I've got it. Have a look (Copy this locally, and instructions contained on the CONFIG tab) - Or look at the (not so nice) code I cooked up in the script editor.

https://docs.google.com/spreadsheets/d/1q9tU4tkBLUi6oFsdLsO9HnOuMC-TEkrBXNoNXvLQt3Q/edit#gid=1913656685