Decoding OTF Data

Explore

Decoding OTF Data

Ep 4: Data To Go
Ep 4: Data To Go

Entry Date:

7/23/2022

⁠

Idea

Based on

u/Fireislander⁠

u/prettyoaktree⁠

and

u/Zerowind88⁠

’s code, create a Coda doc to export data from Orangetheory without running Python script.

tl;dr

🟢 Copy

this doc⁠

, follow the instructions on the doc, and you can download your workout summary data as CSV.

Legend

⁠
💡 = Insight 🟢 = Do-able by anyone 🟡 = Hack by running Javascript via Chrome Debugger 🔴 = Hack that requires some level of Web coding experience
⁠
⁠

What’s next?

Build better visualization around exported data from Orangetheory.

Raw Notes

⁠

u/Firelslander⁠

has a

Github repo⁠

u/Zerowind88⁠

has a

Python notebook⁠

In theory, I can port the code over to Node, and then create a Coda pack out of it.

Hours passed by in coding, testing & verifying different approaches.

Couple of insights:

💡 It requires two calls to AWS Cognito endpoint to fetch memberUuid .

It’s not the worst, but workable.

💡 To fetch Treadmill and Rower data from Orangetheory, we’ll need to call the performance endpoint:

https://performance.orangetheory.co/v2.4/member/workout/summary⁠

⁠

This endpoint provides a lot of information - Treadmill average speed, max incline, etc. I’m not going to explore this just yet - But the logic is setup to get it working.

Code:

https://github.com/otfplanner/otf-pack/blob/a98cc794b7a84701ceeee7f89fad103e60da4257/pack.ts#L96⁠

⁠

💔 Coda’s Pack SDK does not allow you to connect to multiple domains at the same time - I’ve to request for permission.

I worked around this by splitting the authentication logic to one Pack ((Calling AWS Cognito service) from the Orangetheory API logic.

This is pretty bad from a Dev UX perspective, but workable for now.

💡 Coda allows you to download data directly from a table - This should really help OTFam who wants to explore data without running a single line of Python script.

💡 Ironically, OTF’s workout summary endpoint provides us with minute-by-minute heart rate, but it does not provide the same information when you call the workout details API.

I’ve to stitch it together

like this⁠

There are a lot more I can do to make the visualization better. Maybe Episode 5.

OK. This is probably a good stopping point:

Created & published 2 OTF packs (Written for Coda’s Packs SDK & TypeScript)

OTF: Data Extractor -

https://github.com/otfplanner/otf-pack⁠

⁠

OTF: Authenticator -

https://github.com/otfplanner/otf-auth-pack⁠

⁠

Created a published doc, allowing OTFam to export data directly from Orangetheory’s API without running Python:

https://coda.io/@kennywong/otf-workout-summary-to-go/faq-3⁠

⁠

🎉 🎉 🎉 If you have read this far, check out all the related work other OTFam has done! 🎉 🎉 🎉

Python:

u/Fireislander⁠

u/prettyoaktree⁠

⁠

Jupyter (Google’s Colab):

u/Zerowind88⁠

⁠

Feedback? Got ideas? Found a bug?

Let me know on this

Reddit thread⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.

Ep 4: Data To GoEp 4: Data To Go

Idea

tl;dr

Legend

What’s next?

Raw Notes

Feedback? Got ideas? Found a bug?

Ep 4: Data To Go
Ep 4: Data To Go