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", ...…
I have an s3 route and I have to split it in bucket, prefix and key using JQ. "s3://bucket/folder1/folder2/folder3/key.txt" -> { bucket: bucket, prefix: folder1/folder2/folder3, key: key.txt }
I am using cURL inside bash to fetch json data from remote API. Also using jq to parse and loop through the json array to perform additional operations. The response looks like this: [ { "services": [ "HOM" ], "specialServiceId":…