I have a JSON file like this: { "cases": [ {"id": "1", "count": 2, "ignore": "f"}, {"id": "2", "count": 7, "ignore": "o"}, {"id": "3", "count": 11, "ignore": "o"} ] } Doing jq '.cases[] | { "(.id)" : .count }' test.json…
I need to set some new value using jq command in a JSON file. Here is an example of file.json { "Balise1": true, "Balise2": true, "OtherThingEnabled": false, "proxySettings": { "port": 0 }, "mailSettings": {}, "maxRunningActivitiesPerJob": 5, "maxRunningActivities": 5, } In…
I have a json string of the following type { "[A-Z]+": { "k": "test1", "c": "stg1" }, "[a-z]+": { "k": "test2", "c": "stg2" } } The objective is that given a string, if this string matches the regex pattern of…
I am trying to reedit json file to print only subgroups that has any attributes marked as "change": false. Json below: {"group":{ "subgroup1":{ "attributes":[ { "change":false, "name":"Name"}, { "change":false, "name":"SecondName"}, ], "id":1, "name":"MasterTest"}, "subgroup2":{ "attributes":[ { "change":true, "name":"Name" }, {…
I have object in JSON that has the structure as shown below and I want to convert it into a "fake 3D" associative BASH array with the following structure: SHIPS[$mmsi:mmsi]=367513050 SHIPS[$mmsi:lat]=42.380329 ...etc In other words, I want the mmsi value…
I have been trying to find a way to make sure I can pass the key and values of this json in this link dynamically into influxDB. I have the batch file that is below : The json file is…
I have an object that looks like this { "my_list": [ { "name": "an_image", "image": "an_image.com" }, { "name": "another_image", "image": "another_image.com" }, ...<more objects with image property> ], "foo": { "image": "foobar.io" }, "bar": { "image": "bar_image.io" }, ...<more…
I have one stream output stored in csv file, I need help converting csv to json: my csv looks like: cat output.csv "k","a1",1,"b1","c1","d1",1 "l","a2",2,"b2","c2","d2",2 "m","a3",3,"b3","c3","d3",3 "n","a4",4,"b4","c4","d4",4 "o","a5",5,"b5","c5","d5",5 Required output: note: I need key configuration to be added to json. {…
I would like to make a small jq-like function that does get-or-default-if-not-present similar to Python's dict.get(key, default). This is the desired behavior: % echo '{"nested": {"key": "value", "tricky": null}}' > file.json % my-jq nested.key "default" file.json "value" % my-jq nested.tricky…
I'm trying to combine two json files with arrays in common using jq (example below): file1.json { "veg": { "trolley": [ "potato" ], "total_items": [ 1 ] } } file2.json { "veg": { "trolley": [ "lettuce", "tomato" ], "total_items": […