Strava
The Qlik Strava connector uses the Strava API V3 to fetch your athletic activity stats from Strava.
Ways to access your data
To access your Strava data, you need to authenticate the connector with your Strava account credentials. After you create a connection and select Strava as your data source, you are redirected to a Strava login page. Log in with your credentials to retrieve an authentication code, and enter it into the connector.
Creating a data source connection
Loading data from tables
After you authenticate the connector with your account credentials, you can use the following tables to select and load data.
Table data is displayed in the following formats:
- Distance and elevation: meters
- Speed: meters per second
- Time: seconds
| Table | Available in | Description |
|---|---|---|
| Stats | Диспетчер данных and Редактор загрузки данных | List the stats of your most recent, year-to-date, and all-time activities. |
| Activities | Диспетчер данных and Редактор загрузки данных | View the activities for the authenticated athlete. |
| Athlete | Диспетчер данных and Редактор загрузки данных | View a summary for the authenticated athlete. |
|
KOMs |
Диспетчер данных and Редактор загрузки данных | Returns segment efforts representing overall King/Queen of the Mountain (KOMs/QOMs) and course records held by the authenticated athlete. Yearly KOMs/QOMs are not included. |
| ListClubs | Диспетчер данных and Редактор загрузки данных | Returns a list of the clubs whose membership includes the authenticated athlete. |
| ClubActivities | Редактор загрузки данных | Retrieve recent activities from members of a specific club. The authenticated athlete must belong to the requested club. |
| ClubMembers | Редактор загрузки данных | Returns a list of the athletes who are members of the specified club. |
| Gear | Редактор загрузки данных | Returns details of the specified gear. The authenticated athlete must own the gear. |
| ListRoutes | Диспетчер данных and Редактор загрузки данных | Returns routes created by the authenticated athlete. |
| RouteSegments | Редактор загрузки данных | Returns segment data for the specified route. |
| ListStarredSegments | Диспетчер данных and Редактор загрузки данных | List of the authenticated athlete's starred segments. |
| GetSegment | Редактор загрузки данных | Returns the specified segment. |
| SegmentEfforts | Редактор загрузки данных | Returns a set of the authenticated athlete's segment efforts for a given segment. Requires a subscription. |
To select and load data from a table, enter the required table parameters and click Preview data. Required parameters are marked with an asterisk (*) in the dialog. The table fields are displayed under the Data preview tab. You can select fields individually by selecting the box beside each field name. Select Insert script after you have made your selection.
Creating a connection and selecting data
Working with the Strava API quota limits
The Веб-коннекторы Qlik use the Strava API V3 to extract data from Strava and load it into your Qlik Sense app. While reloading your Strava-based app, you might receive an error message that the connector has reached the Strava API V3 rate limit and that all subsequent API calls will fail until the connector falls back under the throttling limit. If you receive this error message, then you have exceeded one of the API rate limits.
Troubleshooting
You receive an error message that you have reached the API rate limit
Возможная причина
You have exceeded the API limits that are imposed by the Strava API V3.
Предлагаемые меры
To reduce the impact of reaching API rate limits, develop your app with the following in mind:
- Extract only the data you need.
- Reload one Strava-based application at a time.
- Ensure that loops in your script that make API calls do not result in infinite loops.