Skip to main content

as112_top_locations

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

Overview

Nameas112_top_locations
TypeResource
Idcloudflare.radar.as112_top_locations

Fields

The following fields are returned by SELECT queries:

Successful response.

NameDatatypeDescription
metaobjectMetadata for the results.
top_0array

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectlimit, name, dateRange, dateStart, dateEnd, location, continent, formatRetrieves the top locations by AS112 DNS queries.

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
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.
limitintegerLimits the number of objects returned in the response.
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.
namearrayArray of names used to label the series in the response.

SELECT examples

Retrieves the top locations by AS112 DNS queries.

SELECT
meta,
top_0
FROM cloudflare.radar.as112_top_locations
WHERE limit = '{{ limit }}'
AND name = '{{ name }}'
AND dateRange = '{{ dateRange }}'
AND dateStart = '{{ dateStart }}'
AND dateEnd = '{{ dateEnd }}'
AND location = '{{ location }}'
AND continent = '{{ continent }}'
AND format = '{{ format }}'
;