Untitled Flashcards Set

jq

A lightweight and flexible command-line JSON processor.

jq '.'

Command to view a JSON file in a readable format.

jq 'first(.[])'

Command to read the first JSON element or object from a file.

jq 'last(.[])'

Command to read the last JSON element from a file.

jq 'limit(3;.[])'

Command to read the top 3 JSON elements.

jq '.[2:4]'

Command to read the 2nd and 3rd JSON elements, with left side inclusive and right side exclusive.

jq '.[] | [.balance,.age]'

Command to extract individual values and pipe the output.

jq '.[] | [.age, 65 - .age]'

Command to extract individual values and perform calculations on them.

jq '.[] | [.company, .phone, .address] | @csv'

Command to return a CSV from JSON data.

jq '.[] | [.company, .phone, .address] | @tsv'

Command to return Tab Separated Values (TSV) from JSON.

jq '.[] | [.company, .phone, .address] | join("|")'

Command to return a custom pipeline delimiter for JSON outputs.

jq '.[] | [.balance,(.age | tostring)] | join("|")'

Command to convert numbers to strings and return results with a pipe delimiter.

jq '.[] | [.friends[].name]'

Command to process an array and return names as a list or array.

jq '.[] | [.name.first, .name.last]'

Command to parse multi-level values and return first and last names as a list.

jq 'map(select(.index > 2))'

Command to query values based on a condition.

jq 'sort_by(.age)'

Command to sort JSON elements by age in ascending order.

jq 'sort_by(-.age)'

Command to sort JSON elements by age in descending order.

jq 'sort_by(.age, .index)'

Command to sort JSON elements on multiple keys.