Strava Connector Reference

29 metrics40 dimensions

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


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)

ID Type Name Description
activities__achievement_count NUMERIC activities.achievement_count activities.achievement_count
activities__athlete OBJECT activities.athlete activities.athlete
activities__athlete_count NUMERIC activities.athlete_count activities.athlete_count
activities__average_speed NUMERIC activities.average_speed activities.average_speed
activities__average_temp NUMERIC activities.average_temp activities.average_temp
activities__average_watts NUMERIC activities.average_watts activities.average_watts
activities__comment_count NUMERIC activities.comment_count activities.comment_count
activities__commute BOOLEAN activities.commute activities.commute
activities__device_watts BOOLEAN activities.device_watts activities.device_watts
activities__display_hide_heartrate_option BOOLEAN activities.display_hide_heartrate_option activities.display_hide_heartrate_option
activities__distance NUMERIC activities.distance activities.distance
activities__elapsed_time NUMERIC activities.elapsed_time activities.elapsed_time
activities__elev_high NUMERIC activities.elev_high activities.elev_high
activities__elev_low NUMERIC activities.elev_low activities.elev_low
activities__end_latlng OBJECT activities.end_latlng activities.end_latlng
activities__external_id TEXT activities.external_id activities.external_id
activities__flagged BOOLEAN activities.flagged activities.flagged
activities__from_accepted_tag BOOLEAN activities.from_accepted_tag activities.from_accepted_tag
activities__gear_id TEXT activities.gear_id activities.gear_id
activities__has_heartrate BOOLEAN activities.has_heartrate activities.has_heartrate
activities__has_kudoed BOOLEAN activities.has_kudoed activities.has_kudoed
activities__heartrate_opt_out BOOLEAN activities.heartrate_opt_out activities.heartrate_opt_out
activities__id NUMERIC activities.id activities.id
activities__kilojoules NUMERIC activities.kilojoules activities.kilojoules
activities__kudos_count NUMERIC activities.kudos_count activities.kudos_count
activities__location_city TEXT activities.location_city activities.location_city
activities__location_country TEXT activities.location_country activities.location_country
activities__location_state TEXT activities.location_state activities.location_state
activities__manual BOOLEAN activities.manual activities.manual
activities__map OBJECT activities.map activities.map
activities__max_speed NUMERIC activities.max_speed activities.max_speed
activities__max_watts NUMERIC activities.max_watts activities.max_watts
activities__moving_time NUMERIC activities.moving_time activities.moving_time
activities__name TEXT activities.name activities.name
activities__photo_count NUMERIC activities.photo_count activities.photo_count
activities__pr_count NUMERIC activities.pr_count activities.pr_count
activities__private BOOLEAN activities.private activities.private
activities__resource_state NUMERIC activities.resource_state activities.resource_state
activities__start_date TEXT activities.start_date activities.start_date
activities__start_date_local TEXT activities.start_date_local activities.start_date_local

Strava activities fields (activities__start_latitude to activities__workout_type)

ID Type Name Description
activities__start_latitude NUMERIC activities.start_latitude activities.start_latitude
activities__start_latlng OBJECT activities.start_latlng activities.start_latlng
activities__start_longitude NUMERIC activities.start_longitude activities.start_longitude
activities__timezone TEXT activities.timezone activities.timezone
activities__total_elevation_gain NUMERIC activities.total_elevation_gain activities.total_elevation_gain
activities__total_photo_count NUMERIC activities.total_photo_count activities.total_photo_count
activities__trainer BOOLEAN activities.trainer activities.trainer
activities__type TEXT activities.type activities.type
activities__upload_id NUMERIC activities.upload_id activities.upload_id
activities__upload_id_str TEXT activities.upload_id_str activities.upload_id_str
activities__utc_offset NUMERIC activities.utc_offset activities.utc_offset
activities__visibility TEXT activities.visibility activities.visibility
activities__weighted_average_watts NUMERIC activities.weighted_average_watts activities.weighted_average_watts
activities__workout_type NUMERIC activities.workout_type activities.workout_type

Strava athlete_stats fields

The athlete_stats report of the Strava connector includes 11 fields.

ID Type Name Description
athlete_stats__all_ride_totals OBJECT athlete_stats.all_ride_totals athlete_stats.all_ride_totals
athlete_stats__all_run_totals OBJECT athlete_stats.all_run_totals athlete_stats.all_run_totals
athlete_stats__all_swim_totals OBJECT athlete_stats.all_swim_totals athlete_stats.all_swim_totals
athlete_stats__biggest_climb_elevation_gain NUMERIC athlete_stats.biggest_climb_elevation_gain athlete_stats.biggest_climb_elevation_gain
athlete_stats__biggest_ride_distance NUMERIC athlete_stats.biggest_ride_distance athlete_stats.biggest_ride_distance
athlete_stats__recent_ride_totals OBJECT athlete_stats.recent_ride_totals athlete_stats.recent_ride_totals
athlete_stats__recent_run_totals OBJECT athlete_stats.recent_run_totals athlete_stats.recent_run_totals
athlete_stats__recent_swim_totals OBJECT athlete_stats.recent_swim_totals athlete_stats.recent_swim_totals
athlete_stats__ytd_ride_totals OBJECT athlete_stats.ytd_ride_totals athlete_stats.ytd_ride_totals
athlete_stats__ytd_run_totals OBJECT athlete_stats.ytd_run_totals athlete_stats.ytd_run_totals
athlete_stats__ytd_swim_totals OBJECT athlete_stats.ytd_swim_totals athlete_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.

ID Type Name Description Report
data_fetched_at TIMESTAMP Data fetched at UTC 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.
datasource TEXT Data Source The name of the Windsor connector returning the row
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date