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":…
I have the following dataset : { "data": { "system": [ { "login": "vault keystore password", "password": "123456" }, { "login": "vault keystore masked", "password": "MASK-789101112" }, { "login": "vault salt", "password": "toto" }, { "login": "vault iteration", "password": "10"…
There is JSON like below: { "data": [ { "a": 1, "d": 2, "c": 3, "b": 4 }, { "a": 5, "d": 6, "c": 7, "b": 8, "e": 9 } ] } I want to transform it to the table…