Strava Connector Reference

29 metrics41 dimensions

The Strava connector exposes 70 fields (29 metrics, 41 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Strava Fields

Strava activities fields

The activities report of the Strava connector includes 54 fields.

Strava activities fields (activities__achievement_count to activities__start_date_local)

IDTypeNameDescription
activities__achievement_countNUMERICactivities.achievement_countactivities.achievement_count
activities__athleteOBJECTactivities.athleteactivities.athlete
activities__athlete_countNUMERICactivities.athlete_countactivities.athlete_count
activities__average_speedNUMERICactivities.average_speedactivities.average_speed
activities__average_tempNUMERICactivities.average_tempactivities.average_temp
activities__average_wattsNUMERICactivities.average_wattsactivities.average_watts
activities__comment_countNUMERICactivities.comment_countactivities.comment_count
activities__commuteBOOLEANactivities.commuteactivities.commute
activities__device_wattsBOOLEANactivities.device_wattsactivities.device_watts
activities__display_hide_heartrate_optionBOOLEANactivities.display_hide_heartrate_optionactivities.display_hide_heartrate_option
activities__distanceNUMERICactivities.distanceactivities.distance
activities__elapsed_timeNUMERICactivities.elapsed_timeactivities.elapsed_time
activities__elev_highNUMERICactivities.elev_highactivities.elev_high
activities__elev_lowNUMERICactivities.elev_lowactivities.elev_low
activities__end_latlngOBJECTactivities.end_latlngactivities.end_latlng
activities__external_idTEXTactivities.external_idactivities.external_id
activities__flaggedBOOLEANactivities.flaggedactivities.flagged
activities__from_accepted_tagBOOLEANactivities.from_accepted_tagactivities.from_accepted_tag
activities__gear_idTEXTactivities.gear_idactivities.gear_id
activities__has_heartrateBOOLEANactivities.has_heartrateactivities.has_heartrate
activities__has_kudoedBOOLEANactivities.has_kudoedactivities.has_kudoed
activities__heartrate_opt_outBOOLEANactivities.heartrate_opt_outactivities.heartrate_opt_out
activities__idNUMERICactivities.idactivities.id
activities__kilojoulesNUMERICactivities.kilojoulesactivities.kilojoules
activities__kudos_countNUMERICactivities.kudos_countactivities.kudos_count
activities__location_cityTEXTactivities.location_cityactivities.location_city
activities__location_countryTEXTactivities.location_countryactivities.location_country
activities__location_stateTEXTactivities.location_stateactivities.location_state
activities__manualBOOLEANactivities.manualactivities.manual
activities__mapOBJECTactivities.mapactivities.map
activities__max_speedNUMERICactivities.max_speedactivities.max_speed
activities__max_wattsNUMERICactivities.max_wattsactivities.max_watts
activities__moving_timeNUMERICactivities.moving_timeactivities.moving_time
activities__nameTEXTactivities.nameactivities.name
activities__photo_countNUMERICactivities.photo_countactivities.photo_count
activities__pr_countNUMERICactivities.pr_countactivities.pr_count
activities__privateBOOLEANactivities.privateactivities.private
activities__resource_stateNUMERICactivities.resource_stateactivities.resource_state
activities__start_dateTEXTactivities.start_dateactivities.start_date
activities__start_date_localTEXTactivities.start_date_localactivities.start_date_local

Strava activities fields (activities__start_latitude to activities__workout_type)

IDTypeNameDescription
activities__start_latitudeNUMERICactivities.start_latitudeactivities.start_latitude
activities__start_latlngOBJECTactivities.start_latlngactivities.start_latlng
activities__start_longitudeNUMERICactivities.start_longitudeactivities.start_longitude
activities__timezoneTEXTactivities.timezoneactivities.timezone
activities__total_elevation_gainNUMERICactivities.total_elevation_gainactivities.total_elevation_gain
activities__total_photo_countNUMERICactivities.total_photo_countactivities.total_photo_count
activities__trainerBOOLEANactivities.traineractivities.trainer
activities__typeTEXTactivities.typeactivities.type
activities__upload_idNUMERICactivities.upload_idactivities.upload_id
activities__upload_id_strTEXTactivities.upload_id_stractivities.upload_id_str
activities__utc_offsetNUMERICactivities.utc_offsetactivities.utc_offset
activities__visibilityTEXTactivities.visibilityactivities.visibility
activities__weighted_average_wattsNUMERICactivities.weighted_average_wattsactivities.weighted_average_watts
activities__workout_typeNUMERICactivities.workout_typeactivities.workout_type

Strava athlete_stats fields

The athlete_stats report of the Strava connector includes 11 fields.

IDTypeNameDescription
athlete_stats__all_ride_totalsOBJECTathlete_stats.all_ride_totalsathlete_stats.all_ride_totals
athlete_stats__all_run_totalsOBJECTathlete_stats.all_run_totalsathlete_stats.all_run_totals
athlete_stats__all_swim_totalsOBJECTathlete_stats.all_swim_totalsathlete_stats.all_swim_totals
athlete_stats__biggest_climb_elevation_gainNUMERICathlete_stats.biggest_climb_elevation_gainathlete_stats.biggest_climb_elevation_gain
athlete_stats__biggest_ride_distanceNUMERICathlete_stats.biggest_ride_distanceathlete_stats.biggest_ride_distance
athlete_stats__recent_ride_totalsOBJECTathlete_stats.recent_ride_totalsathlete_stats.recent_ride_totals
athlete_stats__recent_run_totalsOBJECTathlete_stats.recent_run_totalsathlete_stats.recent_run_totals
athlete_stats__recent_swim_totalsOBJECTathlete_stats.recent_swim_totalsathlete_stats.recent_swim_totals
athlete_stats__ytd_ride_totalsOBJECTathlete_stats.ytd_ride_totalsathlete_stats.ytd_ride_totals
athlete_stats__ytd_run_totalsOBJECTathlete_stats.ytd_run_totalsathlete_stats.ytd_run_totals
athlete_stats__ytd_swim_totalsOBJECTathlete_stats.ytd_swim_totalsathlete_stats.ytd_swim_totals

Strava other fields

The Strava connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

IDTypeNameDescriptionReport
data_fetched_atTIMESTAMPData fetched atUTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date