json file as follows:
{"name" :"sam",
"age":23,
"designation":"doctor"}
now i want to add another json object {"location":"canada"} at the end of the file using bash script i have tried echo "{"location":"canada"}">>sample.json
but it results
{"name" :"sam",
"age":23,
"designation":"doctor"} {location:canada}
but i want it to be like this
{"name" :"sam",
"age":23,
"designation":"doctor",
"location":"canada"}
please suggest me
To merge two json objects, you could use jq command-line utility:
$ jq -s add sample.json another.json
Output:
{
"name": "sam",
"age": 23,
"designation": "doctor",
"location": "canada"
}
To update a single attribute:
$ jq '.location="canada"' sample.json
It produces the same output.
To prepend "doctor" to the location:
$ jq '.location = "doctor" + .location' input.json
Output:
{
"name": "sam",
"age": 23,
"designation": "doctor",
"location": "doctorcanada"
}
jq '.location="canada"' sample.json was the only thing that worked, but it didn't append to sample.json; it just prints it to the screen. The whole idea was we wanted to append to a son file. jq -s add keeps giving "parse error: Invalid numeric literal at line 3, column 32". Even if you delete "age":23, you still get "invalid numeric literal". How did this work for you guys?
jq version on my machine: jq --version -> jq-1.5-1-a5b5cbe). All examples print to the screen (you don't want to corrupt your input data while you're adapting the filter for your case. If you don't know how to save the output to a file; ask). I see that someone has upvoted your comment. Does it mean there is an environment where jq doesn't work?
jq ... INPUT > INPUT.tmp && mv INPUT.tmp INPUT stackoverflow.com/questions/36565295/…sed -i '$s/}/,\n"location":"canada"}/' sample.json
Result:
{"name" :"sam",
"age":23,
"designation":"doctor",
"location":"canada"}
sed to manipulate json data with regexes is brittle and unnecessary complicated. There are better alternatives.
'$s/}/,\n"location":"'$loc'"}/'
json.tool.