This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Export Data from connect:Health-Statistics - It looks as if I will have to write it from the screen to MS-Excel manually :-)

2072285 over 4 years ago

I simply would like to export complete datasets from my Health-Statistics because the Dashboard shows too few data at the same time. Probably just the Calories and the Steps. With the data I wold like to build table in MS-Excel to that I can annotate individually day by day.

The Export Functionality of the Garmin Connect Web-Page is very poor to say the least:

- You can only export 7 days at once starting with the actual day (so you would have to repeat the export at the same day every week)

- There is no accurate date, only a shortcut for the day. (Sa, So., Mo, Di, Mi) German, as you see ;-) so I will have to add the full date (day/month/year) by hand alternativeless

- Separate Entities for the same day - above all - (e.g. RMR and Active Calories) are in separate lines. Only way to align is a manual drag and drop.

That's how an export of one week of data looks like:

Gesamtkalorien

,Art der Kalorien,Wert

Do,RMR,2271

Fr,RMR,2346

Sa,RMR,2147

So,RMR,2254

Mo,RMR,2346

Di,RMR,2264

Mi,RMR,1813

Do,Aktiv,2044

Fr,Aktiv,920

Sa,Aktiv,2244

So,Aktiv,429

Mo,Aktiv,247

Di,Aktiv,279

Mi,Aktiv,236

The export https://www.garmin.com/de-DE/account/datamanagement/exportdata/ has already taken about 24hrs. So even if I find the data that I am looking for in this data it will be no solution to my problem because I have to wait too long for it.

If someone has a solution please write me.

0 seilogramp over 4 years ago

Found your thread in the Garmin Connect Mobile Windows forum, so moving it to the Garmin Connect Web forum.

0 BunBun! over 4 years ago

&metricId=##

29 - WELLNESS_TOTAL_STEPS
38 - WELLNESS_TOTAL_STEP_GOAL
41 - COMMON_TOTAL_CALORIES
42 - COMMON_ACTIVE_CALORIES
23 - WELLNESS_BMR_CALORIES

Example - 2020-01-01 to 2021-01-01 and IDs: 29, 41, 42 (replace USER):

jQuery.getJSON(
    'https://connect.garmin.com/modern/proxy/userstats-service/wellness/daily/USER?fromDate=2020-01-01&untilDate=2021-01-01&metricId=29&metricId=41&metricId=42',
    (i) => {console.log(i);}
);

Get IDs using F12 -> Network, check data there or by short script above (Console) or write a script with selected values. Similar threads: export data from Connect?, Export CSV.

This prints steps with dates:

jQuery.getJSON(
    'https://connect.garmin.com/modern/proxy/userstats-service/wellness/daily/USER?fromDate=2020-01-01&untilDate=2021-01-01&metricId=29',
    (i) => {
        i.allMetrics.metricsMap.WELLNESS_TOTAL_STEPS.forEach( (d) => {console.dir(d.calendarDate, d.value)} );
    }
);

0 2072285 over 4 years ago in reply to BunBun!

Thank you, looks as if it is what I am looking for. I will try it out.

What is the framework / application in which this code runs and can I install it on a windows PC?

Thanks again

0 BunBun! over 4 years ago in reply to 2072285

F12 -> Console, in a web-browser after log-in to the Connect website.

0 2072285 over 4 years ago in reply to BunBun!

Looks as if I am close but it does not work yet.

I am logged in, See my personal Statistics on the Web-Page. Using Firefox, Push F12 and paste the follwing Text into the Console:

jQuery.getJSON(
'connect.garmin.com/.../TisIsMyUsername
function(i){console.log(i);}
);

Assuming that ThisIsMyUserName is my real Username on the Site.

I get the Following Response

[HTTP/2 403 Forbidden 324ms] (

The HTTP 403 Forbidden client error status response code indicates that the server understood the request but refuses to authorize it.

This status is similar to 401, but in this case, re-authenticating will make no difference. The access is permanently forbidden and tied to the application logic, such as insufficient rights to a resource.)

Which piece of the puzzle is still missing?

0 BunBun! over 4 years ago in reply to 2072285

Looks like a wrong user name, it needs to be the same as in your profile URL, not a display name. Some users have normal names, some have ID string. You can also check the Network tab and see how it's downloaded when using the website's interface.