API Reference: Querying Data

Statistics

Statistics are calculated based on the data available for a specific time period. The data is aggregated according to the time interval specified in your request. This means that if you request data with an hourly interval, the statistics will be aggregated and presented for each hour within the specified time range.

The aggregation process involves summing up or averaging the data points within each interval, depending on the type of statistic being queried. This allows you to see trends and patterns over time, making it easier to analyze the data and draw meaningful insights.

Refer to the different statistics types in the Statistics Types section for more information on how the data is aggregated for each type.

Coordinated Universal Time

The /statistics endpoint uses Coordinated Universal Time (UTC) for all its calculations. This standardization ensures that data is consistent and comparable across different time zones. By using UTC, the API provides a global view of the data, which is crucial for applications that require a uniform time reference. This approach contrasts with the /statistics/daily endpoint, which uses the user’s local timezone for calculations, offering a more personalized view.

curl --request GET \
  --url https://app-api.spikeapi.com/v3/queries/statistics \
  --header 'Authorization: Bearer <token>'

{
  "from_timestamp": "2006-01-02T00:00:00Z",
  "record_ids": [
    "1e85cf8b-ff50-43cf-9276-b0f4c14a500c"
  ],
  "to_timestamp": "2006-01-02T00:00:00Z",
  "values": {
    "calories_burned_active": 123.4567,
    "calories_burned_basal": 123.4567,
    "calories_burned_total": 123.4567,
    "distance_cycling": 123.4567,
    "distance_running": 123.4567,
    "distance_total": 123.4567,
    "distance_walking": 123.4567,
    "heartrate": 123,
    "heartrate_max": 123,
    "heartrate_min": 123,
    "heartrate_resting": 123,
    "sleep_duration_total": 123,
    "sleep_score": 123,
    "steps": 123
  }
}

Authorizations

Authorization

string

header

required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Query Parameters

from_timestamp

string

Start time of the query range in UTC

Examples:

"2006-01-02T15:04:05"

"2006-01-02T15:04:05Z"

to_timestamp

string

End time of the query range in UTC

Examples:

"2006-01-02T15:04:05"

"2006-01-02T15:04:05Z"

exclude_manual

boolean

default:false

Exclude manual metrics from the statistics

interval

enum<string>

required

Interval windows to aggregate data

Available options:

fifteen_minute,

thirty_minute,

hour,

day

types

enum<string>[]

required

Statistics values

Minimum length: 1

Show child attributes

providers

string[] | null

Provider slugs

Response

200

application/json

The response is of type object.

Daily StatisticsDaily Statistics are calculated based on the data available for a specific time period. The data is aggregated for each day based on the user's local timezone. The aggregation process involves summing up or averaging the data points within each interval, depending on the type of statistic being queried. This allows you to see trends and patterns over time, making it easier to analyze the data and draw meaningful insights. <Note> Refer to the different statistics types in the [Statistics Types](/api-docs/statistics_matrix) section for more information on how the data is aggregated for each type. </Note> #### User's Local Timezone The `/statistics/daily` endpoint uses the user's local timezone for all its calculations. This approach ensures that the data reflects the user's actual daily activity patterns, providing a more personalized view. By using the local timezone, the API tailors the data to the user's specific context, which is particularly useful for applications that focus on individual user experiences. This approach contrasts with the `/statistics` endpoint, which uses Coordinated Universal Time (UTC) for calculations, offering a standardized global view.

curl --request GET \
  --url https://app-api.spikeapi.com/v3/queries/statistics \
  --header 'Authorization: Bearer <token>'

{
  "from_timestamp": "2006-01-02T00:00:00Z",
  "record_ids": [
    "1e85cf8b-ff50-43cf-9276-b0f4c14a500c"
  ],
  "to_timestamp": "2006-01-02T00:00:00Z",
  "values": {
    "calories_burned_active": 123.4567,
    "calories_burned_basal": 123.4567,
    "calories_burned_total": 123.4567,
    "distance_cycling": 123.4567,
    "distance_running": 123.4567,
    "distance_total": 123.4567,
    "distance_walking": 123.4567,
    "heartrate": 123,
    "heartrate_max": 123,
    "heartrate_min": 123,
    "heartrate_resting": 123,
    "sleep_duration_total": 123,
    "sleep_score": 123,
    "steps": 123
  }
}

Integrating with SpikeAPI

API Reference: User Management

API Reference: Querying Data

Types and Definitions

Release Notes

Statistics

Coordinated Universal Time

Authorizations

Query Parameters

Response