{"id":9554,"date":"2023-07-30T15:44:47","date_gmt":"2023-07-30T13:44:47","guid":{"rendered":"https:\/\/via-internet.de\/blog\/?p=9554"},"modified":"2023-07-30T15:44:54","modified_gmt":"2023-07-30T13:44:54","slug":"jq-cheatsheet","status":"publish","type":"post","link":"https:\/\/via-internet.de\/blog\/2023\/07\/30\/jq-cheatsheet\/","title":{"rendered":"JQ – Cheatsheet"},"content":{"rendered":"\n

<\/a>Installing jq<\/h2>\n\n\n\n

<\/a>On Mac OS<\/h3>\n\n\n\n
brew install jq<\/pre>\n\n\n\n
<\/a>Useful arguments<\/h2>\n\n\n\n
When running jq, the following arguments may become handy:<\/p>\n\n\n\n
Argument<\/th>Description<\/th><\/tr><\/thead>
--version<\/code><\/td>Output the jq version and exit with zero.<\/td><\/tr>
--sort-keys<\/code><\/td>Output the fields of each object with the keys in sorted order.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/a>Basic concepts<\/h2>\n\n\n\n
The syntax for jq is pretty coherent:<\/p>\n\n\n\n
Syntax<\/th>Description<\/th><\/tr><\/thead>
,<\/td>Filters separated by a comma will produce multiple independent outputs<\/td><\/tr>
?<\/td>Will ignores error if the type is unexpected<\/td><\/tr>
[]<\/td>Array construction<\/td><\/tr>
{}<\/td>Object construction<\/td><\/tr>
+<\/td>Concatenate or Add<\/td><\/tr>
–<\/td>Difference of sets or Substract<\/td><\/tr>
length<\/td>Size of selected element<\/td><\/tr>
|<\/td>Pipes are used to chain commands in a similar fashion than bash<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/a>Dealing with json objects<\/h2>\n\n\n\n
Description<\/th>Command<\/th><\/tr><\/thead>
Display all keys<\/td>jq 'keys'<\/code><\/td><\/tr>
Adds + 1 to all items<\/td>jq 'map_values(.+1)'<\/code><\/td><\/tr>
Delete a key<\/td>jq 'del(.foo)'<\/code><\/td><\/tr>
Convert an object to array<\/td>to_entries &#124; map([.key, .value])<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/a>Dealing with fields<\/h2>\n\n\n\n
Description<\/th>Command<\/th><\/tr><\/thead>
Concatenate two fields<\/td>fieldNew=.field1+' '+.field2<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/a>Dealing with json arrays<\/h2>\n\n\n\n
<\/a>Slicing and Filtering<\/h3>\n\n\n\n
Description<\/th>Command<\/th><\/tr><\/thead>
All<\/td>jq .[]<\/code><\/td><\/tr>
First<\/td>jq '.[0]'<\/code><\/td><\/tr>
Range<\/td>jq '.[2:4]'<\/code><\/td><\/tr>
First 3<\/td>jq '.[:3]'<\/code><\/td><\/tr>
Last 2<\/td>jq '.[-2:]'<\/code><\/td><\/tr>
Before Last<\/td>jq '.[-2]'<\/code><\/td><\/tr>
Select array of int by value<\/td>jq 'map(select(. >= 2))'<\/code><\/td><\/tr>
Select array of objects by value<\/td>** jq ‘.[] | select(.id == “second”)’**<\/td><\/tr>
Select by type<\/td>** jq ‘.[] | numbers’ ** with type been arrays, objects, iterables, booleans, numbers, normals, finites, strings, nulls, values, scalars<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
<\/a>Mapping and Transforming<\/h3>\n\n\n\n
Description<\/th>Command<\/th><\/tr><\/thead>
Add + 1 to all items<\/td>jq 'map(.+1)'<\/code><\/td><\/tr>
Delete 2 items<\/td>jq 'del(.[1, 2])'<\/code><\/td><\/tr>
Concatenate arrays<\/td>jq 'add'<\/code><\/td><\/tr>
Flatten an array<\/td>jq 'flatten'<\/code><\/td><\/tr>
Create a range of numbers<\/td>jq '[range(2;4)]'<\/code><\/td><\/tr>
Display the type of each item<\/td>jq 'map(type)'<\/code><\/td><\/tr>
Sort an array of basic type<\/td>jq 'sort'<\/code><\/td><\/tr>
Sort an array of objects<\/td>jq 'sort_by(.foo)'<\/code><\/td><\/tr>
Group by a key – opposite to flatten<\/td>jq 'group_by(.foo)'<\/code><\/td><\/tr>
Minimun value of an array<\/td>jq 'min'<\/code> .See also min, max, min_by(path_exp), max_by(path_exp)<\/td><\/tr>
Remove duplicates<\/td>jq 'unique'<\/code> or jq 'unique_by(.foo)'<\/code> or jq 'unique_by(length)'<\/code><\/td><\/tr>
Reverse an array<\/td>jq 'reverse'<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"
Installing jq On Mac OS Useful arguments When running jq, the following arguments may become handy: Argument Description –version Output the jq version and exit with zero. –sort-keys Output the fields of each object with the keys in sorted order. Basic concepts The syntax for jq is pretty coherent: Syntax Description , Filters separated by a comma will produce multiple independent outputs ? Will ignores error if the type is unexpected [] Array construction {} Object construction + Concatenate or Add – Difference of sets or Substract length Size of selected element | Pipes are used to chain commands in a […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9554","post","type-post","status-publish","format-standard","hentry","category-allgemein"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/9554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/comments?post=9554"}],"version-history":[{"count":1,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/9554\/revisions"}],"predecessor-version":[{"id":9555,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/9554\/revisions\/9555"}],"wp:attachment":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/media?parent=9554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/categories?post=9554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/tags?post=9554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}