Data queries
Last updated
Was this helpful?
Last updated
Was this helpful?
Two of the Data queries routes below manage quarantined traffic sources. The rest are for retrieving traffic data; for instructions on using them, see API access to traffic data.
Retrieve traffic data using 'filters' parameter, explained at https://gb.docs.reblaze.com/reference-information/api/api-access-to-traffic-data
Filters for request in format selected below (JSON or query string)
{"AND":[{"field":"timestamp","op":"between","value":["2024-06-06 09:31:00","2024-06-06 09:36:00"]},{"field":"status","op":"eq","value":301}]}
if set to true the request will return rendered SQL without running it, for debug purposes
true | false
Database to get data from
bigquery
bigquery
syntax of query
json
syntax of query
json
json
, string_query
Database to get data from
bigquery
bigquery
syntax of query
json
Get quarantined list
Database to get data from
mongodb
mongodb
Syntax of query
string_query
string_query
Get stats (time_period, counter, hostname, bandwidth, latency) using 'filters' parameter, explained at https://gb.docs.reblaze.com/reference-information/api/api-access-to-traffic-data
Filters for request in format selected below (JSON or query string)
{"AND":[{"field":"timestamp","op":"between","value":["2024-06-06 09:31:00","2024-06-06 09:36:00"]},{"field":"status","op":"eq","value":301}]}
if set to true the request will return rendered SQL without running it, for debug purposes
true | false
Database to get data from
bigquery
bigquery
syntax of query
json
json
, string_query
Database to get data from
bigquery
bigquery
Get timeline (time_period, sessions, remote_addr, all_hits, blocked, origin_blocked, challenge, is_human, statuses stats, origin statuses stats, bytes_sent) using 'filters' parameter, explained at https://gb.docs.reblaze.com/reference-information/api/api-access-to-traffic-data
Filters for request in format selected below (JSON or query string)
{"AND":[{"field":"timestamp","op":"between","value":["2024-06-06 09:31:00","2024-06-06 09:36:00"]},{"field":"status","op":"eq","value":301}]}
if set to true the request will return rendered SQL without running it, for debug purposes
true | false
Database to get data from
bigquery
bigquery
syntax of query
json
syntax of query
json
json
, string_query
Database to get data from
bigquery
bigquery
syntax of query
json
Get topx stats using 'filters' parameter, explained at https://gb.docs.reblaze.com/reference-information/api/api-access-to-traffic-data
Filters for request in format selected below (JSON or query string)
{"AND":[{"field":"timestamp","op":"between","value":["2024-06-06 09:31:00","2024-06-06 09:36:00"]},{"field":"status","op":"eq","value":301}]}
if set to true the request will return rendered SQL without running it, for debug purposes
true | false
Database to get data from
bigquery
bigquery
syntax of query
json
json
, string_query
Database to get data from
bigquery
bigquery
Delete record(s) from quarantined list
Database to get data from
mongodb
mongodb
Syntax of query
json
json
Retrieve traffic data using 'filters' parameter, explained at https://gb.docs.reblaze.com/reference-information/api/api-access-to-traffic-data
Filters for request in format selected below (JSON or query string)
{"AND":[{"field":"timestamp","op":"between","value":["2024-06-06 09:31:00","2024-06-06 09:36:00"]},{"field":"status","op":"eq","value":301}]}
if set to true the request will return rendered SQL without running it, for debug purposes
true | false
if set to true the query will be saved in the query history
true | false
Database to get data from
bigquery
bigquery
syntax of query
json
syntax of query
json
json
, string_query