How can I get a single result object in jq?

Question

I have a JSON file like this:

{ "cases": [ {"id": "1", "count": 2, "ignore": "f"}, {"id": "2", "count": 7, "ignore": "o"}, {"id": "3", "count": 11, "ignore": "o"} ] }

Doing jq '.cases[] | { "\(.id)" : .count }' test.json gives

{ "1": 2 } { "2": 7 } { "3": 11 }

but I need

{ "1": 2, "2": 7, "3": 11 }

How can I get there?

Inian · Accepted Answer · 2023-01-10 13:35:56Z

3

You need to collect the results into an array and add them

.cases | map({ "\(.id)" : .count }) | add

answered Jan 10, 2023 at 13:35

87k15 gold badges166 silver badges183 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ohh, leaving out the [] after cases is the important ingredient!

pmf · Accepted Answer · 2023-01-10 13:48:30Z

Here's an approach using reduce which iteratively builds up the result object:

reduce .cases[] as {$id, $count} ({}; .[$id] = $count)

knittl · Accepted Answer · 2023-01-10 14:14:41Z

from_entries sounds like the obvious choice. First map your input array to an array of key-value pairs, then construct an object from this array:

.cases | map({ key: .id, value: .count }) | from_entries