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…
I get the contents of a text file into an array and then sequentially get the elements of the array and try to add the elements to the json: #!/bin/bash JSON=$(jq -n '') readarray -t array < ./station.sample count=0 for…
I'm trying to get jq to generate an object whose keys are computed. This didn't work: $ jq -n --arg key foo '{} as $o | $o[$key] = 42' jq: error (at <unknown>): Invalid path expression near attempt to access…
I have a json file like this, I woiuld like to have a jq based solution to transform this: { ... fields1 ... "any": [], "other": 1, "aa.2": "second.", "aa.1": "first ", ... fields2 ... "bla.bla.0": "aa", "bla.bla.2": "bb", ...…