speed_top_locations

Creates, updates, deletes, gets or lists a speed_top_locations resource.

Overview

Name	speed_top_locations
Type	Resource
Id	cloudflare.radar.speed_top_locations

Fields

The following fields are returned by SELECT queries:

list

Successful response.

Name	Datatype	Description
meta	object	Metadata for the results.
top_0	array

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select		limit, name, dateEnd, asn, location, continent, orderBy, reverse, format	Retrieves the top locations by bandwidth, latency, jitter, or packet loss, from the previous 90 days of Cloudflare Speed Test data.

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.

Name	Datatype	Description
asn	array	Filters 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.
continent	array	Filters 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.
dateEnd	array	End of the date range (inclusive).
format	string	Format in which results will be returned.
limit	integer	Limits the number of objects returned in the response.
location	array	Filters 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.
name	array	Array of names used to label the series in the response.
orderBy	string	Specifies the metric to order the results by.
reverse	boolean	Reverses the order of results.

SELECT examples

list

Retrieves the top locations by bandwidth, latency, jitter, or packet loss, from the previous 90 days of Cloudflare Speed Test data.

SELECT
meta,
top_0
FROM cloudflare.radar.speed_top_locations
WHERE limit = '{{ limit }}'
AND name = '{{ name }}'
AND dateEnd = '{{ dateEnd }}'
AND asn = '{{ asn }}'
AND location = '{{ location }}'
AND continent = '{{ continent }}'
AND orderBy = '{{ orderBy }}'
AND reverse = '{{ reverse }}'
AND format = '{{ format }}'
;