Skip to main content

iqi_timeseries_groups

Creates, updates, deletes, gets or lists an iqi_timeseries_groups resource.

Overview

Nameiqi_timeseries_groups
TypeResource
Idcloudflare.radar.iqi_timeseries_groups

Fields

The following fields are returned by SELECT queries:

Successful response.

NameDatatypeDescription
metaobjectMetadata for the results.
serie_0object

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectaggInterval, name, dateRange, dateStart, dateEnd, asn, location, continent, interpolation, metric, formatRetrieves a time series (percentiles) of bandwidth, latency, or DNS response time from the Radar Internet Quality Index (IQI).

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
aggIntervalstringAggregation interval of the results (e.g., in 15 minutes or 1 hour intervals). Refer to Aggregation intervals.
asnarrayFilters results by Autonomous System. Specify one or more Autonomous System Numbers (ASNs) as a comma-separated list. Prefix with - to exclude ASNs from results. For example, -174, 3356 excludes results from AS174, but includes results from AS3356.
continentarrayFilters results by continent. Specify a comma-separated list of alpha-2 codes. Prefix with - to exclude continents from results. For example, -EU,NA excludes results from EU, but includes results from NA.
dateEndarrayEnd of the date range (inclusive).
dateRangearrayFilters results by date range. For example, use 7d and 7dcontrol to compare this week with the previous week. Use this parameter or set specific start and end dates (dateStart and dateEnd parameters).
dateStartarrayStart of the date range.
formatstringFormat in which results will be returned.
interpolationbooleanEnables interpolation for all series (using the average).
locationarrayFilters results by location. Specify a comma-separated list of alpha-2 codes. Prefix with - to exclude locations from results. For example, -US,PT excludes results from the US, but includes results from PT.
metricstringDefines which metric to return (bandwidth, latency, or DNS response time).
namearrayArray of names used to label the series in the response.

SELECT examples

Retrieves a time series (percentiles) of bandwidth, latency, or DNS response time from the Radar Internet Quality Index (IQI).

SELECT
meta,
serie_0
FROM cloudflare.radar.iqi_timeseries_groups
WHERE aggInterval = '{{ aggInterval }}'
AND name = '{{ name }}'
AND dateRange = '{{ dateRange }}'
AND dateStart = '{{ dateStart }}'
AND dateEnd = '{{ dateEnd }}'
AND asn = '{{ asn }}'
AND location = '{{ location }}'
AND continent = '{{ continent }}'
AND interpolation = '{{ interpolation }}'
AND metric = '{{ metric }}'
AND format = '{{ format }}'
;