I'd like to default values in place on jq, and return root document. What I have (note that some property is missing from the inner object): [{"foo":{}},{"foo":{"a":1}},{"foo":{"b":4,"c":23}},{"foo":{"a":15,"b":2,"c":33}}] What I want (default missing property with 0): [ { "foo": { "a":…
Consider the following JSON having a list of key-value pairs { "session1": 128, "session2": 1048596, "session3": 3145728, "session4": 3145828, "session5": 11534338, "session6": 11544336, "session7": 2097252 } The key is a session identifier, and the value is the length of the…
Using jq how can i change the value of a key? I am trying to change the value of a key based on the length of the key. But it seems to not work as expected. echo '[{"kiwi": 3 },…
I want to merge two JSON objects that has a common key Object A { "extensions": { "app_name": "extensions-prod" }, "plugins": { "app_name": "plugins-prod" } } Object B { "plugins": { "project_name": "plugins-prod" } } Desired output: { "plugins": {…
I am trying to group the duplicates from the following json by id, but remove duplicates . Here is the json: { "intId": "97210f2c23f45b55569f32309105f395c94", "extId": "39e9588ee62d1cccc711d75ff86c5570", "name": "generic name", "users": { "186-1": { "userKey": "186-1", "extId": "186", "intIds": { "w_eyvyfghz844o":…
I'm new in using jq tool. I have a json file extracted from mongodb database to be formatted into csv: json data in foo.json { "_id" : "8888888888", "unitcode" : "Unit123", "purpose" : "Validate", "request" : { "url" : "Brocolli",…
I have a json object like: { "Nemo": [ 3694756688, 3694756832, 3694756650 ], "Firefox": [ 3694756795, 3694756407, 3694756412, 3694756395 ], "Codium": [ 3694756035, 3694756383, 3694756378 ], "Terminals": [ 3694756804, 3694756802, 3694756428 } I need output like: 3694756688 3694756832 3694756650 3694756795…
How do you use jq to detect and report duplicate object keys? For example, the following JSON has duplicate key on .a. { "a":{ "b": 1 }, "a":{ "c": 1 } } I think using --stream is required but I…
I have the issue I have some files that have as content multiple key value pairs that I'd like to transform into multiple arrays. Let me illustrate what I mean with some produced examples. First the content of the files:…
When I group and add (read merge) objects based on a value I would like to have certain attributes be concatenated together instead of the default "object on the right wins" behavior. demo Put another way I would like the…