Body
Date,Weight,BMI,Fat
"2021-10-29","140.13","20.68","0"
"2021-10-30","140.15","20.69","0"
"2021-10-31","140.17","20.69","0"
I wasn't at home on these days, so I didn't weigh in. These seem to be points on the line between the previous and next weigh-in.
No idea how FitBit calculates BMI or fat percentage.
All from one file:
Archive/NAME/Personal & Account/weight-DATE.json
- One file per 30 calendar days.
- Array of objects, one object per weigh-in. I can assume 0 or 1 per day.
weight
in poundsdate
inMM/DD/YY
bmi
as number
Skip this?
Yes, skip this.
Foods
Date,Calories In
"2021-10-29","0"
"2021-10-30","0"
"2021-10-31","0"
Of these, Garmin Connect seems to accept:
- Steps
- Floors
- Calories as "Active" and "Resting" but I don't know how that maps to Burned vs Activity
Doesn't seem like Distance (outside activities) or minutes turn into anything.
Activities
Date,Calories Burned,Steps,Distance,Floors,Minutes Sedentary,Minutes Lightly Active,Minutes Fairly Active,Minutes Very Active,Activity Calories
"2021-10-29","2,948","13,845","7.92","61","616","246","28","57","1,619"
"2021-10-30","3,132","15,389","8.51","70","678","289","35","53","1,820"
"2021-10-31","3,113","16,322","9.76","69","668","299","10","59","1,820"
Archive/NAME/Physical Activity/calories-DATE.json
- One file per 30 calendar days.
- Array of objects, one object per minute.
dateTime
inMM/DD/YY HH:MM:SS
(rounded to the minute, 24-hr format)value
= count of burned or activity calories?
Archive/NAME/Physical Activity/steps-DATE.json
- One file per 30 calendar days.
- Array of objects, one object per minute.
dateTime
inMM/DD/YY HH:MM:SS
(rounded to the minute, 24-hr format)value
= count of steps
- Pattern follows for these file prefixes:
distance
--> Distance. Don't know value for unit though.altitude
--> Floors. Unit??
Archive/NAME/Physical Activity/sedentary_minutes-DATE.json
- One file per 30 calendar days.
- Array of objects, one object per day.
dateTime
inMM/DD/YY HH:MM:SS
(starting at midnight, 24-hr format)value
= minutes as Minutes Sedentary
- Pattern follows for these file prefixes:
lightly_active_minutes
--> Minutes Lightly Activemoderately_active_minutes
--> Minutes Fairly Activevery_active_minutes
--> Minutes Very Active
So this is the one with all the aggregations.
Garmin Connect did not import this from the sample. Skip it.
Sleep
Start Time,End Time,Minutes Asleep,Minutes Awake,Number of Awakenings,Time in Bed,Minutes REM Sleep,Minutes Light Sleep,Minutes Deep Sleep
"2021-10-31 3:11AM","2021-10-31 9:55AM","350","54","27","404","107","175","68"
"2021-10-30 5:08AM","2021-10-30 11:33AM","332","53","20","385","44","250","38"
"2021-10-29 12:28AM","2021-10-29 8:41AM","447","46","35","493","93","315","39"
These are backwards in the FitBit CSV...
Data not worth keeping before 2020-04.
Archive/NAME/Sleep/sleep-DATE.json
- One file per 30 calendar days.
- Array of objects, one object per sleep event. (Night of sleep or long nap)
startTime
asYYYY-MM-DDTHH:MM:SS.000
in what looks lile local time.endTime
(same)minutesAsleep
minutesAwake
levels.summary.wake.count
--> Number of AwakeningstimeInBed
levels.summary.[light|deep|rem].minutes
--> Minutes (Light, Deep, REM) Sleep
Food Log 20211029
Daily Totals
"","Calories","0"
"","Fat","0 g"
"","Fiber","0 g"
"","Carbs","0 g"
"","Sodium","0 mg"
"","Protein","0 g"
"","Water","0 fl oz"
Food Log 20211030
Daily Totals
"","Calories","0"
"","Fat","0 g"
"","Fiber","0 g"
"","Carbs","0 g"
"","Sodium","0 mg"
"","Protein","0 g"
"","Water","0 fl oz"
Food Log 20211031
Daily Totals
"","Calories","0"
"","Fat","0 g"
"","Fiber","0 g"
"","Carbs","0 g"
"","Sodium","0 mg"
"","Protein","0 g"
"","Water","0 fl oz"
Skip this too.
Data are not worth keeping before 2020-04
Archive/NAME/Physical Activity/exercise-ROW.json
- One file per 100 "exercise log" entries.
- Array of objects, one object per log event.
- Where
hasGps
== TRUE - The
tcxLink
, even when authenticated, will not download a TCX file, it's a webapp with a download link in the menu. logId
to fetch via Web API- With an Oauth grant faked, fetch
https://api.fitbit.com/1/user/-/activities/LOG-ID.tcx
- Where