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

Inconsistent Columns In Garmin Connect Export All Activities

I do an export of all activities into a CSV file once a week or so. It seems that the columns that appear are not consistent.

Sometimes speed data appears, sometimes it does not.

Sometimes running and cycling cadence (max and average) appear correctly, and sometimes the cycling data is mislabelled as a second instance of running data.

I am downloading all of this into a program which parses the data, but since the columns are not consistent, that's a real problem.

What can I do?

-- Rich

0 BunBun! over 4 years ago

You can write a script to print values you need and formatted as needed. From the Console (F12). All available values can be checked at the Network tab. Below example prints ID, name and start time for 10 newest. To make it as CSV you would need to add separators.

jQuery.getJSON(
    'https://connect.garmin.com/modern/proxy/activitylist-service/activities/search/activities?limit=10',
    (act_list) => {
        act_list.forEach((act) => {
            console.dir(act.activityId, act.activityName, act.startTimeLocal)
        })
    }
)

Also you can export run and bike separately by selecting an activity's type before exporting.