Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I remove all keys except one with jq?

Given a list of objects, with many keys I don't want:

[{
    "name": "Alice",
    "group": "Admins",
    "created": "2014"
}, {
    "name": "Bob",
    "group": "Users",
    "created": "2014"
}]

How do I filter these objects to only include keys I want?

[{
    "name": "Alice"
}, {
    "name": "Bob"
}]

I've tried jq '.[].name' but that extracts the values, rather than preserving the objects.

like image 277
Wilfred Hughes Avatar asked Jan 08 '15 10:01

Wilfred Hughes


4 Answers

You can use the map() function to filter any key:

jq 'map({name: .name})'

Update

Suggested by @WilfredHughes: The above filter can be abbreviated as follows:

jq 'map({name})'
like image 168
Girish Avatar answered Oct 12 '22 19:10

Girish


you can use map with del if you know the keys you don't want:

jq 'map(del (.group) | del (.created))'
like image 23
Hans Z. Avatar answered Oct 12 '22 19:10

Hans Z.


Another solution without the map function:

jq '[.[] | {name: .name}]'
like image 22
Mauricio Trajano Avatar answered Oct 12 '22 18:10

Mauricio Trajano


The accepted answer (with map) and the equivalent answer by @mauricio-tranjano will, in effect, add the specified key to objects that don't already have it. If that's not the behavior you want, then consider using has(_), e.g.:

$ jq -c 'map( if has("a") then {a} else {} end )'

Input:

[{id:1,a:1}, {id:2}]

Output:

[{"a":1},{}]
like image 22
peak Avatar answered Oct 12 '22 20:10

peak