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

Question

This should be simple enough ... I want to rename multiple keys (ideally with jq), whatever I do seems to be a bug. Here is a json example below:

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

I would like to rename the veg key to fruit2 (or whatever one may say), as well as the working key to work.

I understand that this is possible in Sed, but I am trying to deal with JQ

+11

json key edit jq

user3229731 Apr 20 17 at 14:17

source to share

2 answers

The key (:-) is with_entries. For example, for one object:

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

In your case, since you have an array of objects, you can wrap this in map( ... )

.

+5

peak Apr 20 17 at 14:37

source to share

RomanPerekhrest · Accepted Answer · 2017-04-20T14:41:40+0000

Use the following jq approach :

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

Output:

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