Skip to main content

roas

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

Overview

Nameroas
TypeResource
Idcloudflare.radar.roas

Fields

The following fields are returned by SELECT queries:

Successful response.

NameDatatypeDescription
metaobject
serie_0object

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectdateStart, dateEnd, metric, asn, location, name, formatRetrieves RPKI ROA (Route Origin Authorization) validation ratios over time. Returns the selected metric as a time series. Supports filtering by ASN or location (country code) — multiple values of the same filter type produce one series per value. If no ASN or location is specified, returns the global aggregate.

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
asnarrayFilters results by Autonomous System Number. Specify one or more ASNs. Multiple values generate one series per ASN.
dateEndstring (date-time)End of the date range (inclusive).
dateStartstring (date-time)Start of the date range (inclusive).
formatstringFormat in which results will be returned.
locationarrayFilters results by location. Specify a comma-separated list of alpha-2 location codes.
metricstringWhich RPKI ROA validation metric to return. validPfxsRatio = ratio of RPKI-valid prefixes (IPv4+IPv6 combined). validPfxsV4Ratio / validPfxsV6Ratio = same, split by IP version. validIpsRatio = ratio of RPKI-valid address space (IPv4 /24s + IPv6 /48s). validIpsV4Ratio / validIpsV6Ratio = same, split by IP version.
namearrayArray of names used to label the series in the response.

SELECT examples

Retrieves RPKI ROA (Route Origin Authorization) validation ratios over time. Returns the selected metric as a time series. Supports filtering by ASN or location (country code) — multiple values of the same filter type produce one series per value. If no ASN or location is specified, returns the global aggregate.

SELECT
meta,
serie_0
FROM cloudflare.radar.roas
WHERE dateStart = '{{ dateStart }}'
AND dateEnd = '{{ dateEnd }}'
AND metric = '{{ metric }}'
AND asn = '{{ asn }}'
AND location = '{{ location }}'
AND name = '{{ name }}'
AND format = '{{ format }}'
;