Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
accept-ch values in http archive latest (desktop)
select url, accept_ch_value
from (
select distinct NET.REG_DOMAIN(url) as url,
# {"name":"Accept-CH","value":"
REGEXP_EXTRACT(payload, r'(?i)Accept\-CH","value":"(.+?)"') as accept_ch_value
JSON_EXTRACT(payload, '$._headers.response') LIKE '%CH-%'
where accept_ch_value is not null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment