I have ideal JSON: { "environments":[ { "name":"test", "release":"2.0" }, { "name":"prod", "release":"1.0" }, ] } This file could be in any state: It can be empty file with just empty object { } It can have empty "environemnts" array…
There's a lot of discussion to convert JSON to CSV with jq, but can't find my situation. 2 points really blocking me : Get key and value of valuePerDay by row Sort valuePerDay keys to unsure values always in the…
I have a bit of a thorny JSON manipulation problem. I have half a mind to just write a Python program to do it, but I’m wondering if a well-written jq query can solve it more elegantly — partly for…
This is the command I use to pull the info I need: .results | .[] | {id, name: .general.name, platform: .general.platform, site: .general.site.name, ea_site: .extensionAttributes.[] | select(.definitionId=="57").values.[]} When .extensionAttributes.[] | select(.definitionId=="57").values.[] is empty, jq does not display any associated items…
I have the following JSON data : $ cat toto.json { "method": "GET", "path": "/users/sign_in", "status": 500, "exception.class": "NoMethodError", "exception.message": "undefined method `user_azure_activedirectory_v2_omniauth_authorize_path' for #<ActionDispatch::Routing::RoutesProxy:0x00007d6fe7cfd0d0 @scope=#<SessionsController:0x00000000186758>, @routes=#<ActionDispatch::Routing::RouteSet:0x00007d701b857b28>, @helpers=#<Module:0x00007d701b6f38b8>, @script_namer=nil>" } { "method": "GET", "path": "/users/sign_in", "status": 500, "exception.class": "NoMethodError", "exception.message":…
I try to reformat the output of the sensors command: sensors -j ftsteutates-i2c-0-73 { "ftsteutates-i2c-0-73":{ "Adapter": "SMBus I801 adapter at efa0", "VCC 3.3V":{ "in0_input": 3.331 }, "3.3V AUX":{ "in1_input": 3.359 }, "V_IN (12V)":{ "in2_input": 12.012 }, "VBAT 3.0V":{ "in3_input": 2.692…
I have the following json output { "secrets": [ [ "{", " "name": "testSecret",", " "vault-apikey": "kv",", " "vault-value": "sabrinaTest"", "}" ] ] } But I need the output to be a little cleaner and look like this: { "secrets":…
I have this JSON file json1.json: { "a":"val1", "b":"val2", "nest1": { "z": "x", "test": "containval" } } I need to get a new json where elements whose values that contain val are removed, ANY property can have val, this gets…
I have a json array of hundreds of objects and each object contains (among many other fields) two arrays like this and a status indicator: "searchMetaData": {"rrStandard": ["XYZ5.1","6.3"],"ccStandard": ["46d45a68-a930","8cd1dc9a-d6a2"],"status": "complete"} For any object where status is "complete", I want to…
{ "field": "@timestamp", "value": "2024-08-20 23:00:13.426" } { "field": "@message", "value": "Started-1" } { "field": "@timestamp", "value": "2024-08-20 23:00:13.427" } { "field": "@message", "value": "Started-2" } Edited to show that the JSONs are repeating block I have JSONs above which…