Skip to content

Instantly share code, notes, and snippets.

@inexorabletash

inexorabletash/httparchive query Secret

Created April 21, 2016 19:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save inexorabletash/471d674259cb96f0f9ca363b7e533c70 to your computer and use it in GitHub Desktop.
Save inexorabletash/471d674259cb96f0f9ca363b7e533c70 to your computer and use it in GitHub Desktop.
Download ZIP
HTTPArchive JS Usage Query
Raw
httparchive query
SELECT page, url FROM (
SELECT
page,
url,
JSON_EXTRACT(payload, '$._body') AS hasBody,
JSON_EXTRACT(payload, '$._contentType') AS contentType,
JSON_EXTRACT(payload, '$.response.content.text') AS content
FROM [httparchive:har.chrome_feb_1_2016_requests]
)
WHERE hasBody = 'true'
AND (contentType CONTAINS 'html' OR contentType CONTAINS 'javascript')
AND content CONTAINS 'webkitFoo'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment