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 | 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 | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |
Windsor vs Coupler.io
