Extract connection information from the WebPageTest API and format as a CSV
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env jq -rMf | |
# Filter to extract DNS, Connect, SSL metrics from WebPageTest run JSON | |
# Headers for resulting CSV | |
["DNS", "Connect", "SSL"], | |
# drill down into the runs data | |
( | |
.data.runs | |
# convert the run data into an object and drill down into the run request data | |
| to_entries[].value.firstView.requests[] | |
# only select the request that corresponds to the HTML page (so it has DNS,Connect,SSL data) | |
| select(.final_base_page == true) | |
# build an array of the resulting data we want in the CSV | |
| [(.dns_end - .dns_start), (.connect_end - .connect_start), (.ssl_end - .ssl_start)] | |
) | |
# pass to the CSV formatter | |
| @csv |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment