Bash: iterate over json array and stringyfy the json value

Question

I have a json file(test.json) with following structure

[
  {
     "key1" : "value-1",
     "key2" : {
       "key3" : "value3"
     }
  },
  {
     "key1" : "value-2",
     "key2" : {
       "key4" : "value4"
     }
  }
]

I want to covert the file content into following given structure

[
  {
     "key1" : "value-1",
     "key2" : "{\"key3\":\"value3\"}"     // basically the stringyfy form of json
  },
  {
     "key1" : "value-2",
     "key2" : "{\"key4\":\"value4\"}"     // basically the stringyfy form of json
  } 
]

I tried like following, able to convert key2 into stringyfy JSON but not sure how to update into JSON. Whatever references I am getting from existing stackoverflow question, they are just adding new value to the existing json object. I need to read the existing value and modify the same and then update it to same json array

jq -c '.[]' $BUILD_DIR/test.json | while read i; do
    echo $(jq -r '.key2' <<< "$i") | jq '@json' 
done

Following one is working for me if I just need to direct update the key2 value, This might look very obvious one but I am very new to bash script syntax.

jq '( .[]).key2 |= "foo"' $BUILD_DIR/test.json

jpseng · Accepted Answer · 2022-12-04 23:18:36Z

2

jq 'map(.key2 |= tojson)'

Output

[
  {
    "key1": "value-1",
    "key2": "{\"key3\":\"value3\"}"
  },
  {
    "key1": "value-2",
    "key2": "{\"key4\":\"value4\"}"
  }
]

Demo on jq play

edited Dec 4, 2022 at 23:18

answered Dec 4, 2022 at 21:14

jpseng

2,28012 silver badges23 bronze badges

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

1 Comment

Charles Duffy Over a year ago

Are you sure you want tostring instead of tojson here? I assume that if there were a string in the input, we'd want a JSON-escaped version of that string in the output, instead of just leaving it as-is.

Collectives™ on Stack Overflow

Bash: iterate over json array and stringyfy the json value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related