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…
Edit - I was not clear. My apologies. My customer is producing enormous json-like files, using automation. For this reason they can be enormous; tens of gigabytes or more; I cannot control these files in size or in content. The…
I have a JSON object, some keys of which have names end in .json, like this: { "a.json": "...", .... } The "..." can be either a string which fromjson can decode, or something else. I want a jq filter…