How do I review historical strength data?

3330951 11 days ago

Ask: To see how much I have been lifting for how many reps on a given date for a given exercise.

Specifically I've been trying to solve this problem by parsing the activity summary JSON from my data management export. I have just spent 2+ hours browsing github and writing python to no avail.

Currently the best option I have identified is not practically workable: I would have to download each file from each strength activity individually and then append them. The CSV activity summary download on Web does not include any weights, even though it has sets and reps!!

Can I get some python code? Or can we get weights added to the CSV activity summary export for strength exercises?

Top Replies

trux 9 days ago in reply to 3330951 +1

In that case you can use the 4 weeks report (https://connect.garmin.com/app/report/-2/strength_training/last_four_weeks). It lists each workout. And you can navigate to the left, if you want to see the data…

All Replies

0 e7andy 10 days ago

Have you tried the Strength training report: https://connect.garmin.com/app/report/-2/strength_training/last_year

0 3330951 10 days ago in reply to e7andy

Ah this is also very close to what I want, but not quite. I would like at least the last 2 years, though ideally I could look at the full history of my data that is available. Also it appears that it aggregates the workouts by month rather than by activityID, so we get an output that is "Total sets and Total Volume by Month." If there were an option for me to customize the query and then export from the UI that would be very helpful!

0 trux 9 days ago in reply to 3330951

In that case you can use the 4 weeks report (https://connect.garmin.com/app/report/-2/strength_training/last_four_weeks). It lists each workout. And you can navigate to the left, if you want to see the data of previous periods.

0 3330951 8 days ago in reply to trux

Unfortunately this is still not *quite* what I need. Although I can look and see details at the exercise level, the first issue is that it only goes back one year. The second issue is that there is no place where I can see the max weight that I lifted without clicking into each session individually. It shows the total reps and total volume for each session, but not the weight for each set.

0 trux 8 days ago in reply to 3330951

3330951 said:
the first issue is that it only goes back one year.

It goes back as far as you want, just not in one chunk. You can only see 1 year (or 12w, 4w, or 7d) at a time, but you can see the previous periods too, by navigating to the left:

Unfortunately, that's all what is available right now. If you need more, you have couple of options:

Suggest a change to Garmin at Share Ideas | Garmin (and wait a few years to see whether they implement it)
Find a 3rd party app reading data from Garmin's API and doing what you need
Export and merge all individual periods, and process them in Excel, or in a database program
If you have some experience with JavaScript coding, use the browser Console to pull the JSON data for the full period, and process the data programmatically

0 3330951 7 days ago in reply to trux

Parsing the JSON has been a struggle for me, do you know if there is a repo or program somewhere that will have code for doing that?