Skip to content

Instantly share code, notes, and snippets.

Embed
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
from
`httparchive.latest.requests_desktop`
where
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