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…
I have 2 json files: a_names.json and b_names.json. File a: { "Names": ["a","b","c"] } File b: { "Names": ["b","c"] } What i tried to do was (say i have a loop with counter ascending from 0): a_names.Names | contains([b_names.Names[.counter]]) And…
I'm trying to filter some journald logs which might have some-what similar information in different keys. journalctl -o json | head -n 1000 | jq '.UNIT, .USER_UNIT, ._SYSTEMD_UNIT Those 3 keys might have the unit name, depending on how the…
I am trying to convert SAFECAST API JSON to a CSV suitable for spreadsheet programs like Excel etc. to prepare some data summaries etc. I have semi-manual WGET script to download several JSON files based on my filters. I am…
Okay so I have blob of data like so ... [ { "sys_replace_on_upgrade": "false", "initial_state": "false", "sys_mod_count": "0", "sys_updated_on": "2020-09-02 13:48:39", "sys_tags": "", "state_label": "Authorize", "sys_class_name": "sttrm_state", "state_sequence": "3", "sys_id": "13fc0801c343101035ae3f52c1d3ae77", "sys_update_name": "sttrm_state_13fc0801c343101035ae3f52c1d3ae77", "sys_updated_by": "admin", "sys_created_on": "2020-09-02 13:48:39", "sys_name": "Authorize",…
So I have 2 json array files one with some simple data (could be any number of servers): [ { "playbook": "simplerun.yml", "server": "abc", "status": "success" }, { "playbook": "simplerun.yml", "server": "def", "status": "success" } etc ] and a master…