Using jq how can I replace the name of a key with something else

Question

This should be easy enough... I want to rename a few keys (ideally with jq), whatever I do seems to error though. Here is a json example below:

[  {   "fruit": "strawberry",   "veg": "apple",   "worker": "gardener"  } ] 

I'd like to rename the veg key to fruit2 (or example, whatever is easiest) and also the worker key to job.

I realize this is possible in sed, but I'm trying to get to grips with jq

Answer 1

Use the following jq approach:

jq '[.[] | .["fruit2"] = .veg | .["job"] = .worker | del(.veg, .worker)]' file 

The output:

[   {     "fruit": "strawberry",     "fruit2": "apple",     "job": "gardener"   } ] 

Answer 2

The key (:-) is with_entries. E.g., given a single object:

with_entries(if .key == "veg" then .key = "fruit2" else . end) 

In your case, since you have an array of objects, you could wrap the above in map( ... ).