Related
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 3 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 over 3 years ago

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

  • 0 over 3 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 over 3 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 over 3 years ago in reply to 2072285

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

  • 0 over 3 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 over 3 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.