How can I use jq to sort an array of objects by an IPv4 address value as a 32-bit integer rather than alphanumerically? An illustration of what I mean with some extra formatting for visual clarity: $ echo ' {"name":…
I've got two files containing compressed JSONs. All JSONs having the same root fragments "id" and "test": file1.json: {"test":{"a":2},"id":"850303847"} {"test":{"a":3},"id":"2742540872"} {"test":{"a":4},"id":"1358887220"} file2.json: {"test":{"b":3},"id":"850303847"} {"test":{"b":3},"id":"2742540872"} {"test":{"b":4},"id":"1358887220"} file3.json {"test":{"c":8},"id":"850303847"} {"test":{"c":4},"id":"2742540872"} {"test":{"c":5},"id":"1358887220"} I would like to merge these Files based on it's IDs…
How can I make a key value dictionary using jq? If I do: cat api_fm.json | jq -r "[ .[].name, .[].status ]" I receive: [ "plugin", "c_docker_2", "c_docker_5", "c_docker_4", "c_docker_3", "c_docker_1", "Started", "Started", "Started", "Started", "Started", "Started" ] So, I…
I have two simple JSON objects, I'm trying to add a single object from a Bash variable newValArr in order of the corresponding objects to the masterfile.json. They appear as following: newValArr [{ "firstValue": "foo", "secondValue": "bar"}, { "firstValue": "baz",…
I would like to create a json object starting with a list of string in json format as the following [ "nonprod/global/app/sit01", "nonprod/global/app/dev02", "prod/na/app/prod01", "test/eu/app/cust01", "nonprod/global/app/dev03" ] What I would like to obtain is a map of lists of strings…
I have an huge json file (around 7GB) with multiple elements, let's call it data.json. Each element looks like this: {'aggregation_bits': '0xf7fffffffffffdfffffffffffffdfffffffffffffffffffffff7fffffffffffffff7ff', 'data': {'slot': '6436981', 'index': '8', 'beacon_block_root': '0xf8afce2fc26df10061d641633a7256cf47ffa8793771ae83e190e72bf2c5886e', 'source': {'epoch': '201154', 'root': '0x694231a8135b3f546a6fe483ba6b467c686592f6d627aaf06b56ffbd78d75f63'}, 'target': {'epoch': '201155', 'root': '0x2fc0d9f58cda026678d98f010fec13d202eec4ec9ae4dbd57878413a75fe22d7'}}, 'signature':…
I have a json array response below, [ { "user": { "login": "TOM", }, "body": "", "state": "APPROVED", }, { "user": { "login": "JERRY", }, "body": "", "state": "APPROVED", }, { "user": { "login": "ANDY", }, "body": "", "state": "REJECTED",…
I have a file that contains this format: Cus Id: 1234 Cus Name: 10:/John Parks Cus Type: temporary Cus client: tesla;toyota Dept Id: 111 Cus Id: 1235 Cus Name: 10:/William Parks Cus Type: temporary Cus client: Dept Id: 222 How…
From the json change_tasks array below I would like to extract only the values of the key "description" when the key:value is an exact match of "short_description": "01. Project validation". { "change_tasks": [{ "active": "true", "approval": "Not Yet Requested", "description":…
I have the following data : { "storageSummary": "testvalue", "audit1": { "auditScore": 1, "suspensionScore": 1, "password" : "value1", "onlineScore": 0.99743587, "satelliteName": "us2.storj.io:7777" }, "audit2": { "auditScore": 1, "suspensionScore": 1, "password" : "valueX", "onlineScore": 0.9992917, "satelliteName": "saltlake.tardigrade.io:7777" }, "audit3": { "auditScore":…